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
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
8 years ago

Your new field would have to be a formula text field by data type.

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

see if that cleans it up a bit.

WadeDavis1's avatar
WadeDavis1
Qrew Trainee
8 years ago
With or without the parentheses
 
"TORC" & Year(  Date d) & "-" & [Record ID#]+10000

Returned Error
Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.