I am working on a flow to generate a grant contract number when each time a grant contract is created. For each record type there is a different starting number
Grant Record Type starting Number Ending Number WTFPG 2300010 2301999 SAT 2304011 2306999 Exp 2330001 2333999 YW 2370105 2370999 DYSC 2371000 2371999 Exec 2396101 2396199
Here I have stored the value 23 into a formula variable in a flow.I have to concatenate this 23 with the remaining part of the number and each time a record is created a counter is to be provided to increment the value ie for first record of WTFPG the number is 2300010 next it will become 2300011 and so on...
I have used a flow to get the grant contract record each time it is created and added a decision box after this for each record type.. I am planning to use update records after this so that for each decision outcome(ie for each RT outcome)the corresponding formula can be used in the update record to update the grant contract.
But I am confused about how to implement this using formulas and how to set counters.And also if in between a record is deleted then how this number chain will continue(how can i fix that)
As of now I have created a flow like this: