# Give every record a permanent reference

A stable identity for invoices, requests, jobs, and other sheet records.

An Auto-number field gives each saved record a permanent reference, independently of a document. A record still has its internal ID and editable Name. Use the generated reference when you want a number that people can recognize, search, and reuse without accidentally changing it.

## Set the format once

- Add a field to the sheet and choose Auto-number.
- Choose a starting number of at least 1, an optional prefix and suffix, and the minimum number of digits.
- Check the example, then save the field. The example does not reserve a number.
- Existing records receive numbers when the field is created. New records receive theirs when saved.

| Setting | Example | Behavior |
| --- | --- | --- |
| Starting number | 123 | First ordinal; fixed once the field is created. |
| Prefix | INV- | Literal text before the number. |
| Suffix | -US | Literal text after the number. |
| Minimum digits | 5 | Zero padding: INV-00123-US. Longer numbers grow naturally. |

Prefix and suffix each allow up to 80 characters. Padding ranges from 1 to 12 digits. Prefixes and suffixes are literal text, not date tokens or formulas. New Billing workbooks include an Invoice number field beginning at INV-0001; existing workbooks do not change automatically.

## Know what stays fixed

References cannot be typed, cleared, pasted, or imported into the generated field. Changing the prefix, suffix, or padding affects future allocations only. Existing records keep their exact saved strings after sorting, archiving, deletion, restoration, or a retry. Deleted references are not recycled.

The sequence belongs to one sheet field. Different sheets or fields can use the same format, so use distinctive prefixes when people need to distinguish them. It is a permanent identifier, not a gapless count of current rows. A populated text field cannot be converted to Auto-number; keep imported references in a separate field.

## Use the number throughout Ralti

- Search, filter, copy, export, or reference the stored string in a formula.
- Choose the field as Number source in a source-bound document template’s Page & data settings.
- After Create record in a Flow, bind the generated field from that step’s saved record output. Do not include it as a write target.
- Copy the reference into a normal Name field if useful. That Name remains editable; the Auto-number field remains authoritative.

## Handle a format conflict

If a new format would reuse an earlier reference, the write fails without saving a partial record or consuming a number. Change the prefix or suffix and retry. Document numbers are unique within the workspace: if another document already owns a mapped reference, reopen the row’s Document-column document or create its revision rather than assigning the same reference to a separate document.

A document that already has an assigned number keeps it. Changing the template’s Number source never renumbers issued versions. Templates without a selected field retain the existing document-type/year sequence.

