FastFormField nuAutoNumber: Difference between revisions

From nuBuilderForte
Jump to navigation Jump to search
(Created page with "The FstForm field nuAutoNumber is for storing number sequence that can be incremented for each new record. It is by default a VARCHAR(1000) field but should have the last one ...")
 
No edit summary
Line 6: Line 6:


[[File:Next_nuAutoNumber.png]]
[[File:Next_nuAutoNumber.png]]
The Auto Increment is done in the functions '''nuAutoNumber()''' and '''nuUpdateCounter()''' in '''nudata.php'''.

Revision as of 17:12, 15 January 2021

The FstForm field nuAutoNumber is for storing number sequence that can be incremented for each new record. It is by default a VARCHAR(1000) field but should have the last one as a digit that gets incremented.

The user table allows duplicates unless the schema has other keys / constraints. The AUTO_INCREMENT parameter is not necessary in the schema definition of the user table.

The Next Number attribute of the Input parameter can be initialised.

Next nuAutoNumber.png

The Auto Increment is done in the functions nuAutoNumber() and nuUpdateCounter() in nudata.php.