I have created an app that is supposed to be used by several vendors, the DB is managed via a GSheet:
All Tables contain linked data, as I have included in each Table a column with “CompanyID” and referenced it to the main one maintained in the User table.
How can i manage the security filter on all tables that it only shows all the entries with the specific CompanyID of the User even though some of the tables do not contain User data but just the company ID as a link? I am a bit lost here and do need a starting point on how to manage the formula.
As a second step data in each View shall be filtered based on a specific role of the user that is using the app, this role is also maintained in the user table.
Thanks so much for any help.