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.
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.
