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();

 

 

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande