> ## Documentation Index
> Fetch the complete documentation index at: https://zite.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Auto-generate IDs for database records
> Automatically create unique ID numbers for each new record on your Zite Database.
## Overview
For some use cases, generating unique record IDs can be helpful when keeping track of data or exporting it for external use.
### **Common use cases**
* **Invoices:** Easily assign and reference invoice numbers when billing clients
* **Data exports:** Maintain consistent identifiers across systems
* **Internal tracking:** Quickly reference specific records without confusion
## Create unique record IDs
In your database, create a new column or hover over an existing column and click followed by`Edit field`.
Choose the `Autonumber` field type.
Autonumber fields assign simple numbers starting from 1. For more control over how your IDs look, read on.
That's it! A number will now be generated for each row, whether existing or new.
## Create custom unique record IDs
Follow the [steps above](/help/database/configure-database/auto-generate-ids#create-unique-record-ids). You can hide this field from view.
`+ Add field` and select `Formula`.
You can read more about formulas [here](/help/database/configure-database/formulas).
Enter a **Title** or column name, followed by your **Formula**. Then, click `Create`.
That's it! A custom number will now be generated for both new and existing records.
Related topics