I have following setup:
In sheet 1 I have seminars with participants. I labeled the columns: participant 1, participant 2, …
Glide creates a relation column out of this data.
In another sheet I have a list of all users.
I then use the 1st relation to create a 2nd relation where participant names match to app users.
This works very well: I can list all participant profiles on a seminar tab using the 2nd relation.
My question: How do I identify missing users? Some participants names are not listed in the users sheet. I’d like to list those participant names as well - but atm I have no clue how to access this data.
Because: the 1st relation created by glide is not accessible in components.
I hope this is not too confusing.