Discussions

Expand all | Collapse all

Custom Project ID # Auto Increment

  • 1.  Custom Project ID # Auto Increment

    Posted 11-01-2017 20:05
    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. 


  • 2.  RE: Custom Project ID # Auto Increment

    Posted 11-01-2017 21:05
    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#])