Skip to main content
Question

Custom Project ID # Auto Increment

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. 
    This topic has been closed for replies.

    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#])
    Terms & ConditionsAccessibility statement