Generate Case Number

Hello Guys,

I would like to change my rule for generating of case number.

At this moment I'm using something like this 

"APP" &
text(now(),"yy") &
text(now(),"mm") &
text(now(),"dd")
&
"-" &
ri!request.id,

where id is id of my case in DB. This number for example is "APP-191004-10".  

I would like to change this rule for having "id" reseting every day. What i mean is for example users create 100 case this day so we start APP-191004-1 and the last number for today would be APP-191004-100. On the next day this number starts from 1 APP-191005-1. Can you help me with remaking this rule

Thanks 

Dawid :)

Parents
  • Another option here would be to utilize a constant for the daily ID value, create a sub process that gets this information for each record.  Assuming you have a 'CreatedOn' timestamp for each record, the sub process can query the DB to see if any requests have been created in the same day.  If not, reset the constant to 1 and return that value.  If so, increment the constant and return the incremented value. 

Reply
  • Another option here would be to utilize a constant for the daily ID value, create a sub process that gets this information for each record.  Assuming you have a 'CreatedOn' timestamp for each record, the sub process can query the DB to see if any requests have been created in the same day.  If not, reset the constant to 1 and return that value.  If so, increment the constant and return the incremented value. 

Children

 Discussion posts and replies are publicly visible