Auto Numbers with a date prefix

Job2 · ‎06-27-2017

Hi,

We want to to auto-numbering on a certain table with a date prefix but I am a bit stuck...

I can't find anyone who has posted this in the past on this community but I do know the solution exists...

Any idea anyone?

Job2 · ‎06-28-2017

We used condition: When = OnDisplay

with the following script to add the date of today as a prefix:

var month = '', day='', year='';

var gdt =new GlideDateTime();

month = gdt.getMonth();

day=gdt.getDayOfMonth();

year=gdt.getYear();

var array='';

array=current.number.split('VLN');

current.number='VLN'+day+month+year+array[1];

//current.number = current.number + month;

sachin_namjoshi · ‎06-27-2017

Below post has solution to your question

Regards,

Sachin

Job2 · ‎06-27-2017

That's the solution I tried... But no luck.

Tried it on our customized table, on the task table, ... Doesn't seem to be doing anything...

sachin_namjoshi · ‎06-27-2017

Can you please post screenshot of your business rule?

Regards,

Sachin

Job2 · ‎06-27-2017