I’ve somehow muddled up trying to enable user roles. I need school principals and admins to view the same row - they will be on different email addresses. We are loading up the details for them to view their water sources to check it and add and details. Whenever I set row owners on the ‘roles’ column I don’t see all the data available which should be available for all the users that match the roles - which I’ve set as different school names for simplicity. This data is held not on the user sheet but a secondary google sheet. I tried mimicking Robert’s video but just can’t crack it!
Don’t do this. It just makes things confusing. The Role column in the user table should only be used to hold the role of the user and that’s it. Don’t make the role column a row owner column at the same time.
If you need to apply row owners to the user table, first set the email column as a row owner column. Then create separate row owner columns that will contain roles for each additional user role that should have access to that row.
In all other tables, create separate row owner columns that will contain either email addresses or roles for each user that should have access to that row.
