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 form, New Order,
which customers use to order products. When a customer enters his/her customer ID, their frequent orders are fetched from
the Orders Database
form and populated in
the New Order
form's subform.
Steps to follow
|
Form
|
Form Link Name
|
Field Type
|
Field Name
|
Field Link Name
|
|
Orders Database
|
Orders_Database
|
Name
|
Customer Name
|
Customer_Name
|
|
Single Line
|
Customer ID
|
Customer_ID
|
||
|
Subform
|
Order History
|
Order_History
|
||
|
New Order
|
New_Order
|
Single Line
|
Customer ID
|
Customer_ID1
|
|
Single Line
|
Customer Name
|
Customer_Name1
|
||
|
Subform
|
Order Details
|
Order_Details
|
The workflow
will
be triggered when a customer enters a value into the Customer ID field,
so
we are selecting the
Form Event
as
User input of a field.
3. Click
Add New Action.
4. Save the following
Deluge snippet in the
Deluge editor:
-
// Fetch customer records from the database based on the specified Customer ID
-
database_records = Orders_Database[Customer_ID == input.Customer_ID1];
-
-
// Assign the customer name from the fetched record
-
input.Customer_Name1 = database_records.Customer_Name;
-
-
// If a customer record is found, fetch data from the subform
-
if(Customer_Name1.isEmpty() == false)
-
{
-
input.Order_Details.clear(); // Clear subform of any previous entries
-
for each line_item in database_records.Order_History // Iterate through each subform row to fetch their values
-
{
-
// Create subform rows with fetched data
- row1 = New_Order.Order_Details();
- row1.Product_Name1=line_item.Product_Name;
- row1.Quantity1=line_item.Quantity;
- rowcollection = Collection();
- rowcollection.insert(row1);
- input.Order_Details.insert(rowcollection);
-
}
-
}
-
-
// If a customer record is not found, clear any previous entries
-
else
-
{
-
input.Order_Details.clear();
-
}
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:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
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 subform data from a form based on lookup selection
Requirements Streamline the process of retrieving and displaying relevant data by auto-populating a subform based on the value selected in a lookup field. Use Case Consider an IT asset management application used by organizations to conduct asset ...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 ...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 ...How to copy 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 ...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 ...
New to Zoho LandingPage?
Zoho LandingPage Resources