Number records automatically (invoice numbers, ticket IDs)
Updated Aug 9, 2026
Nobody wants to hunt for "the last invoice number we used". With an auto rule, Sheetward assigns the next running number to every new record. That's one less box to fill in on the form, and no one has to keep a numbering list on the side.
Turn it on
- In the Rules_ sheet of your App Specification workbook, give the field the rule type auto (you can also write autogen — both work).
- Open the app and click Change app, then upload the workbook.
- Done. Each new record now gets the next number automatically, and the field shows as read-only in the form so nobody can overwrite it.
Where it shines
Any field where every record needs its own running number:
| Example | The auto-numbered field |
|---|---|
| Invoices | Invoice number |
| Support or helpdesk tickets | Ticket ID |
| Equipment or asset registers | Asset tag |
Pair it with a key rule
An auto number tells records apart; a key rule makes that official. Add both rule types to the same field so each record stays uniquely identifiable when you import data.
| Rule type | What it does for the field |
|---|---|
| auto (or autogen) | Sheetward fills in the next number on each new record |
| key | Marks the field as the record's unique identifier, so imports match up correctly |
In the Rules_ sheet, enter the two rule types as separate rows for that field — one row for auto, one row for key.
Good to know
- The auto-numbered field is read-only in the form — Sheetward fills it in, your team can't type over it.
- The numbering starts working as soon as you upload the workbook with Change app; new records from then on get the next number.