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
ChuckGrigsby's avatar
ChuckGrigsby
Qrew Cadet
8 years ago
Try this.
"TORC" & Year(Date d) & "-" & ([Record ID#]+10000)
  • WadeDavis1's avatar
    WadeDavis1
    Qrew Trainee
    8 years ago
    Also Received Error:

    "Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Please post your formula and we will correct it.
  • ChuckGrigsby's avatar
    ChuckGrigsby
    Qrew Cadet
    8 years ago
    I feel like it should be this if its a formula text field and a date field as proper data type.
    "TORC" & Right(ToText(Year([date_field])),2) & "-" & [Record ID#]+10000