Custom Project ID # Auto Increment

  • 0
  • 1
  • Question
  • Updated 2 years 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 2 years ago

  • 0
  • 1

You and Wade should get together

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

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