Hi All, I’ve been reading up on different ways to filter user access to rows, views and actions etc. using email/domain. My app is used to collect visit data from several (4) subcontractors for my own team to review. Each subcontractor will have multiple users and ideally we will just invite them using the whitelist. My table has a column with the name of each contractor and I was hoping that somewhere within the app I could extract the domain portion of USEREMAIL() using text operators, collect the associated contractor name using a lookup table (domain/contractor) and use that to filter rows etc. I’ve tried configuring one of the USERSETTINGS to do this but it’s not reliable.
Two more things (non essential) a) I’d like to reserve the admin/user setting for other controls b) ideally I would like to be able to use a USERSETTING with access restricted to admin roles, to simulate what each contractor can see for testing.
Any ideas? Thanks