# Can't insert or update values in one specific field of a glide table

**URL:** <https://community.glideapps.com/t/cant-insert-or-update-values-in-one-specific-field-of-a-glide-table/81462>\
**Category:** Ask for Help\
**Created:** [April 21, 2025, 5:04pm UTC](https://community.glideapps.com/t/cant-insert-or-update-values-in-one-specific-field-of-a-glide-table/81462 "2025-04-21T17:04:56Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Climate\_Brigade](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/climate_brigade/32/67194_2.png) [@Climate\_Brigade](https://community.glideapps.com/u/Climate_Brigade)\
**Post date:** [April 21, 2025, 5:04pm UTC](https://community.glideapps.com/t/cant-insert-or-update-values-in-one-specific-field-of-a-glide-table/81462/1 "2025-04-21T17:04:56Z")

</div>

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.

 ![glide-app-teammate-table](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/bed1d4ba1ae809e79f24c05603cd4a80c70fe8aa.png)

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.

 ![teammate-id-config](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7a5470695e09df3a8f86c27888cff6e4affcd950.png)

There is nothing unusual about the configuration of the field, it is a simple numeric field.

Any help would be very appreciated.

Thanks

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 21, 2025, 5:08pm UTC](https://community.glideapps.com/t/cant-insert-or-update-values-in-one-specific-field-of-a-glide-table/81462/2 "2025-04-21T17:08:45Z")

</div>

Is that column configured as the Role column in your User Profiles?

 ![CleanShot 2025-04-22 at 01.07.27@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/57b983ff86ebd3d4f928cbefefd7caf89a2aadf6.png)

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.

---

<div class="post-metadata">

**Author:** ![Climate\_Brigade](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/climate_brigade/32/67194_2.png) [@Climate\_Brigade](https://community.glideapps.com/u/Climate_Brigade)\
**Post date:** [April 21, 2025, 5:20pm UTC](https://community.glideapps.com/t/cant-insert-or-update-values-in-one-specific-field-of-a-glide-table/81462/3 "2025-04-21T17:20:29Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 21, 2025, 5:28pm UTC](https://community.glideapps.com/t/cant-insert-or-update-values-in-one-specific-field-of-a-glide-table/81462/4 "2025-04-21T17:28:53Z")

</div>

> **[User Profiles | Glide Docs](https://www.glideapps.com/docs/essentials/security-and-user-data/user-profiles#setting-the-user-profiles-table)**
>
> Define, store, and use data on your app's users.

---

<div class="post-metadata">

**Author:** ![Climate\_Brigade](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/climate_brigade/32/67194_2.png) [@Climate\_Brigade](https://community.glideapps.com/u/Climate_Brigade)\
**Post date:** [April 21, 2025, 5:45pm UTC](https://community.glideapps.com/t/cant-insert-or-update-values-in-one-specific-field-of-a-glide-table/81462/5 "2025-04-21T17:45:50Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Climate\_Brigade](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/climate_brigade/32/67194_2.png) [@Climate\_Brigade](https://community.glideapps.com/u/Climate_Brigade)\
**Post date:** [April 21, 2025, 10:58pm UTC](https://community.glideapps.com/t/cant-insert-or-update-values-in-one-specific-field-of-a-glide-table/81462/6 "2025-04-21T22:58:55Z")

</div>

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.
