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!!
