I’m working on an application where I’m showing the user a repeating grid, with a list of phrases that link up with the database.
I’m making it so that when a user marks a phrase as ‘done’, this phase cannot be seen anymore on this repeating grid (as it moves to another repeating grid instead).
However, there are multiple users in the application, so while ‘User A’ marks one item as ‘done’ from this list, I still want ‘User B’ to be able to see the item on the list. So any changes to the list done by one user doesn’t affect how other users see it.
So far I’ve added a field for each phrase (item in the repeating grid) that says "isTicked’ however this affects the item for every other user as well, as it’s shared information.
I’ve also created another data type called UserPhrases which represents the relationship between which user has ‘ticked’ a phase and what the phrase is.
I want to make it so that when a user ticks an item of the repeating grid (shown in the image) it doesn’t affect the other users.
Please see images attached.
Thanks.
(All phrases in the database)
(All users in the database)
(The new datatype I created to store the relationship between user and phrases.
(The current filter that I’ve applied to the data of this repeating group. I’m curious to see if I need to add another filter and what it should be).