I have been experiencing an increasingly frustrating issue that I am convinced has to be a bug. If anyone has a solution for this, I would greatly appreciate it.
I have a Glide Pages app connected to an Airtable base, and I am trying to apply visibility conditions.
Here is a screenshot:
You will see I have applied two conditions. Either the name in the User Profile Name must match the Team Member Name assigned to a project, or their Role must be Director. This way, team members can view only their own projects while admins can view all projects.
The issue is this doesn’t work, and I just can’t figure out why. I have tried multiple types of conditions (Name to Name, Email to Email, etc.). The fields are plain text fields, not computed columns. I did try computed columns just for kicks, but that didn’t work either. In every case, the conditions either don’t work at all and every project is displayed for everyone, or nothing is displayed for everyone.
The most frustrating part about this is if I use filter data instead, then it works. But the exact same thing doesn’t work in visibility conditions. I would use filter data, but it isn’t an option in this scenario, as I wouldn’t be able to use the admin role (please see the beginning of this post).
Row owners are not able enabled anywhere - I have gone through every table column by column. With the state of the Glide and Airtable integration, having row owners would just honestly not be efficient. It would work fantastic for a single person, but not multiple people.
Here are a couple of examples to help explain my situation a little:
- I only want freelancers to be able to view projects they are assigned to.
- I only want freelancers to be able to view quotes they have submitted.
^ I fully realize in those two cases, the data would still be available but just hidden, with row owners disabled. But again, please, I don’t want to and can’t use row owners.
Thank you so much in advance.