I have a table called teammate that is used for controlling access to my glide app. There are all the usual fields you would expect like name, address, email, phone, etc. All of these can be inserted or updated - either through a form, or directly in the Data tab.
One field however, cannot be edited or have a value inserted. This is a problem because it is the ID field used for connecting the teammates to various other tables.
I used to insert a value into that field when creating a new record, but now it is suddenly not possible. In the above image you can see that the latest dummy record I created does not have a Teammate ID. When double-clicking on the field I also can’t edit it. It simply refuses to accept any input.
There is nothing unusual about the configuration of the field, it is a simple numeric field.
Any help would be very appreciated.
Thanks
Is that column configured as the Role column in your User Profiles?
If yes, that would explain the behaviour.
If you’re not actually using Roles as Row Owners anywhere, then the simple fix is to remove it from the above configuration.
Thank you for your quick response!
I’ve done some googling, read the glide docs on roles, and watched some videos on the subject, and I can’t find that configuration you are showing in your screen shot. How does one get to that screen?
The Teammate ID field is the “Row Owner”, but the only way I can seem to make it not the row owner is to assign that to a different field. If I do that then presumably I won’t be able to insert or update to that new row owner field anymore.
Wow. I have previously read that section, and watched that video, multiple times, and it still didn’t register with me that the user access configuration is actually in the Profile page in the Layout editor. That just seems like a really odd choice from a design standpoint.
Anyway, based on the configuration in the profile page, there was no field assigned for Roles. To make sure however I created a new column called Roles and assigned the Roles to it. It is still not possible to insert or update the Teammate ID field.
Well, in case anyone else is searching for a solution to a similar problem, the only way I was able to resolve this problem was to create a new numeric column then copy/paste the data from the one column to the other. I had to do that because in addition to not being able to be written to, the column also no longer had the option to be duplicated.
After that it was necessary to go through the entire app with the “Find Uses” function and change every use of the original column to the new column.
I still have no idea why the column suddenly became read-only, and also unable to be duplicated.
1 Like
