Creating a unique identifier

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
I am trying to create a unique identifier for my records that is 

Last Two digits of the year - Record ID

I can't seem to get it right
Photo of Ashley Asante

Ashley Asante

  • 696 Points 500 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
Ah, refreshing to see a regular post not related to the UI change.

No problem,

Right(ToText(Year([my date field])),2)
& "-" &
ToText([Record ID#])