Autonumber

Autonumber

Autonumber fields automatically assign a unique, incremental number to each record, making identification easy.

Note: The Autonumber field is not intended to count the number of records in a table. When a record is deleted in between, the rest of the records will not be renumbered.


To create an autonumber field, select Autonumber field from the list of field types, by clicking the + icon from the field header.

  

By default your records will be numbered in the usual sequential numeric ascending order (1, 2, 3, 4).



To edit an autonumber field

  1. Click the dropdown arrow next to the field name and select Edit
  2. Specify the interval between numbers by choosing the Initial Value and Step Size
  3. Add Prefix and Suffix to your values, based on your requirement.