Custom Project ID # Auto Increment

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
Hello All,

I am trying to create a unique project # that auto increments and is based off a few things.
For example, I need to use a prefix as follows: IT(YY)-+1. Example would be IT17-1, IT17-2, then for 2018 IT18-3. I do not want the increment to restart when year changes. I also only want it to calculate this ID # if a new record is saved. I am not sure how to do this with my prefix requirements. Any help will be greatly appreciated. 
Photo of Mitchell Young

Mitchell Young

  • 70 Points

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
Mitchell,

You and Wade should get together
  https://community.quickbase.com/quickbase/topics/im-attempting-to-generate-a-unique-identifier-for-a...

Try this.  If it fails on Syntax please post the formula and the error message

"IT" 
& Right(ToText(Year(ToDate([Date Created]))),2) 
& "-" & ToText([Record ID#])