I have seen a few threads about this question. Just wondering if anyone has come up with a workaround. Suppose I have a People sheet and a Teams sheet. And a person is joined to a team using a Memberships sheet (with a person_id column and a team_id column). How can I ensure that a person can only …

PART 2: ADMINS ASSIGNING USERS This one features an admin assigning users to teams without repeats: [Glide: Choice Eliminator Part 2] @lkenyan @Lucas_Pires @Jeff_Hager

In my case, an Admin is assigning people to teams.

:confused: Okay…I’ll test. I’ll show you what I have so far and it may spark inspiration.

How many admins are assigning users to teams?

In the current design, there is no limitation to how many users might be given the Admin role.

Ok…I might have a workaround…but it’s a bit more involved with my current method. Video is almost ready.

Neat! Perfect done @Robert_Petitto :clap:

Clever! Thank you so much! Question: can you describe some alternative ways of writing the “selected user” to the column in the Admin sheet? Asking because in my early experimentation with using Glide for a couple of apps, I’m encountering this pattern several times. Wondering about maybe additiona…

Can someone in Glide give this man, @Robert_Petitto , a job please? :thinking:

@Robert_Petitto - thanks for all these videos I’m your #1 fan (I even watched the ipad return procedures video!) Kevin in VA

How to eliminate choices after they've been selected: Many-to-many relations

Ask for Help

Robert_Petitto May 14, 2020, 4:48pm 14

PART 1: USERS ASSIGNING THEMSELVES

Here’s the video on how a user can sign themselves up for unique teams:

Eliminate choices after they've been selected: Many-to-many relations

Clever ways to filter out Choice options on two dups?

🥇 Creating Private Leaderboards

Topic		Replies	Views
Eliminate choices after they've been selected: Many-to-many relations Ask for Help	0	1916	May 25, 2020
How to design Choice component so as not to include an option that has already been selected in the past Ask for Help	12	809	July 10, 2020
Many-to-Many Relationships Ask for Help	38	6244	November 30, 2023
Help- Eliminate a option Ask for Help	2	235	July 15, 2021
Choice Component - multiple selections Ask for Help	65	9045	December 24, 2022

How to eliminate choices after they've been selected: Many-to-many relations

PART 1: USERS ASSIGNING THEMSELVES

Related topics