Row Owner issue

[manthe]

Hi all.

I am creating an app that can be used by multiple businesses, and within every business there can be several users.

I collect all users in the user table with email and a business_ID column.

THen I have another native glide table that has a lot of rows with “business information”. Every row have the same business_ID that extist in the user table, and I have a lookup column that matches all the users that belong to this business_ID since they all should be able to view the content for this business_ID.

I want to set the lookup column as row owner to secure the data, but that option is not visible on a lookup column.

I tried a few other ways but cannot get any of them to work.

How can I set a row owner column in a table and then let several differet users from the user table to view the data of the business_ID they belong to?

Cheers Måns

[Darren_Murphy]

• Go to your User Profiles Configuration (Settings->Users & Authentication->Edit User Profiles), and set the business_ID column as the Role
• In your Business Information table, apply Row Owners to the business_ID column.

[manthe]

This looks very promising

Will try it out in a couple of hours and let you know @Darren_Murphy

/Mans

[manthe]

@Darren_Murphy Wohoo!, this works like a charm. I also used a collection of specific business data, that relate to the business table, and used the relation from those tables as data source (thing in things…) and it works perfect.

Thank you for this.

I still dont really understand how this works?

I have used the Role for other things previousely but not like this.

Is it correct to say that if the business_ID column in the users table have the same value as the row owner column in any other table, I can see the data, otherwise I cannot see the data…

/M

[Jeff_Hager]

Yes, any table under row ownership will only download data where the row owner column value matches the sign in user’s email or role.