Forum Discussion

WadeDavis1's avatar
WadeDavis1
Qrew Trainee
8 years ago

I'm attempting to generate a ""Unique"" identifier for a tracking number that is auto generating.

I'm attempting to have a number generated using "TORC" as the beginning identifier then the year. and then starting at 10000 and using the record ID#. I'm new to "formulas and I am stumped This i...
App builders
Errors
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Not tested but try this.  Let me know if there are syntax errors.

Try this

"TORC"
& Right(ToText(Year([Date d])),2)
& "-"
& ToText([Record ID#]+10000)