Get records next sequential number in record producer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-30-2018 05:39 AM
Hi Guys, need your help.
I have a custom table(u_numbers_test) and a custom field (u_number) to manage record numbering.
Set as follows:
u_number dictionary default value set as follows:
This works fine, and each time I insert a new record from the list I get the next sequential number (ex: NT0001001, NT0001002, ....) , as expected.
Next, I have a record producer on top of this table, I defined a custom variable to get the next sequential number
as follows:
It works, and it generates the next number, but it jumps 9 numbers each time the script runs (ex from this record producer I'll get NT0001001, NT0001010, NT0001019 etc) each time i "Try it".
How can I get the next sequential number from my Record Producer?
Thanks.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-30-2018 07:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-30-2018 08:42 AM
Number gets auto inserted with the default value set on the custom Table. You need not have a number mapping variable on your record producer.
Capture any other details that are required for the custom table, number gets autopopulated.
Thanks & Regards,
V