Hello, I had a look at the forum about this, but im still a bit confused on how to do this.
Admin = should be able to see all data (in our case location and events)
Team = should only be able to see business location data so only there own location events
i can make it work so roles can see one or the other but i cant seem to be able to make it so that Admin can see all location attendees but team should only be able to see allocated location eg only see events and attendees for London, or Birmingham etc where admin can see all
so in user table we have Role, are you saying add another colum next to it , but put admin all the way down? apologies i am learning via video but not fully got my head around glide yet so really appreciate any guidance. thank you
Name | Role | Location
jon | admin | london
dave | user | Birmingham
admin should be able to see both london and birmingham but user can only see birmingham
Yes if you want the admin to see the entire users table then that is what you need to do.
And then in subsequent tables where you enable row owners you’ll need two columns. One for the team and one for the word admin and make both row owners
Here is some excellent material from Robert on the matter