# Choice Component - multiple selections

**URL:** <https://community.glideapps.com/t/choice-component-multiple-selections/5470>\
**Category:** Ask for Help\
**Created:** [March 16, 2020, 9:04pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470 "2020-03-16T21:04:33Z")\
**Posts on this page:** 20\
**Page:** 3

<div class="post-metadata">

**Author:** ![Pablo\_books](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_books/32/2110_2.png) [@Pablo\_books](https://community.glideapps.com/u/Pablo_books)\
**Post date:** [January 21, 2021, 4:44pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/41 "2021-01-21T16:44:30Z")

</div>

Can this not be done with a Checklist style to the Inline List?

---

<div class="post-metadata">

**Author:** ![yann](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yann/32/20115_2.png) [@yann](https://community.glideapps.com/u/yann)\
**Post date:** [January 21, 2021, 7:28pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/42 "2021-01-21T19:28:53Z")

</div>

> [@Pablo\_books](#):
>
> Can this not be done with a Checklist style to the Inline List?

Yes, this is how I am doing it on step 1

---

<div class="post-metadata">

**Author:** ![yann](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yann/32/20115_2.png) [@yann](https://community.glideapps.com/u/yann)\
**Post date:** [January 21, 2021, 9:02pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/43 "2021-01-21T21:02:42Z")

</div>

Looks like I up for another short tutorial 🙂  
@profechef thank you for advice and screenshots!

* * *

### How to make multiple choice criteria

1. Create a special sheet for your choice criteria. Make sure it has a “Row ID” column. Make a **user-specific** text column for checkbox value. (These actions can only be done from the Glide Data Interface, not from the Google Spreadsheet.)

2. On your selection screen use the “Details” layout and add an “Inline list” component with your chosen criteria. Use the “Checklist” layout for this inline list. Then set your checkbox value column as “Check value” in the list settings.

3. Now, go to the Data interface in Glide, to the sheet where your searchable data is. Create four columns.

- A **single-value** column - I called it “Dummy True” because it should have “True” in every row.
- A **relation** column that relates “Dummy True” to the checkbox value on your sheet with criteria.
- A **joined list** column, which takes the data from the previous relation column and joins it in one cell.
- And, finaly, an “ **if-then-else** ” column, with the following condition “if your joined list in the previous column includes the content of the “category” column (or whatever column that contains the criteria for the searchable data), then true”.

Now, just use the last “if-then-else” column as a visibility filter for your list to apply the search results.

---

<div class="post-metadata">

**Author:** ![yann](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yann/32/20115_2.png) [@yann](https://community.glideapps.com/u/yann)\
**Post date:** [February 4, 2021, 12:43pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/44 "2021-02-04T12:43:04Z")

</div>

I found a significant flaw in this approach: the selection (checked boxes) stay for the same user and can’t be cleared :-(((  
Still looking for a solution for that, so far no one knows, what to do.

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [February 4, 2021, 12:49pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/45 "2021-02-04T12:49:40Z")

</div>

Cannot you clear it via a coumpound action?

---

<div class="post-metadata">

**Author:** ![yann](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yann/32/20115_2.png) [@yann](https://community.glideapps.com/u/yann)\
**Post date:** [February 4, 2021, 12:53pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/46 "2021-02-04T12:53:59Z")

</div>

Do you mean custom action? No, unfortunately, I can’t - “Set columns” only works on the first row, and I need to clear the whole column.  
Described in more detail [here](https://community.glideapps.com/t/set-columns-clear-value-action-doesnt-work-the-same-way-everywhere/22136/17).  
If you have an idea of how to do it, that would be great!

---

<div class="post-metadata">

**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:** [February 4, 2021, 1:20pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/47 "2021-02-04T13:20:13Z")

</div>

Here’s my take on “clearing” a whole column.

> [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211):
>
> There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…

---

<div class="post-metadata">

**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\
**Post date:** [February 7, 2021, 10:19pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/48 "2021-02-07T22:19:20Z")

</div>

Definitely, do you agree (or not), that if there is one component that is missing in Glide, it is the multi-select?  
We should organise a sit-in !

---

<div class="post-metadata">

**Author:** ![yann](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yann/32/20115_2.png) [@yann](https://community.glideapps.com/u/yann)\
**Post date:** [February 8, 2021, 10:02am UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/49 "2021-02-08T10:02:18Z")

</div>

Unfortunately, not the only - check out the “Feature request” category 🙂

As far as I remember, the whole story starts with the fact, that the form interface doesn’t have a clear and bright “Submit” button. So there was a workaround to create a form from the regular “details” screen, then another workaround for multiple criteria by @Robert_Petitto, then one more for multiple-choice… and then we hit the wall with the need to clear values before the next search (which is of course done automatically in the “form” interface 🤦‍♂️ )

By the way, there is a solution to that, too, but it’s ugly and unscalable. I cut down the number of categories to the absolute minimum (8) and made on my “Home” sheet two columns for each category - one for the value, the other - a relation to the “Categories” sheet. After that, I was able to make 8 “Set columns” actions - one for each category.

---

<div class="post-metadata">

**Author:** ![dinomeg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dinomeg/32/20650_2.png) [@dinomeg](https://community.glideapps.com/u/dinomeg)\
**Post date:** [February 9, 2021, 11:49pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/50 "2021-02-09T23:49:27Z")

</div>

Do you know if there’s a way to create a relation and a join list using the column _header_ instead of the true/false of each checkbox component?

> [@ThinhDinh](#):
>
> So your ultimate aim is to have a column that includes all “checked” tags, is that correct?

@ThinhDinh I didn’t see your comment up there. Can you create a relation column for multiple check boxes with the headers as tags instead of true/false?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 10, 2021, 12:41am UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/51 "2021-02-10T00:41:33Z")

</div>

Column headers won’t work. You would have to structure the data vertically (in rows) instead of horizontally and make the “checked” a user-specific column.

---

<div class="post-metadata">

**Author:** ![dinomeg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dinomeg/32/20650_2.png) [@dinomeg](https://community.glideapps.com/u/dinomeg)\
**Post date:** [February 10, 2021, 1:17am UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/52 "2021-02-10T01:17:07Z")

</div>

Hm. Ok. That makes sense but I’m still a little lost. So I would have one column be “options” listed vertically like in a choice list and a second column be a user specific y/n column? How would I tie the checkbox column to apply to each item in the first column on an edit screen? I want users to be able to select multiple options on an edit screen in a way that I can relate them so I can add a list join on the detail display screen. I hope that makes sense. I’ve been trying to apply all these multi-choice topics and I just can’t figure out a way to do it properly.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 10, 2021, 2:33am UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/53 "2021-02-10T02:33:57Z")

</div>

> [@dinomeg](#):
>
> How would I tie the checkbox column to apply to each item in the first column on an edit screen?

Can you elaborate more on this part?

---

<div class="post-metadata">

**Author:** ![dinomeg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dinomeg/32/20650_2.png) [@dinomeg](https://community.glideapps.com/u/dinomeg)\
**Post date:** [February 10, 2021, 3:02am UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/54 "2021-02-10T03:02:04Z")

</div>

My only experience with organizing information vertically is for choice components so I’m confused as to how I would attach a check box column to be directly associated with the vertical column of options I’m creating. Does that make sense? I feel like I must be missing something.

On the edit screen, I want to have a list of options to check off that are specific to each user and then be able to create a relation to that user so I can create a list join and display that component on the profile screen so I don’t have to show the whole mess of check boxes.

---

<div class="post-metadata">

**Author:** ![DNA-PC](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@DNA-PC](https://community.glideapps.com/u/DNA-PC)\
**Post date:** [December 22, 2022, 4:41pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/55 "2022-12-22T16:41:14Z")

</div>

I’m as surprised as I am disappointed to learn that Glide doesn’t support neither single nor multi selects.

I find those to be such must-haves in any app, I’m in complete disbelief.  
My experience with Glide has been rather good so far, but this is such a blocker that I stopped learning it and plan on trying out WeWeb next, instead.

Unbelievable, I still hope I missed something obvious.

---

<div class="post-metadata">

**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 22, 2022, 4:50pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/56 "2022-12-22T16:50:57Z")

</div>

Not sure what you’re experiencing, but Glide offers BOTH single and multiselects via the choice component. Are you referring to the data editor? If so, I agree, there needs to be a “selection” column type like Airtable and now Google sheets. @jason

If you’re referring to the choice component, then this might help:

> **[Glide Docs • Choice Component](https://www.glideapps.com/docs/reference/components/choice-component)**
>
> Pick options from a list

---

<div class="post-metadata">

**Author:** ![DNA-PC](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@DNA-PC](https://community.glideapps.com/u/DNA-PC)\
**Post date:** [December 22, 2022, 4:53pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/57 "2022-12-22T16:53:10Z")

</div>

I couldn’t find the “choice” component last time I tried - I’ll retry.

I noticed this because I used Airtable as a data source, and all my single/multi select got converted into “text” in Glide, which was unexpected, and that happened 3 days ago.

_Is it a feature not available on the free plan?_

---

<div class="post-metadata">

**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 22, 2022, 5:01pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/58 "2022-12-22T17:01:38Z")

</div>

Right. Glide doesn’t have a “choice/select” column type in the data editor so, yes, it converts the selections to text if single select and an array column type if multiple select.

 ![CleanShot 2022-12-22 at 12.00.39@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/88db5fb8d37cb1317de22a6cdbe098289a0e822b.png)

@jason, I’ve asked for choice column type a few times over the past year or two. Is this on Glide’s radar for 2023?

---

<div class="post-metadata">

**Author:** ![DNA-PC](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@DNA-PC](https://community.glideapps.com/u/DNA-PC)\
**Post date:** [December 22, 2022, 6:10pm UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/59 "2022-12-22T18:10:06Z")

</div>

Okay, thanks for the clarification, I was so used to having a “Choice column” that I didn’t even think it could be available as a “Component”.

So, I had indeed missed something.

I lack experience to tell whether that’s a good or a bad thing, maybe it’s more flexible than a “choice column” with such design. I guess I’ll need to learn how to use it properly.

---

<div class="post-metadata">

**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 23, 2022, 3:06am UTC](https://community.glideapps.com/t/choice-component-multiple-selections/5470/60 "2022-12-23T03:06:46Z")

</div>

> [@DNA-PC](#):
>
> I lack experience to tell whether that’s a good or a bad thing, maybe it’s more flexible than a “choice column” with such design. I guess I’ll need to learn how to use it properly.

Well, unless you plan on giving your users direct access to your database, I’d think that a choice “column” wouldn’t be very useful at all 😉

[Previous page](https://community.glideapps.com/t/choice-component-multiple-selections/5470.md?page=2)

[Next page](https://community.glideapps.com/t/choice-component-multiple-selections/5470.md?page=4)
