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") &
"-" &

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


Dawid :)

Parents Reply Children

 Discussion posts and replies are publicly visible