Autonumber

The Autonumber data type 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. You can also add in tokens so that Spreadsheet.com knows to add in today's day, month, or year.

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. Autonumber is ideal for tracking product orders, bugs in a bug tracker, or as a reference to ensure data integrity.

Autonumber.png

Configuration Options

Strict

Strict is always enabled for Autonumber columns and data cannot be added or changed to cells in this column. Only one Autonumber column can be applied per worksheet.

Preview

As you adjust the Display format and Starting number, the Preview will display a preview of the first value that will be used in your Autonumber column.

Display format and Starting number

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. 

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.

You can set your Autonumber to start at any non-negative integer via the Starting number field.

In the example below, we've configured a new Autonumber column to have a prefix of the current month (January) and a suffix of the current year (2022) with a three digit fill in between and a starting value of 1. As we add new records to our worksheet, the Autonumber column autofills as follows:

Autonumber-Example.jpg

How to Use the Autonumber Data Type

Autonumber works by autofilling values in your spreadsheet as you create and add data to new rows. You can't edit the autonumber values directly. Rather, the Autonumber column will populate automatically when another cell in that row is filled for the first time.

Autonumbers are one of Spreadsheet.com's automatic column-level data types. Check out the Created at or Created by column-level data types, or read on to learn more about the rest of Spreadsheet.com's Data Types