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
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.
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?
Zoho DataPrep Resources
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 ...Add data to a different application
Requirement Automatically add a record to a form of one application when a record is added in a different application. Use Case A Zoho creator account has two applications: Contact Management and Order Management. All the customer details maintained ...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 ...
New to Zoho LandingPage?
Zoho LandingPage Resources