I have deleted all records from a module, yet the auto-number field for a new record I create continues from the previous order rather than #1. How do I correct this?

I have deleted all records from a module, yet the auto-number field for a new record I create continues from the previous order rather than #1. How do I correct this?

Assume you have created 10 records in a module. These have been created in an order specified by your Auto-number field settings. You are now deleting all those records because you want to start afresh. When you create a new record, the auto-number reads #11 whereas ideally you want it to start with #1.

This happens because the records that you have deleted are still part of the CRM system in its Recycle Bin. Go to Setup > Data Administration > Recycle Bin and empty the trash. Now when you go back and create a new record in your module, you will see that the Auto-number settings have been corrected.






    • Related Articles

    • De-duplicate records (Auto-merge duplicates)

      In case you are not sure which records have been duplicated, you can let CRM run a check on modules using the De-duplicate tool. CRM will automatically find and merge exact matches. In case of conflicts in field values, you must manually resolve the ...

    • How do I create an auto number field?

      You can create an auto number field by following these steps: Log in to Zoho CRM with Administrator privileges. Click Setup > Customization > Modules and Fields. Select the Module from the Modules list view. Drag and drop the Auto Number field type ...

    • Work Order Setup

      Request to Work Order Mapping On choosing the Convert to Work Order transition in a Request, the Create Work Order page is displayed with field values pre-filled. Using the Request to Work Order Mapping setting, you can determine the Request field ...

    • Work Order Automation

      Create Work Orders  A  Work Order is a record created for executing a customer service request. A Work Order can be created in one of the following ways: From Requests: Using the Convert to Work Order transition in a Request, a Work Order can be ...

    • Create a new candidate

      To create a new candidate form using Web Forms, follow the steps given below Navigate to Setup > Portal Setup > Web Forms. Under the Resume tab, click Create New Resume Form. An Untitled Form is displayed. Click Let's get started. The mandatory Last ...