Limitations on updating one (or multiple) “Element” from the “List” of one “Field” over multiple “Thing”?

Thanks again Benoit, I really appreciate the help.

Here’s a post with the 10,000 list item I’ve mentioned.

To give you more context, the solution I’m looking for needs to work with Algolia and Bubble Privacy Rules. In the example above, I’ve used the Type Article for simplicity, when I should have really talked about a Type “Message” instead. Picturing Slack.com with full message text search (fuzzy search) is a good example of what I’m trying to achieve.

I’m thinking about your idea with a JSON file and all the complexity it would involve, especially with Algolia.

At this point, let’s say I’m trying to rebuild slack with a role management per channel and a fast full text (message) capability.

  1. Would a JSON file per User, holding all the roles for every Message, work with Bubble Security Rule et Algolia ?
    (assuming I’ll build a custom bubble plugin to make it work.)

  2. Is there a way to do it without using a JSON file ?

Just looking for the best path to dig deeper…