Yet another permissions / roles questin

Ask for Help
1

Evening lovely people. Apologies for yet another roles question, but i’m a little stumped!

Our app is an asset inspection and management system for multiple customs.
We need our own staff to be able to access all client records, but then want our clients to just see their own records. Simple enough right?

Have read/watched/re-read/re-watched all the tutorials a number of times, but afraid am still miffed.

We have multiple tables (Clients/Assets/Inspections). I’ve so far assigned roles to Company name - which works fine, so Clients logging in can just see their own stuff.
I’m stuck on how I can then allow our own staff to see everything (without adding an extra column to every table with our own Company name in).
We can of course add the column, but then the issue with making sure the correct name is included in every single new record created - we have 1000’s.

Have i missed something super obvious?

Thanks x 100 in advance,

2

If you are using Google Sheet as you source, you can use constant to make sure the same value is across all the rows:

3

Ahh afraid not - we’re using Glide Tables…
Anything that can work here?
Thanks!

4

What you should do is give your Staff an appropriate Role, eg. “Staff”, and then add an Owner column to your Data Tables and set that value (“Staff”) in every row.

You can use copy/paste in the Data Editor to populate existing rows, then modify any forms that add rows to also pass the Staff owner value as either a column or user profile value.

2 Likes