# List of choice with item already taken **URL:** \ **Category:** Ask for Help\ **Created:** [April 23, 2020, 3:58pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697 "2020-04-23T15:58:59Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [April 23, 2020, 3:58pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/1 "2020-04-23T15:58:59Z")
Hello Guyz, 🙂 As you can see i have **choice list** with color (color are from another tab), and i can join my league ( **ligue Bibi** ). In the ligue i chose ( **ligue Bibi** ) **Blue** is already taken, then i would like to withdraw it from the color list. Do you have any idea? 😀 ![TEst2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/bf693bf91395569a42af8a003d0f684589858ffc.gif) ---
**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:** [April 23, 2020, 4:39pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/2 "2020-04-23T16:39:13Z")
I don’t believe that level of filtering is available. It has been a feature request of mine, though…the ability to filter an inline list by another value in the sheet. ---
**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:** [April 23, 2020, 5:01pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/3 "2020-04-23T17:01:49Z")
I think this can be done. - First add relation column on your color sheet that links the color to the color in your Lique sheet. - Then set a filter on your choice to only show if the relation column is empty. ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [April 23, 2020, 9:07pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/4 "2020-04-23T21:07:41Z")
Awesome, thanks it works. Now, next level, i have two differentes leagues : **Ligue Bibi** and **Ligue BOBO** Depends on what ligue i suscribe. I need to make the same thing but for two differents leagues 🤣 In my example, **Black** should appear 🙂 because it was choosen in another league. ![TEST3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/dac86af7adb1c25791852294ed75edb2a3dacd31.gif) ---
**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:** [April 23, 2020, 9:12pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/5 "2020-04-23T21:12:39Z")
Right. This is where I got stuck. You want to filter per color per league. ---
**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:** [April 24, 2020, 4:59pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/6 "2020-04-24T16:59:15Z")
Before I answer, would you ever have more than 2 leagues? ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [April 24, 2020, 7:03pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/7 "2020-04-24T19:03:43Z")
Yes, any user could be able to create a new league and invite friends. 🙂 Hope it is clear 😉 ---
**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:** [April 25, 2020, 4:50am UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/8 "2020-04-25T04:50:53Z")
First thing I would do is change your form a bit. Since you are clicking on a form within the league, then you can automatically pass the league name into the form using the Column Values so you would only have to select a color. If you aren’t in a league detail screen, then I would make sure that’s where you put the form button. I tried but failed to get the color list to exclude chosen colors. If feels so close, but not quite there. This would be so much easier if we could have an inverted relation that return rows that didn’t match. I can easily build a choice component of colors that have already been chosen, but I can’t do the opposite. I was able to do it with checkboxes, but it is ridiculously convoluted and I’m not sure I can adequately explain it all. I’m not using a colors sheet or a choice component at all. This is the League sheet: - I created a template column for each color and joined it with the league name (team in this case) - The I created a relation to the form choice sheet which will link to a similar template column for each color - Finally I create a lookup column for each color the pulls back the checkbox value from the selected color ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/da9b2d659a2191d7a48397c547325997d26426b0.png) This is the form response sheet: - This contains email, league, and a column for each color. - Next I created an if/then column that checks for true in each color column and outputs the color that was selected. - next I created a template column that joins the league name and color from the if/then column - finally I created a color column for each color, which will hold the value from every color that was already selected prior to opening the form. This is so I can pass the lookup columns from the league sheet into the form to be used for visibility conditions on each checkbox. It’s weird, but it works. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3750542964ca9a12fd4cb343187d42656d8c9e72.png) This is how the form looks: The Red checkbox isn’t showing due to it already being selected by someone else ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/fa9ece48f8ab010e8fa0413844a0775645848178.png) When you select a color, all of the other colors will be hidden so you can’t select 2 colors. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/da0360f850be50346815e22b59ac228b1a0aff03.png) These are the visibility conditions to show or hide the checkboxes. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/97772abd14bba633885f689d6e848742767f2cae.png) Like I said, this would have been a whole lot easier with an inverted relation or the ability to filter a relation somehow, but we don’t have that option right now. This is quite a bit of work and I only did this with three colors, so it will be several extra column for you to handle all of your colors. Ultimately, it’s doable, but will be a lot of work. Maybe somebody else has a much easier solution that I missed. Good luck with this. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [April 25, 2020, 5:08am UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/9 "2020-04-25T05:08:03Z")
That’s what I’ve already requested [Values from Column & Clicked](https://community.glideapps.com/t/values-from-column-clicked/6796) ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [April 25, 2020, 6:04am UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/10 "2020-04-25T06:04:55Z")
@noneight @noneight @Robert_Petitto I just found a way to get a list excluding some item😨 ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [April 25, 2020, 6:20am UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/11 "2020-04-25T06:20:17Z")
@noneight @Jeff_Hager @Robert_Petitto Guys, I rethought about this logical and my mind got cleared, see if you understand. Not that hardest logical. It was just in front our face all this time 🤦🏻‍♂️ Lol Take a look. I take the sheet where I create my colors list and made a Relation to my Chosen Colors sheet. Created a third one using the blessed IF THEN ELSE feature 🙏🏼 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/2fbbece3958eee647dabec9dba07f45f6189d1d7.jpeg) That’s what I did. When Relation **Chosen Colors** is empty, then it gets me back the COLORS, else, empty again. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e1eb02189557042fa94069dc7d0060fa9dd117c8.jpeg) **Look this in practice:** ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d6d586b6a95de2d30224d9e596af21f4ba560a0b.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/38af704f974928878b31bf2967679bda866397fb.jpeg) The Choice component I use our third column I created, the **CHOICE COLORS** And yes, I use a filter: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/eca8d0a43c74ced3966e83015bb3adbe2df89ea6.jpeg) When our IF THEN ELSE Column is empty, then we get out **Filtered List** ### BOOMM… 💥🤯 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4d2e02472c2c174c2e3f34a958fe1998a05b2560.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e8fc769409372e74f4f8716b6902d6775ef920c0.jpeg) Damn… I was tryna discover it all this time. Happy for this! ---
**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:** [April 25, 2020, 1:44pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/12 "2020-04-25T13:44:59Z")
@Lucas_Pires That’s similar to what I did initially, but only using the the relation for the filter instead of an if then column. Pretty much the same as yours, but with one less step. > [@Jeff\_Hager](#): > > - First add relation column on your color sheet that links the color to the color in your Lique sheet. > - Then set a filter on your choice to only show if the relation column is empty. The problem we are trying to solve is what if you are using the same color list on 2 different categories (in this case Leagues). Each category can each use up a color once per user/category. This could be solved with separate color lists and conditionally showing one or the other depending on which league you are viewing. The problem is you can have an endless amount of leagues and each one should have access to the same color choice list, but with the list filtered only for that specific league. If you have any ideas for that scenario, I’m all ears. ---
**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:** [April 25, 2020, 1:58pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/13 "2020-04-25T13:58:09Z")
> [@Jeff\_Hager](#): > > The problem we are trying to solve is what if you are using the same color list on 2 different categories (in this case Leagues). Exactly…haven’t had time to work on this, but now that there are more eyes on it, might try my hand at it again. Would still be neat if we had a “I want to…” solutions page that we could reference once we do come up with solutions. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [April 25, 2020, 2:41pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/14 "2020-04-25T14:41:51Z")
Got it. Let’s keep on testing it ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [April 25, 2020, 6:45pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/15 "2020-04-25T18:45:04Z")
Hello Jeff, Thanks for your time, you seem to find smart way 🙂 I follow all the steps but i don’t understant how to set the **“Red/Green/Black already selected”** column When i want set my form, the **“Lkup-Red”** doesn’t appear in my column section ☹ ![Maquette](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a98350f10d3e2e4f6b87c2466c8c441eb75828c7.gif) any idea? 🙂 ---
**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:** [April 26, 2020, 3:04am UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/16 "2020-04-26T03:04:42Z")
Not exactly what you were looking for, but you’ll at least get the end result you want (no duplicate teams) > **[Remove Choices.mp4 (video)](https://drive.google.com/file/d/1yDJiIiPa5-QkUYNYfhQ56z2tUt6SR_Sb/view?usp=sharing)** > > Google Drive file. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [April 26, 2020, 6:47am UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/17 "2020-04-26T06:47:17Z")
Same logical of our booking system. That’s a way to do, cool ---
**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:** [April 26, 2020, 4:35pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/18 "2020-04-26T16:35:54Z")
> [@noneight](#): > > **“Lkup-Red”** doesn’t appear in my column section I think your relations that the lookup columns use in your league sheet are set to multiple. This is bringing back an array of colors, even though only one color is matching. Array’s cannot be set to single value columns. @Robert_Petitto’s idea might be better. I have a similar setup in the Booking example in [https://concepts.glideapp.io/](https://concepts.glideapp.io/). ---
**Author:** ![noneight](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noneight/32/5351_2.png) [@noneight](https://community.glideapps.com/u/noneight)\ **Post date:** [April 26, 2020, 8:26pm UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/19 "2020-04-26T20:26:17Z")
> [@Jeff\_Hager](#): > > I think your relations that the lookup columns use in your league sheet are set to multiple. This is bringing back an array of colors, even though only one color is matching. Array’s cannot be set to single value columns. Hello Jeff, Thanks for your answer. 😀 I am not sure to understand. Indeed, I change my relation from **multiple** to **simple** , but it doesn’t change anything. When i want to set my component i can’t find the **look up** (Lkp in my example) like you did : ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1e1d6e9976b7ae41f9150575aca60318c28975df.png) I am close but i don’t know what i forget 😅 ![TEst2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/01536fb205c517e8c0a01e40b2d13517a04458f6.gif) If you wana check : [Glide](https://go.glideapps.com/app/LUWMr4UAEp2woojUWy0o) ---
**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:** [April 28, 2020, 2:45am UTC](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697/20 "2020-04-28T02:45:34Z")
That link doesn’t help me. I would need the published [xxxx.glideapp.io](http://xxxx.glideapp.io) link. It’s hard to follow the gif since I can’t pause it, but it looks like you might have the columns set up correctly, but it seems like your form button is on the wrong page. You should have the the form button in the details of the League in Ligue Ami Bis. I’m not exactly sure which tab sheet you have your form button on since I don’t see Mes Ligue listed as one of the tabs in your data view, but it looks like it’s on the Lique Ami sheet. The ‘Column Values’ will pull from the detail you are currently viewing, so that’s why you need to be viewing one of the leagues to then click on the form button and get the lookup column values. [Next page](https://community.glideapps.com/t/list-of-choice-with-item-already-taken/7697.md?page=2)