How to clear and add values in dropdown of a subform
- Create a new workflow to execute on your preferred form event.
- Click Add New Action > Deluge Script and add the following script to the Deluge editor.
- // Create a list of values to replace the existing dropdown values
- New_Items = List();
- New_Items.add("Item 1");
- New_Items.add("Item 2");
- New_Items.add("Item 3");
- //Utilize an 'if' statement to selectively clear or add dropdown values based on a specified condition. Define your condition within the <criteria> placeholder.
- if(<criteria>)
- {
- //Clear and add the drop values
- row.<Dropdown>:ui.add(<New_Items>);
- }
Where
<New_Items> | is the LIST that contains the values that to be replaced with the existing values in the drop down. |
<Criteria> | is the conditional expression that determines whether the subsequent code within the 'if' statement should be executed. |
<Dropdown> | Is the field link name if the drop down field added in the subform |
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:
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.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Add subform rows with dynamic data from another subform
Requirement Automatically add rows to a subform and populate it with dynamic data fetched from another subform. Use Case A form named Orders Database contains customer details and their frequent orders in a subform. We have another ...Auto-calculating values on a subform's field
Requirement Perform statistical operations on the numerical fields in subforms for analysis. Use Case In an order management application, there are two forms, Order and Product. The Product form lists all the products in the inventory and the Order ...Display subform's report in parent form's report
Requirement When the user views a particular record in a report that has subform, the values in the corresponding records are also shown. Use Case An order management application contains two forms: Customers and Orders. The Customer s form is ...How to copy a subform data to another subform using a report action
The values in a subform of a record can be copied to another form's subform using Deluge within the report actions. This allows seamless transfer of subform data between forms, ensuring consistency. For example, consider a Zoho Creator resource ...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 ...