Auto Increment Numerical Value in Catalog Item Variable.

Aks6
Kilo Contributor

‎05-11-2021 10:28 PM

Hello Everyone.

I'm having the following requirement on Catalog Item Variable Form.  There is a Variable named as Serial Number. Every time a catalog item is requested, the field needs to be auto-populated.
We have to populate the variable with the following information - ('First letter of first name of Requestor' + ' Last letter of first name Requestor' + 10500).

The number is starting with 10500 and every time the Catalog item is submitted the number is auto incrementing and is unique (should not be repeated).

Eg - Requestor Name is JACK. So the serial number would would be JK105001. Next time the catalog item is requested the serial number should be **105002,**105003 and so on.

NOTE - The Variable 'Serial Number' is not mapped to any field on RITM. IS it possible to query variables for a catalog item in SN ?

Please suggest the best way to do this. Thanks in Advance.

  • 1,875 Views
12 REPLIES 12

Tony Chatfield1
Kilo Patron

‎05-11-2021 10:33 PM

Hi, perhaps you could add a record to the number maintainance table and use this as your reference. If you did you may also be able to leverage the OOB number increment functions.

0 Helpfuls

Aks6
Kilo Contributor
In response to Tony Chatfield1

‎05-11-2021 10:38 PM

Hi @Tony Chatfield - That is not possible as we need to define a table while using the OOB Number Maintenance table and there is no table where the value of the variables can be stored.

0 Helpfuls

AnirudhKumar
Mega Sage
Mega Sage

‎05-11-2021 10:38 PM

This can be done. An Onload client script with a glideajax calling script include that queries the RITM table will do the job...

But my concern is, the logic to your serial number needs to be improved.

Lets say there are 2 users...

Ash...

Anirudh...

 

The serial number of both these users are going to be same as they submit their items.. 😛

0 Helpfuls

Aks6
Kilo Contributor
In response to AnirudhKumar

‎05-11-2021 10:43 PM

True that Anirudh but The serial numbers wont be the same as every time the last number 10500 needs to be auto incremented, in that case with every request being submitted, the number would be unique.

for Ash it will be like - AH105001

for Anirudh - AH105002.

 

 How can we query the value of the variables from the RITM Table. Can you please describe it in details as I have no clue about querying variables.?

0 Helpfuls