Increment not working

this used to be working
i have a form container with an “after submit action” to increment my reference no."
image
image

this used to be working unitl yesterday and receiving this history error on the action :
image

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

this is how it looks on the current user table,

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

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.

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.)

1 Like

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!