I am creating a client portal app. I am trying to create row owners to maintain privacy.
I have created row owners on the Client Detail spreadsheet so that the patient can only see their own personal details.
I also have a client History spreadsheet which I need to create row owners so that the client only sees their own history. This spreadsheet does not contain the client’s email address. I have created a “relation” and then a “looked up” so the client spreadsheet now contains the email address. I however am unable to create a row owner from a “look up” column. I have also tried making a row owner with the client’s full name however this doesn’t seem to work either.
Any idea on how I can make this happen!?
P.s I am a newbie here so am probably on the totally wrong page with this!
Thanks in advance for your help
D
You can only use Emails or Roles with row owners and the column has to exist as a basic column in the table. Roles probably wouldn’t work here, but you need to find a way to populate an email column in your history table. You can’t use computed columns (i.e. Relation/Lookup) as row owners, because computed columns are computed AFTER data has already been downloaded to a user’s device (too late to apply security).
Also, since you mention “patients”, I feel obligated to share this:
1 Like
May we know why is this the case? How are you populating that sheet? I feel like what you need here is an arrayformula to populate the email sheet-side so you can use that as a row owner in Glide.
1 Like
Thank you for this information, it has been very helpful.
Thank you for also sharing the rules and restrictions. “Patient” probably wasn’t the best use of wording. I can confirm I will not be capturing any of these types of data!
1 Like
Let us know if you have any further questions regarding this, we’ll try our best to help.
