Auto-calculating values on a subform's field
Requirement
Use Case
Steps to follow
|
Form Name
|
Form Link Name
|
Field Type
|
Field Name
|
Field Link Name
|
|
Products
|
Products
|
Single Line
|
Product Name
|
Product_Name
|
|
Currency
|
Rate
|
Rate
|
||
|
Order
s
|
Orders
|
Subform
|
Order Details
|
Order_Details
|
|
Currency
|
Total Amount
|
Total_Amount
|
||
|
Number
|
Number of Items
|
Number_of_Items
|
- disable Total_Amount;
- disable Number_of_Items;
- disable Order_Details.Rate;
- disable Order_Details.Sub_Total;
- // Fetch the Rate of the selected Product
- rate=Products[ID==row.Products].Rate;
- // Assign the fetched Rate
- row.Rate=rate;
- if( row.Quantity != null)
- {
- row.Sub_Total = row.Rate * row.Quantity;
- }
- //Product Total and Sub Total calculations here
- if(row.Quantity != null && row.Rate != null)
- {
- row.Sub_Total=row.Quantity * row.Rate; //Calculate the total based on the quantity
- }
- else
- {
- row.Sub_Total=0;
- }
- //Count the number of items ordered
- input.Number_of_Items = Order_Details.count();
- //Calculate sum of the prices of all the items
- input.Total_Amount = Order_Details.sum(Sub_Total);
See how it works
Points to note
-
The average, minimum, maximum, and median values can be found in the same way. The average amount calculated using deluge is shown in the video for reference.
-
It is possible to display the overall statistics of the subform values on the report. We can have corresponding numerical fields in the main form to find the statistical values of the subform numerical fields like our example here. In our above example, go to the All Orders report. Under Quick View click the first layout. Select the Total Amount field and toggle the Sum, Average, Min, and Max fields, as shown below:
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:
Still can't find what you're looking for?
Write to us: support@zohoforms.com
|
Quick Links |
Workflow Automation |
Data Collection |
|
|
||
|
Form Templates |
||
|
|
||
|
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
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 ...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 ...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 ...Statistical values on a report based on numerical fields
Requirement Display the common statistical results on the reports for the numerical fields in a form, to help in identifying trends and decision-making process. Use Case In any sales-based business, crunching numbers is a big task. An order ...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 ...