Autonumber

  • Updated

 

The Autonumber data type mceclip1.png is for automatically assigning a non-editable incremental value to uniquely identify rows. It is a Dynamic data type, restricting all data in a column to that data type and creating cell data dynamically. You can, optionally, configure a prefix, suffix, fill format, and starting number. Also, you can add in tokens so that Spreadsheet.com knows to add in today's day, month, or year.

mceclip0.png

Autonumber data types allow you to create a unique and uneditable ID for your rows, ensuring that each row has a unique identifier even if some of the data in a row is the same. Ideal for tracking product orders, bugs in a bug tracker, and as a reference to ensure data integrity.

As Spreadsheet.com applies Autonumbers, columns default to strict, and data cannot be added or changed to cells in this column. Only one Autonumber column can be applied per worksheet.

Display format, Starting number, and Preview

The Autonumber data type allows you to customize your identifier to your unique needs. You can input alphanumeric text to go before the number (a Prefix), to fill between the Prefix and the number (Fill), or after the number as a suffix. 

Also, you can set your Autonumber to start at any non-negative integer.

For instance, starting with the below settings (Prefix of "ID-" and Suffix of "-WEB") to track web orders:

mceclip1.png

We then get a column with matching autonumbers:

mceclip3.png

Tokens

Autonumber also supports tokens in the prefix and suffix to allow any combination of day, month, year in the autonumber values. These tokens are: {DD}, {MM}, {YY}, {YYYY}, and correspond to the current day of the month, the month, and the year respectively.

For example, setting the Prefix as "{MM}/{DD}-" and the Suffix as "-{YYYY}" when the date is March 10, 2020
mceclip2.png
...should result in values that look like the following:
mceclip1.png

Autonumbers are one of Spreadsheet.com's automatic column-level data types. Check out the Created at or Created by data types, or all of our column-level data types in our introduction to data types article.