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 :)

 Discussion posts and replies are publicly visible