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? 
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.
I think this can be done.
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.
Right. This is where I got stuck. You want to filter per color per league.
Before I answer, would you ever have more than 2 leagues?
Yes, any user could be able to create a new league and invite friends.
Hope it is clear 
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:
This is the form response sheet:
This is how the form looks:
The Red checkbox isnât showing due to it already being selected by someone else
When you select a color, all of the other colors will be hidden so you canât select 2 colors.
These are the visibility conditions to show or hide the checkboxes.
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.
@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 
Thatâs what I did.
When Relation Chosen Colors is empty, then it gets me back the COLORS, else, empty again.
Look this in practice:
The Choice component I use our third column I created, the CHOICE COLORS
And yes, I use a filter:
When our IF THEN ELSE Column is empty, then we get out Filtered List
Damn⌠I was tryna discover it all this time. Happy for this!
@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.
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.
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.
Got it. Letâs keep on testing it
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 
any idea?
Not exactly what you were looking for, but youâll at least get the end result you want (no duplicate teams)
Same logical of our booking system. Thatâs a way to do, cool
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/.
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 :
I am close but i donât know what i forget 
If you wana check : Glide
That link doesnât help me. I would need the published 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.
