Ticket Numer


New Member
I am creating an app to submit maintenance requests. I would like it to be able to pull the last ticket number from an SQL db and add 1 to it. Basically be incremental bu be based off the last ticket # in the database.

Dan Peluso

Staff member

You could do this through our Custom SQL variable (or form logic) options. If you create a SELECT statement that retrieves the last number used, you could then use a TracerPlus calculated field to add 1 to it.

If you just need to use an incremental field, you can also look at some of the other variable options. There is an autonumber option that may work well for you.