I have a problem with my app. In my user table I assigned the role to the Roles collumn, but still it doesn t work only with email. I tried to do it in another app, and there it was working perfectly
Can you show the following please:
- Your User Profiles table, showing the Role column
- Your User Profiles configuration
- An example of another table where you are trying to use the Role as a Row Owner.
Users Profile table with the Roles column
User profile configuration:
Example of another table where I tried to use the roles as row owner ( it works with emails, but not roles )
Configuration working properly, asigning the roles in the “viewing as:”
Okay, that’s interesting. There is nothing there that stands out as being obviously wrong.
One comment I will make is that you probably shouldn’t set Row Owners on the Role column in your User Profiles table. Assuming that an Admin should have visibility of all users, what you should do instead is add a second “owner” column, apply Row Owners to that, and insert the word Admin
in every row. However, I don’t think that will fix your main problem.
Question: If you reload the Glide Builder does anything change? I have seen in the past sometimes the builder can need a reload to apply row owners correctly when switching users.
Well, what I m trying to do is to limit the data downloaded to the employees, because the app started to get slower due to a lot of extra data that some need, some don’t. And I m trying to optimize that, I create a collumn for email that need to have access to a table and enter the emails with a nonvisible text with default value to be the emails, but it would take a lot of time etc and might still slow it down due to multiple users. That s why I wanted to do it with Roles as user row so I can assign that role to those who need to see it. Also with this I have an extra question, can I assign a 2nd collumn filled with roles that need to have acces to it, for example, 1 collumn owner is filled with “Admin” and the other with “Execution Team” so both roles download that data.
And yes, I tried restarting the app, multiple times. Is there any chance that the privacy settings affect it too? Because the privacy is set to “All emails in the table: Users”
Found the problem ( I think ), I had to republish the app. I don’t know how or why, but now it works
That’s fine, I wasn’t questioning your motivation. Was just making the point that it’s not normal to assign Row Owners to the Role column in the User Profile table.
Yes, you can do that. You can have as many owner columns as you want, using any combination of email addresses and role values.
No, that shouldn’t make any difference. Roles & Row Owners are independent of App Privacy settings.
That is odd indeed, and I’ve never heard of that happening before. If it happens again, I’d recommend reporting it to Glide Support. Because it does sound like a bug to me.
I will try it on another app real quick and see if it still happens
I think the reason it didn t work while published, and had to republish the app, is because the data was already downloaded to the users and it was in use already. so with the unpublish it resets
If that’s the case, then it’s new behaviour and I think I’d still consider it a bug.
This is something I’ve actually tested in the past - that is, applying Row Owners then watching to see if data disappears from view in the published App. (It does).
Were you able to replicate the behaviour?
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.