Have an app that uses Excel as a data source and has done for a few years. I created a new screen that allowed a user to edit a record in a table (tab in Excel sheet). Nothing surprising there :slight_smile: I have noticed that while I can add new rows to this sheet via my add/edit screen, one col…

Another example where I can edit some columns but not others. In this case the role column was not updated although the other cols were. [Screenshot 2024-02-29 at 12.18.30]

Is the role column setup as the “Role” inside your Users table?

[Screenshot 2024-02-29 at 12.27.39] Like this? This is the users table (called something like admins, but it’s the table used to authenticate users when they login)

Also, and I’m only just realising this, I’m wanting a super admin role to edit the users table and assign roles. Maybe this just isn’t possible?? I’ve always manually changed roles but this seemed like a simple edit form screen.

Users cannot change their role through the published app. A role can only be changed by updating the original data source or in the Data Editor . Which means, no matter what I do via the app, the changes to the Role column in the Users table will never update via the app, even if the builder allow…

[image] Data Dissapearing Ask for Help Open this post to understand what’s happening. This is normal with a Role column. Are you using Roles for Row Ownership to secure your data, or are you simply using it to control visibility and filters. If data security is not yo…

Ah interesting that makes sense. If I understand your work around: Create a new col in Users table called “access” or whatever, then use that to control visibility of tabs. Correct?

Yes that’s an alternative, but be mindful that visibility and filter conditions are not secure like Row Owners are when data is concerned. Tab visibility is fine using any user issue column, but that doesn’t guarantee that the data is secure.

If I have a table for favourite colours with a col called “access” and access has a role in it, then do I make that column the row owners? How does Glide know that the access col is related to a specific user? Or does this only work for the Users table / Role column?

[image] blairrorani: If I have a table for favourite colours with a col called “access” and access has a role in it, then do I make that column the row owners? If that data is meant to be secure, private, and only accessible to those that own the data, then yes, you would use Row Owners. […

Syncing from Glide to Excel

Ask for Help

Jeff_Hager February 29, 2024, 4:19am 7

Topic		Replies	Views
User Data Not Staying Saved Ask for Help	11	379	May 29, 2024
No data is passed from the Glaid table to the Google table in the Role column Ask for Help	18	338	June 25, 2022
Glide overwrites updates made using choice component Ask for Help	5	60	October 21, 2024
User table data disappears after a while Report a Bug	11	130	June 24, 2024
User Roles assigned but relevant data is still hidden from user Ask for Help	15	346	January 11, 2024

Syncing from Glide to Excel

Related topics