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 :)
Discussion posts and replies are publicly visible
Hi Dawid - You can have a constant of type number(integer) that would function as the "id" of the case in your database. This constant would be set to 1 initially and would be incremented by 1 after a case is created. You would have to update this constant to 1 via a nightly process so that the "id" is reset every day.