stop auto numbering before submitting record

neelufer
Tera Contributor

hi,

 

i have created child table "abc", where parent table is " Task".  here, the number field gets incremented everytime, when clicked on new record button. However, i want the record to get increment only after submitting the record.

 

Please help me to achieve this.

 

Thanks

Neelufer

1 REPLY 1

Anil Lande
Kilo Patron

Hi,

You have to do few configurations:

1. Open the dictionary of Number field and create dictionary override record for Number column:

AnilLande_0-1680274159724.png

2. Set table as your table and Check override Dictionary checkbox.

AnilLande_1-1680274256694.png

 

Save the dictionary override record.

3. Create before insert Business rule like below:

AnilLande_2-1680274537251.png

AnilLande_3-1680274569182.png

 

use below line in your Business Rule Script:

 

current.number = getNextObjNumberPadded();