Hi everyone, I would like to use the collection component, as a way to let my users check of items for a order placed inside a form. The options that can be selected are stored in one data table with all the items, and the submissions are stored in a different table. I will be using the button action, to add the values to the table.
My question is: How can I add their multiple selections to the submission table?
I guess it be done using the relation option, but I’m not sure how.
Thank you.
Hi! I think you need Text column for Single_Choice in the user row.
Text column for total choices, also in user row(user table)
Template column which combining Single_Choice and Total_Choice by coma
When user press desired button or item row in collection then you need to Start custom action:
Then you can add content of Total choice to submission table.
In submission table you can split text of Submission Total_Choice by coma
and set Multiple Relation from “split column” to your initial table where choices stored.
Hi Slscustom, thank you for your help!
I have tried a different method, but I’m not sure that it will work.
When a client select a object, the selected column in my object table turns true (user-specific).
And in my submissions table, I have used a Query that shows all that is true from that column. But my issue is now, that the selection no longer is user-specific, and its showing all true objects on all rows. Can that be fixed?
Thank you again, I just started using Glide a week ago 
Okay! You decide long way not sudgested by me. Let’s look:
First fault is you using true/false instead using session unique ID.
To correct this you need pregenerate session(submission) unique id in User row. Then, when user checking item you need write session ID from user row to this row User specific column.
Second fault is to use direct query from user specific column. To correct this you need pre submission to collect(for example by query) in user row all items row ids which marked with session ID and join it to coma separated text and write to submission row.
For now in a submission row you have coma separated list of selected items row IDs. And you can for example query items if item row id is included in this row coma separated items row IDs list.
This is very old trick and in this forum have some very clear videos about it
Can you share a link for one of these videos explaining it? Preferrable one made by glide. Thank you
I think you can read this Choice component MULTI-SELECT: now a dream, soon a reality? - #18 by Roldy
Also you can try and copy this app Multiselection and Preset (glideapp.io)
It’ very clearly describe solution for you.
I havent remember Glide own video, just some folks videos.
Also you can copy my template and explore trick
Tab-Multiple selection in submission · Glide
https://www.vidline.com/share/V0WRHL43GM/4f3e0c018df69c28ca8ce7073279da24
