# Increment not working

**URL:** <https://community.glideapps.com/t/increment-not-working/76140>\
**Category:** Ask for Help\
**Created:** [September 5, 2024, 3:31am UTC](https://community.glideapps.com/t/increment-not-working/76140 "2024-09-05T03:31:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![MikeM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikem/32/79327_2.png) [@MikeM](https://community.glideapps.com/u/MikeM)\
**Post date:** [September 5, 2024, 3:31am UTC](https://community.glideapps.com/t/increment-not-working/76140/1 "2024-09-05T03:31:25Z")

</div>

this used to be working  
i have a form container with an “after submit action” to increment my reference no."  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/c/3cbba1565b4c2dfdab01522f0865093e21975412.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3daf99252d2112887b43d11516adfe232c3b8ec9.png)

this used to be working unitl yesterday and receiving this history error on the action :  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/a/0a4e74648bb3f37c886b6d1b40612bbc68d04f2f.png)

the action runs perfectly when testing the run button, it increments the " text tp no."

but when testing the actual page and after submit button, if fails.

this is the table that should increment.  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3bcaeecfc000f1f2793f50409df1955a9194d046.png)

this is how it looks on the current user table,

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/0/d034bb131c83e50b0eee2ebc737763b3cdebe711.png)

so 3 tables are being used during this process the form table (project quotations) , users table and serial generator table (TP number)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 5, 2024, 11:18pm UTC](https://community.glideapps.com/t/increment-not-working/76140/2 "2024-09-05T23:18:55Z")

</div>

Can you try changing that column to a number column to see if it works? I was surprised it works previously if you use a text column.

---

<div class="post-metadata">

**Author:** ![MikeM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikem/32/79327_2.png) [@MikeM](https://community.glideapps.com/u/MikeM)\
**Post date:** [September 7, 2024, 12:48am UTC](https://community.glideapps.com/t/increment-not-working/76140/3 "2024-09-07T00:48:24Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/c/3c0827549d3a9db537eab39845f79507ebea1d17.png)

its working now, i rebuilt a new form and abandoned the old form, i copied the “old form” containers to the new form and now its working. i tried to change the text to number before rebuilding but same bug. i guess its an isolated bug that i can’t reproduce. its working now thank you for all the help. (yes, i have 2 static counters for 2 different forms.)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 7, 2024, 1:07am UTC](https://community.glideapps.com/t/increment-not-working/76140/4 "2024-09-07T01:07:03Z")

</div>

Yep, but going forward I think you should always make sure you’re trying to increment a number column to prevent any possible issues. Great to hear it’s working!