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

PART 1: USERS ASSIGNING THEMSELVES Here’s the video on how a user can sign themselves up for unique teams: [Glide: Choice Eliminator]

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

HAHA! That’s awesome. Ya…if I were to do this all over again, I’d probably want to separate my school account from my Glide account…bit late for that at the moment though…I’ll cross that bridge if it comes down to it. If anything it gives people a “full picture” of my day-to-day lol

In any scenario, the user selected would need to have its own column in the Admin tab…especially if there are more than one admin. One thing I didn’t mention in all of this, is that the admin screen in the app is filtered by signed-in user. This way every admin has their own instance. Likewise, Ad…

This is a brilliant and very helpful solution to a common trouble-spot. I’ve experimented and adapted a variation on the same idea that allows for a separate sheet for each instance of this pattern within an app. In my use-case, I have several instances of this pattern and so using the primary “adm…

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

Ask for Help

Robert_Petitto May 25, 2020, 1:18am 26

Make sure you have User Profiles sheet defined.
Create a template column
Fill it with anything
Replace that anything with the user email!

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	6255	November 30, 2023
Help- Eliminate a option Ask for Help	2	236	July 15, 2021
Choice Component - multiple selections Ask for Help	65	9085	December 24, 2022

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

Related topics