FastFormField nuAutoNumber

The FastForm 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.

BIGINT works if manually changed at the table level in a MySQL client like nudb (phpMyAdmin) or SQLyog.

If the code in nubuilders.php is changed to use BIGINT unsigned, the older VARCHAR(1000) still works.

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.

UPDATE 2021-01-16: v4 Commit | v4.5 Commit - nuAutoNumber has changed from VARCHAR(1000) to BIGINT(20) UNSIGNED whilst retaining backwards compatibility.

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

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