How to generate sequence numbers on a catalog form

Servicenow lear
Tera Contributor

‎02-06-2023 01:48 PM

Team,

 

I have a requirement where There is a variable called ROLEID on my catalog form and I want it to generate number sequence Everytime someone uses the form.

For example ROLEID number is 1234 generated with help og MATH.random() but then next number should be 1235

0 Helpfuls
  • 624 Views
3 REPLIES 3

Drew8
Tera Guru

‎02-07-2023 11:24 AM

Hi, are these role numbers being stored in a table after the catalog item is ordered? What is the use of the number? Why does it need to be sequential?

0 Helpfuls

Servicenow lear
Tera Contributor
In response to Drew8

‎02-07-2023 12:34 PM

Hi , yes the Value will be stored on a table on a field called ROLEID.

the flow is > User goes to catalog form and the ROLEID generates 4 digit number starting from 1001 which gets saved on table.>>if the user refreshes the form the role id value should change to next number 1002.

this value is not similar to request number on a table because this will only be used in certain cases

0 Helpfuls