# How to add members to a group, using comma separated values in a single cell, instead of extra rows for each new member? **URL:** \ **Category:** Ask for Help\ **Created:** [December 4, 2022, 11:11am UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390 "2022-12-04T11:11:15Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 4, 2022, 11:11am UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/1 "2022-12-04T11:11:15Z")
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. ![Screenshot 2022-12-04 at 12.52.54](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/8/b8c14a6a8156e9dc013f81696f26d977d5645c9d.png) Iv’e been trying to rather add the new members onto a joined list and then split that list and create a relation off that split list back to the users table to get that users details etc ![Screenshot 2022-12-04 at 13.00.19](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/f/affe391cafe75b7f649d3c3f21156f9e1b4cb4bf.png) But for some reason i can’t just add this relation to an inline list OR collection. Anyone know if this is possible or is there a better way to achieve my objectives? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 4, 2022, 11:16am UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/2 "2022-12-04T11:16:22Z")
You’re on the right track. 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. ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 4, 2022, 11:21am UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/3 "2022-12-04T11:21:27Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 4, 2022, 11:26am UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/4 "2022-12-04T11:26:32Z")
> [@ToOFa\_Apps](#): > > 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. Do you have Row Owners applied in your Users Table? ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 4, 2022, 11:28am UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/5 "2022-12-04T11:28:31Z")
I wonder if it’s because the email i’m adding to the joined list is via a template column that’s showing the current signed in user? ![Screenshot 2022-12-04 at 13.26.57](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/96d902a4e2a8533a89b10f333add3a46e665a49f.png) ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 4, 2022, 11:32am UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/6 "2022-12-04T11:32:53Z")
I just checked and it was on. Aaaarrrrgggghhhh!!! Not sure why though, i never use that function. It’s a glide page, i think they automatically create sample pages with that turned on, must be? Okay let me see if this works, will let you know, thanks for the help👍 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 4, 2022, 11:35am UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/7 "2022-12-04T11:35:54Z")
> [@ToOFa\_Apps](#): > > Not sure why though, i never use that function. It’s a glide page, i think they automatically create sample pages with that turned on, must be? Yes, it’s enabled by default when you create a new project. ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 4, 2022, 11:40am UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/8 "2022-12-04T11:40:24Z")
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👍 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 4, 2022, 11:41am UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/9 "2022-12-04T11:41:35Z")
> [@ToOFa\_Apps](#): > > But i think there will be other limitations like deleting a member out of a joined list? > [@dizzy The Trebuchet Method](https://community.glideapps.com/t/the-trebuchet-method/48325): > > In certain situations, a single column has the potential to replace an entire table of data. The Trebuchet Method allows you to create an inline array that allows you to create a SIMPLE one-to-many relationship between two sets of data without the need of a log or submissions table. Examples: Who owns which item Who has registered for an event Who has completed which task Pros: no app bloat no additional rows of data fairly easy to set up Cons: Can only track one data point (eg. who has w… ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 4, 2022, 11:44am UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/10 "2022-12-04T11:44:21Z")
Thanks👍 Will have a look right now✔️ ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 4, 2022, 12:02pm UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/11 "2022-12-04T12:02:50Z")
Classic!!! That’s exactly what i’m looking for. And that method uses a lot less columns than what i’m using👍 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 4, 2022, 2:02pm UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/12 "2022-12-04T14:02:55Z")
If you use a multi-select choice component to add or remove members, it will be a lot easier. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 4, 2022, 3:30pm UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/13 "2022-12-04T15:30:21Z")
Yes. If you, the admin, are adding/removing people, then use a choice component. Only use the trebuchet when you want people to add themselves. ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 4, 2022, 6:35pm UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/14 "2022-12-04T18:35:37Z")
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👍 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 4, 2022, 6:55pm UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/15 "2022-12-04T18:55:54Z")
Learning is invaluable. Even if you don’t use it now, you have an extra toolset for the future. 4 hours to grasp and implement a concept like that is honestly pretty good. ---
**Author:** ![ToOFa\_Apps](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/toofa_apps/32/36816_2.png) [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)\ **Post date:** [December 4, 2022, 9:24pm UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/16 "2022-12-04T21:24:16Z")
Just to be clear, i used the Trebuchet method for users to join a group themselves, and i used the multi-select choice component method for admins to add users to the groups. All works beautifully👍 ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 4, 2022, 9:26pm UTC](https://community.glideapps.com/t/how-to-add-members-to-a-group-using-comma-separated-values-in-a-single-cell-instead-of-extra-rows-for-each-new-member/55390/17 "2022-12-04T21:26:59Z")
Nicely done!