Ticket Numer

SEPCO

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

Member
Staff member
Hi,

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