Autonumber fields in Zoho CRM automatically assign unique, sequential numbers to each record, making them easy to identify and track. To retrieve or adjust these settings, you access the field's configuration menu and review the numbering parameters.
Why this matters
Autonumber fields are essential for creating standardized record identifiers—think invoice numbers, ticket IDs, or account codes. If your numbering scheme needs adjustment (different starting point, gaps between numbers, or custom prefixes), you'll need to know where to find and edit these settings. Understanding how to retrieve and modify autonumber configuration helps you maintain consistent naming conventions across your CRM.
Step-by-step
Step 1. Open the module containing your autonumber field. Click the dropdown arrow next to the field name and select Edit to access the field's configuration panel [1].
Step 2. Review the current numbering setup. By default, Zoho CRM assigns numbers in sequential ascending order (1, 2, 3, 4) [1]. The configuration screen shows your existing interval and formatting choices.
Step 3. Adjust the Initial Value to set where numbering begins, and modify the Step Size to control the interval between consecutive numbers [1]. For example, if you want numbers to start at 1000 and increment by 5, set those values here.
Step 4. Add a Prefix and Suffix to your autonumber values if needed [1]. A prefix might be "INV-" and a suffix could be "-2024", resulting in numbers like "INV-1-2024", "INV-2-2024", and so on.
Step 5. Save your changes. The new settings apply to records created after the update; existing record numbers remain unchanged.
Common pitfalls
Autonumber fields do not recount or renumber existing records when you delete one in between [1]. If you delete record #5, the remaining records keep their original numbers—there is no automatic renumbering to fill the gap. This is by design and prevents data integrity issues. Additionally, autonumber fields are not intended to count the total number of records in a table [1]; they simply assign unique identifiers.
What to check
- Verify that your Initial Value and Step Size match your numbering strategy before saving.
- Confirm that any Prefix or Suffix displays correctly on newly created records.
- Test the field on a test record to ensure the format meets your requirements before rolling out to your team.
---
*This article is provided by Beam Help — independent expert support for Zoho. We are not official Zoho support.*