Typically when adding members to a group i could add a new row (for each new member of a group) to a groups table and just indicate the member name and the group they are in, within the same row.
This is quite costly in terms of rows of data that are duplicated. Jim is repeated on multiple rows and the same with all other users.
I would use UserIDs (RowID’s) rather than names. Then you won’t have a problem when you have 3 separate users all named Jim.
You mentioned split list - by that you mean Split Text column, yes? That’s what you need to convert the joined list into an array, and you should be able to use that to create a multiple relation back to your Users table. As long as it is a multiple relation, you should be able to use it as the source of a list/collection component.
Yes, in fact i’m using emails but i didn’t want to post that online so i used names for the example image.
Yes, Split Text Column👍
It’s the weirdest thing, because i have the relation but for some reason it only shows my name as having joined that Group. It doesn’t show any other people that have joined that Group.
Perfect, it works. I think this is going to save me massive amounts of rows, and maybe keep the app more efficient.
But i think there will be other limitations like deleting a member out of a joined list? Will try some trickery!
Thanks again for the help👍
So bummed i didn’t see your messages sooner, i spent the last 4 hours figuring out a trebuchet variation for admins to add users to the group, then took 3 minutes to do it using a choice component. as per yours and Jeff’s suggestion. Looks way better and uses no extra columns since i’m just adding Users Id’s into a Groups “CSV” column.
Anyways, i learn’t a lot and had fun Gliding. Thanks guys👍