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
I see everyone responded :)

I think my formula has the best chance for first round syntax errors being clean. 

The field for date d will need be used as [date d]
  • WadeDavis1's avatar
    WadeDavis1
    Qrew Trainee
    8 years ago
    This returned the error:
    Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.


    "TORC" 
    & Right(ToText(Year(date d)),2) 
    & "-" 
    & ToText([Record ID#]+10000)
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    TORC" 
    & Right(ToText(Year([date d])),2) 
    & "-" 
    & ToText([Record ID#]+10000)
  • ChuckGrigsby's avatar
    ChuckGrigsby
    Qrew Cadet
    8 years ago
    I wonder if he doesn't have a date field and it should be Year(Today())
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    But then the unique identifier would keep changing when the year rolls over.

    Maybe he wants
    "TORC" 
    & Right(ToText(Year(ToDate([Date Created]))),2) 
    & "-" 
    & ToText([Record ID#]+10000)