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, ...
Forum Discussion
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#])
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#])