# Set Column Value: various inputs in one cell **URL:** \ **Category:** Ask for Help\ **Created:** [February 25, 2022, 12:14pm UTC](https://community.glideapps.com/t/set-column-value-various-inputs-in-one-cell/38955 "2022-02-25T12:14:49Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Thibaud\_Dubrule1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibaud_dubrule1/32/24485_2.png) [@Thibaud\_Dubrule1](https://community.glideapps.com/u/Thibaud_Dubrule1)\ **Post date:** [February 25, 2022, 12:14pm UTC](https://community.glideapps.com/t/set-column-value-various-inputs-in-one-cell/38955/1 "2022-02-25T12:14:49Z")
Hi everybody, I’m creating an option for the people of my company to tell that they’re interested in some events added by other employees. I want the users to say he/she’s interested (increment button) and have their name added to a list and displayed in the event via “set column value” in the same action as the incremented (see image). My only issue is that in the column each new employee saying his interested will erase the value in that column. How could I have this values added within a sell and separated by comma (to then relate to their profile via relation)? Thanks! Thibaud ![Screenshot 2022-02-25 at 12.06.16](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/404eb583e0b519046612468e4849a54b95a6f020.png) ![Screenshot 2022-02-25 at 12.05.57](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/a/3a99366a2f7909cc7c5c7b1e358536ef09920665.png) ---
**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:** [February 25, 2022, 12:54pm UTC](https://community.glideapps.com/t/set-column-value-various-inputs-in-one-cell/38955/2 "2022-02-25T12:54:35Z")
- Create a text column to hold a comma separated list of users (recommend that you use UserID/RowID rather than names) - The above column will initially be empty - Create a template column with something like `{list},{user}` – Replace `{list}` with the contents of the CSV column – Replace `{user}` with the UserID of the logged in user (taken from User Profile) - Create an if-then-else column: – If CSV column is empty, then signed in users UserID – Else template column - When a user taps the button to show they are interested, your action should do a Set Column Values, setting your CSV column to the output of the if-then-else column The increment action is not required. To get a list of interested users: - Create a Split Text column that operates on the CSV column - Create a multi-relation that links the Split Text column to your Users table And to get a count of interested users, simply do a rollup on that split text column. Caveats: - The above solution will not work if your User Profiles table uses Row Owners - There is a small possibility of a concurrency issue - if two or more users tapped the button at _exactly_ the same time, one of them may not get added to the list. ---
**Author:** ![Thibaud\_Dubrule1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibaud_dubrule1/32/24485_2.png) [@Thibaud\_Dubrule1](https://community.glideapps.com/u/Thibaud_Dubrule1)\ **Post date:** [February 25, 2022, 1:45pm UTC](https://community.glideapps.com/t/set-column-value-various-inputs-in-one-cell/38955/3 "2022-02-25T13:45:05Z")
Thanks Darren. Appreciate your feedback. I just need a clarification: that first text column to hold a comma separated list of users (CSV column) how do I set it up? Does it mean I create a basic text column which gets the input of the “Set Column Value” action with the ID of the user? For the moment I still have the same problem of not gathering the list but I feel it’s close. ![Screenshot 2022-02-25 at 13.43.35](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cbf3713af05bc2000248e462ad132b366523144f.png) ---
**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:** [February 25, 2022, 1:46pm UTC](https://community.glideapps.com/t/set-column-value-various-inputs-in-one-cell/38955/4 "2022-02-25T13:46:42Z")
> [@Thibaud\_Dubrule1](#): > > Does it mean I create a basic text column which gets the input of the “Set Column Value” action with the ID of the user? Not the ID of the user, but the output of the if-then-else column. ---
**Author:** ![Thibaud\_Dubrule1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibaud_dubrule1/32/24485_2.png) [@Thibaud\_Dubrule1](https://community.glideapps.com/u/Thibaud_Dubrule1)\ **Post date:** [February 25, 2022, 2:04pm UTC](https://community.glideapps.com/t/set-column-value-various-inputs-in-one-cell/38955/5 "2022-02-25T14:04:28Z")
Solid @Darren_Murphy You’re my hero of the day! Thanks a lot. It works perfect. Now I just have to explore how to be de-interested and remove yourself from the list. ![Screenshot 2022-02-25 at 14.03.39](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/457f17a80d022bca1b268863d247463e4434365c.png) ---
**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:** [February 25, 2022, 3:03pm UTC](https://community.glideapps.com/t/set-column-value-various-inputs-in-one-cell/38955/6 "2022-02-25T15:03:45Z")
> [@Thibaud\_Dubrule1](#): > > Thanks a lot. It works perfect. Now I just have to explore how to be de-interested and remove yourself from the list. I’d probably use the [Remove Element from Array](https://www.glideapps.com/plugins/remove-from) plugin for that. You could use the Split Text column as the array, and have the plugin remove the current users ID from that array. Then convert the result to a joined list, and use that to update your “CSV” column if the user changes their mind. ---
**Author:** ![Thibaud\_Dubrule1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibaud_dubrule1/32/24485_2.png) [@Thibaud\_Dubrule1](https://community.glideapps.com/u/Thibaud_Dubrule1)\ **Post date:** [February 25, 2022, 8:15pm UTC](https://community.glideapps.com/t/set-column-value-various-inputs-in-one-cell/38955/7 "2022-02-25T20:15:39Z")
Perfect Thanks All done and working. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 26, 2022, 8:15pm UTC](https://community.glideapps.com/t/set-column-value-various-inputs-in-one-cell/38955/8 "2022-02-26T20:15:41Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.