Row Owner Clarification

[Clement_Koo]

Hi,

I have a quick question on Row Owner. Let me first share my use case.
I have the following user table, categorized into Admin and User.

All users will be able to see basic fields of customers. However only the Admin can see the Advanced fields. As such I set the Row Owner on the “Role” column.

I also set the Role in the user profile.

This seems to be working fine. When a non-admin logs in, he can’t see the Advanced fields.

When the admin logs in, he can see the Advanced fields.

I just want to confirm, by doing this approach, does it prevent the data of the advanced fields from being downloaded to the non-Admin’s computer?

Thank you so much in advanced!

Best regards,
Clement

[Jeff_Hager]

Correct. When Row Owners are applied to a table, rows will only be downloaded to the device if the signed in user has a matching user email or role that matches the value in the row owner column.

[Clement_Koo]

Hi Jeff,

Thanks for the quick response.

I would like to clarify, even though the data under the “Advanced” fields are greyed out:

But when I access them from another table, they are not greyed out:

Therefore I would like to clarify, while these non-admins are not able to see the data from the front-end, are these data not downloaded?

Thank you!

Best regards,
Clement

[Jeff_Hager]

Yeah, it can be confusing when you look at the data editor, as the data editor still downloads and has access to all rows, but greys them out. Viewing relations and single value columns will still find them since the rows are there, but in reality those rows will not downloaded in the published app.