Multi select for form

Hi there - I would love a way for users to ‘multi select’ multiple options on a form. And then save that input as an array in my sheet. Like apple, banana, pear.

If that’s possible let me know. Right know it doesn’t look like it. It looks like i’ll have to do it 1 by 1 with check boxes.

3 Likes

If you know how many items you would have, you could create a column for each item and use a checkbox component for each item in the app. Then you could use a formula to join all of the columns into one comma delimited list in a new column. If you require a dynamic list of items, then I don’t have a good solution for you. I hope Glide comes out with some sort of checkbox list or a multi-select choice component someday that would work how you describe.

2 Likes

Got it thanks Jeff! That might be a good fix for now.

Dave

Just seeing this post. This would be awesome. Multi select choice component that would save the items as an array in a single cell (like a relation:multiple). Would be a game changer for an admin assigning bulk values to users via multi selected email addresses.

2 Likes

Since this post, they have released the checklist layout. This might work for some situations.

But doesn’t checklist just change the value of a boolean?

@Robert_Petitto Yeah pretty much, but if you wanted to get creative with relations it might have potential, much like your affordability issue. Only downside is having to create a bunch of extra records. I could definitely see some sort of use with a multi-select choice components and a concatenated list in a cell (preferably with a pipe delimiter or some other delimiter). Seeing the new filter has multi-select, it’s definitely in the realm of possibility.

1 Like

Correct. It doesn’t result in an array. Which is what would be needed.