Help- Eliminate a option

Hi Gliders,

need your help!

I have a users sheet, where users create their profile and select their role. I want a way to stop another using taking captain role, once its already taken for that particular team.

(captain role image should not be visible if its taken)

Hola @Amal

I would create a multiple relation from the team to the team. Then create a joined list column from that relation.

Lastly I’d filter that list of roles by role is not included in joined list.

I hope this helps.


thank you! if your suggestion and some extra config was able to achieve, what i was looking for finally!!

1 Like