# Rowid not getting created when i create a new record from a form

**URL:** <https://community.glideapps.com/t/rowid-not-getting-created-when-i-create-a-new-record-from-a-form/76265>\
**Category:** Ask for Help\
**Created:** [September 10, 2024, 4:19pm UTC](https://community.glideapps.com/t/rowid-not-getting-created-when-i-create-a-new-record-from-a-form/76265 "2024-09-10T16:19:22Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\
**Post date:** [September 10, 2024, 4:19pm UTC](https://community.glideapps.com/t/rowid-not-getting-created-when-i-create-a-new-record-from-a-form/76265/1 "2024-09-10T16:19:22Z")

</div>

I am creating a new entry in a table that uses data from existing columns. The data is populated in the new table but there is no rowId - any ideas on what I am doing wrong?

I have a previous version of the app that used google sheets that does create the new row. I am converting the app to use glide tables and would like to know how to create the new rowId value when the form is submitted. thx

---

<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:** [September 10, 2024, 5:25pm UTC](https://community.glideapps.com/t/rowid-not-getting-created-when-i-create-a-new-record-from-a-form/76265/2 "2024-09-10T17:25:03Z")

</div>

Is it the real RowID column or just a basic column named RowID? What happens when you try to add a RowID column to the table? If a real RowID column already exists, it won’t let you add another one, but if it doesn’t exist, it will expose the true and real RowID column. I suspect the column you currently see is not the actual RowID column.

---

<div class="post-metadata">

**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\
**Post date:** [September 10, 2024, 5:55pm UTC](https://community.glideapps.com/t/rowid-not-getting-created-when-i-create-a-new-record-from-a-form/76265/3 "2024-09-10T17:55:25Z")

</div>

Thanks for the ideas. the rowID looks real as it is locked. I am not able to add another rowId column

 ![Screenshot 2024-09-10 at 10.53.33 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/8/f8dadd9b2a1df86af6736311f71f83f3d674e124.png)

---

<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:** [September 10, 2024, 6:11pm UTC](https://community.glideapps.com/t/rowid-not-getting-created-when-i-create-a-new-record-from-a-form/76265/4 "2024-09-10T18:11:02Z")

</div>

The lock is just an emoji character that’s part of the heading name. Take it’s legitimacy with a grain of salt.

 ![Screenshot_20240910-130322](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c018205f2455f9752e923a4d1f6ad3c34a488257.png)

So you attempted to add a RowID like this?

 ![Screenshot_20240910-130441](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/8/f852792a9035d2ebdad10bf10c8cb5c7e27dd448.png)

Are you able to manually change a value in one of the cells in that column, or is it locked out. Are you able to edit the column and change it’s data type?

I guess what I should ask first is… did you import the data from a google sheet initially, or did you create the glide table from scratch?

---

<div class="post-metadata">

**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\
**Post date:** [September 10, 2024, 6:15pm UTC](https://community.glideapps.com/t/rowid-not-getting-created-when-i-create-a-new-record-from-a-form/76265/5 "2024-09-10T18:15:55Z")

</div>

originally the table was created via the import from google sheets. I can re-create the glide table if that will clean things up.

the rowID edit column simply lists it as Text

 ![Screenshot 2024-09-10 at 11.14.31 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a78dc68fa506c1fc192ebbaa4a81c70c7262fc29.png)

I will re-build the table. thanks

---

<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:** [September 10, 2024, 6:19pm UTC](https://community.glideapps.com/t/rowid-not-getting-created-when-i-create-a-new-record-from-a-form/76265/6 "2024-09-10T18:19:26Z")

</div>

> [@Carl\_Johnson](#):
>
> the rowID edit column simply lists it as Text

That’s because it normally is text. The question is, can you change it to something else, like a numeric or date column? If you can, then it’s not a true RowID column and just imported the column from the google sheet that was named RowID?

Just asking this again…

> [@Jeff\_Hager](#):
>
> So you attempted to add a RowID like this?
> 
> ![Screenshot_20240910-130441](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/8/f852792a9035d2ebdad10bf10c8cb5c7e27dd448.png)

---

<div class="post-metadata">

**Author:** ![Carl\_Johnson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carl_johnson/32/75656_2.png) [@Carl\_Johnson](https://community.glideapps.com/u/Carl_Johnson)\
**Post date:** [September 10, 2024, 9:26pm UTC](https://community.glideapps.com/t/rowid-not-getting-created-when-i-create-a-new-record-from-a-form/76265/7 "2024-09-10T21:26:41Z")

</div>

Jeff - you nailed it with the imposter rowId column. re-created these as authentic rowIds and all is good.

On a related question - I am able to assign the same “lesson” to a student multiple times now. I don’t want to create a new row when I update an existing row. is there a topic that already covers this? thanks

---

<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:** [September 10, 2024, 9:31pm UTC](https://community.glideapps.com/t/rowid-not-getting-created-when-i-create-a-new-record-from-a-form/76265/8 "2024-09-10T21:31:14Z")

</div>

How are you assigning a lesson now? How are you editing that lesson after it’s been assigned? Sounds like you are using a form (which is designed to add rows each time it’s submitted), or you have an Add Row action somewhere. You should be using the Edit screen action if you want to edit an existing row.
