Forum Discussion

TylerFoy81's avatar
TylerFoy81
Qrew Member
12 days ago

Generate a number

Hello I would like to make a unit number self generate Example 1000-(001,002,003) as more records are created.. is there a way to do this function? where it will generate the unit number based off the last record? Im a still pretty new to QB. Do I need to make the first record from there then ref that field in the max ID and add +1 to it?

  • By far the easiest way is to just leave a formula off of the [record ID #] field.  If there is a particular format you want, I can help with the formula.