Yes, but that doesn’t help with the issue of using Roles as Row Owners in other tables.
If you have pro plan you can make a copy of the app where admin can see everything. I use an app for users with row owners and another app with same table but without row owners, so admin can see everything
I think you are missing the point.
With a Google Sheet, you can create an array column of roles, assign multiple roles to individual users, and use those roles as row owners in other tables. It’s not possible to do this with Glide Tables, which makes Glide Tables unsuitable for a situation where you have a requirement to assign two or more roles to individual users.
We want to build a GlideApp Customer Portal integrated to an existing ERP solution.
Each ERP Tenant has multiple clients and we want to allow each ERP Tentant to allow their Client’s, Contacts access to the Client Data via the Glide Portal. (We plan to set-up an integration using synced postgress tables linked to Glide)
The problem I’m experiencing is that in Glide, a user profile and login is done based on the emailaddress of the user. While this emailaddress can be coupled in my ERP to different ERP-Tenant/Client combinations.
I need to be able to set-up row-security so that my user can view the data from all the ERP-Tentant/Client combinations her/his emailaddress is linked to in any of the ERP tenants.
However it seems I’m only able to add one role in the users table. It also seems to be impossible to add a comma separated list of row owners …
Is there a solution to this?
This could be a big project but if we can’t do it in a decent way I’m afraid it will be a no go…
The only solution is to connect a Google Sheet and use it as the source of your User Profile table. You could then assign up to 9 roles per user by creating an appropriate array column in the Google Sheet to use as your Role column in Glide.
It also should be noted that you can have as many individual Row Owner columns as you want, but each one can only contain a single email or role.
Yes, it is great trick with sql! But how to configure so many row owners colums, as many customers?
That’s where Roles come in. If all customers have the same role, then you only need one row owner column for all customers with the same role.
Good, how to achive with this technique to some staff have access to several customers? Probably we must have so many preconfigured wow owners as many staffs we have. Or preconfif many, many unuque roles and distribyte they between customers?
Staff would have a different role and you can create a second Row Owner column filled with the Staff role.
Yes, but we cant expect how many customers will be
All customers would have the same role. If you had a situation where you wanted row owners for customers and staff, you create two row owner columns. One to hold the customer’s email or role, and another to hold the staff role.
If you use Roles, you can have 1000 people with the same role and you only need 1 row owner column.
I can imagine that some backend can dynamically cteates columns, but how to config it as row owner? Just to pre create 10k columns and manually set to row owner, and then with sql dynamically fill they
Why would you create so many columns. I said 2 columns in the scenario I mentioned. Have you used Roles before?
Wow, yes geniously!!! Really we needn’t so many - 2 enoth, if with sql every time we can arrange special values for each columns
Hi Darren, Thanks I’m not really accustomed to working with google sheets in Glide. Do you happen to know of any example video so I can test it?
Or if you have a moment on Monday to go through it together?
No problem if you’d charge your time if I you can help me save some
Really, many thanks Jeff! And sorry for my English!
But, wait, if row owner have been applyed on server side, but sql table data never goes to Glide server, how it can be applied? And if we can predefine data to download to staff device, so row owner is uselles in this case?
I don’t know how that works with a SQL source since I’ve never used SQL with Glide myself. I assume though that it’s still passing through Glide servers first. I understand what you are saying, but I’m not sure I have the answer for that.
Yes, exactly sql data never goes to Glide server. It is main feature