How to Create and Reset an Auto-Incrementing Number Field
You can configure a number field to auto-increment its value and reset it when it reaches a certain threshold. This feature is particularly useful in processes like creating lots or batches.
- Navigate to the form builder of your preferred form and include a Number field.
- Create a new workflow to execute on the Validations on form submissions of the form and select the record event as Created.
- Click Add New Action and add the following script to the Deluge editor.
- //Fetch the value stored in the Number_Field and sort all records in your form based on their added time in descending order.
- Data = <Form_Link_Name>[ID != null] sort by Added_Time desc;
- //Create another variable to retrieve the value stored in the number field that was most recently added.
- counter = Data.<Number_Field>;
- //Increment the counter by one and assign it to the number field. If the counter value reaches 3, reset it to 1. This means the counter resets after processing every third record.
- if(counter == null || counter ==3)
- {
- input.<Number_Field>=1;
- }
- else
- {
- input.<Number_Field>=counter + 1;
- }
- }
You can also choose to hide/disable this auto-incrementing number field to prevent manual user entries. To hide this field:
- Create a workflow by selecting the record event as Created or Edited and the form event as Field rules.
- On the subsequent page, click Add New Action, choose Hide fields, set this action to run always, and select the Number field.
See How It Works
Related Links
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Auto populate a field based on the selection from a lookup dropdown
Requirement When a value is chosen from a lookup dropdown, related values are populated in the other fields of the same form. Use Case An order management app contains a form to store order details. When the admin chooses the customer name from ...Create Serial Number for subform rows
Requirement Create serial numbers or auto-numbers for subform rows when a new row is added. Use Case In an employee management system, an employee can add up to five dependents. It will be easy for the employees if the dependents added in the subform ...Understand auto number field
Understand auto number field The Auto Number field enables you to associate a sequential numeric value to each entry your users submit through your form. The number held by this field is automatically assigned immediately after your users submit an ...Add auto number field
Add an auto number field to a form Open the form builder. Add an auto number field to the form. (Refer to this page to learn how to add a field to a form) Enter the required number in the window that appears, then click Done . Note: The Start Index ...Autopopulate Zoho Creator field with Zoho People data
Requirement Autopopulate Zoho Creator field with employee information stored in Zoho People. Use case Let's assume an organization named Zylker has a private library. The regular users must purchase a membership in order to access the library, ...
New to Zoho LandingPage?
Zoho LandingPage Resources