How do I have a choice component so that it will allow multiple selections?
It’s not an option at this time.
Just curious, how would you expect the multiple selections to be stored in the sheet?
To store the options:
Option 1, Option 2, Option 3, …
So separate columns that are set up as an array of columns? That sounds like an interesting idea. I suppose glide could impose a limit so you can only select the maximum number of items that match the maximum number of columns. I know some people have mentioned putting all of the values in one cell, separated by a comma, I think I like your idea better and it would work great with everything else in Glide that uses arrays. I suppose having the option to either save all selections in one column or save in an array of multiple columns would be beneficial.
We’ve been thinking about this quite a bit, and have a plan, but it’ll take us a while to implement.
I have a way, but it requires me to show you in screenshots. Allow me some time to put it together.
I did this with what’s available: https://freelance.glideapp.io/
I use Skills 1, Skills 2, …, Skills 10 to capture expertise.
Would be nice that the result would be an Array Column
Just to provide another use case; I’m creating an app where a user can list all the amenities their property has. The selection/option list is very long and there are multiple options. I made a separate list with checklist, and can display easy enough in a table, but can’t make it filter/sort for someone who wants to easily drill down their selection. If there as multiple choice I could simply make the one list, allow multiple choices and push to the results page. I don’t mind if that user has 30 rows of entries, it would work for everything else.
Hi Mark, just checking in on the progress of a “multiple choice” list and the ability to possibly display it in a single cell, separated by day a comma (,)?
Sorry, I can’t give you a timeline on this.
Cool, no problem. Stay safe
This is so much needed guys specially if we need a sellection of a courses as an example for a user interest or anything
Is there any workaround guys ?
I see threw different ways for this to work:
- Comma delimited list in one cell.
- Fill multiple columns that are set up as an array column.
- Create multiple rows. One for each selection.
Each has their advantages and disadvantages. Some have chimed in, but I’m just curious from those that keep asking about this, how would you expect the data to be written to the sheet? Personally, as I stated above, I think it would be most advantageous to write to an array column and set a max limit of selections to match the number of array columns available. Only because it would allow to easily create relations from the the array column.
I’m the meantime, if your choices data is relatively static, you could maybe get away with multiple columns and a checkbox component for each column.
I also think that array column works best, and we can set conditional visibility to make the form looks good when we capture it. It’s my current solution as well.
Just a bit of sharing, there are cases when my clients want checkboxes instead of choice components so I have to do further arrayformulas to take back the real choices from the boolean values that were taken.
I think array column would be neat as well, but it would work like a user specific column where it wouldn’t be written to the sheet. I don’t see how Google Sheets could interpret this…unless one day Glide also recognizes cells with CSVs as an array column…hmmmm
My choices are dynamic totally and its retrieved from an other sheet so I don’t know how this will work because the user has to choose multiple item from this drop down
Great workaround. I wish it was all done in one list, as I’m sure most are, but this is a lot simpler than adding a choice component for all.
Was thinking about this when the Glide Sheets came out, would we be able to actually create an array column inside Glide Sheets and store choices inside that? Would be very nice if we can.
On the other hand, if that’s not supported and we want an array column we still have to revert back to Sheets. Hopefully they can find a way.
Noob, non-data guy question:
I’d like to create a food diary app. I also want to be able to visualize those food items over time in a chart. My rows are dates. If I create a sheet for a pick-list of food items, I can currently select a food item for that day and enter it into the row for that day. Obviously I’d want to be able to add multiple food items. Rather than using one cell in my day row to collect multiple selections, could it reference the food sheet via relations somehow? (I don’t quite understand the power of relations yet).
Also, to be able to do individual food item tracking, will those additional columns of food items for each day need to be on the main sheet? Sounds like I need a column for each food item?
Even without the multiple selection functionality, I could workaround with let’s say 5 choice picklists for breakfast that would fill five columns (some days I might only pick one item leaving four blank cells that day). Another problem I have is how to add / modify that list of food items so users can add new food along the way.
As you can see, I’m a little confused on how to best structure this. Thanks for any insight!