How to properly set Subforms in Zoho Creator Part 3

How to properly set Subforms in Zoho Creator Part 3

The first step is to have the Subtotal or Total field value in the Order Form. Normally this would be a currency field or decimal field if you need to consider 1 or more decimals into your calculations. If not you can also set it the field as a Numeric value field. Our example uses a currency field.


Second, you need to think about the places where the script to aggregate the rows needs to occur. In our case, there are several places. On Add Row, On Selecting a new Product, On Changing the Qty amount or the pricing. It is important that all scenarios are considered otherwise your calculations may not be properly aggregated if it encounters a scenario that you have not considered in your scripting yet.

Last but not least, the script below is ready for you to copy and paste into your application. Assuming of course that the field names of your Order Form are named exactly as our test application.



if ((row.Price !=  null)  &&  (row.Qty  !=  null))

{
    row.SubTotal = (row.Price  *  row.Qty);
}
t = 0.0;
if ((row.Price  !=  null)  &&  (row.Qty  !=  null))
{
    for each rec in Item_Details
    {
        t = (rec.SubTotal  +  t);
    }
}
input.Subtotal = t;

Do not hesitate to contact us if you have any questions. I would be more than glad to help you build an amazing online database application with Zoho Creator. Or check out our full Master Zoho Creator Subforms Course to learn more.



    • Related Articles

    • How to properly set Subforms in Zoho Creator Part 1

      This is the most important step in the process of setting up your Zoho Creator database. A properly linked setup will enable your information to run smoothly and avoid wasting space ( MB ) First, you need to create at least 2 Forms. For example.- ...
    • How to properly set Subforms in Zoho Creator Part 2

      To build a robust Order form in Zoho Creator you need to be able to automatically "fetch" the information about a product and let the system pre-populates the subform with pre-existing data in the Products Table. First, you need to have a Products ...
    • How to define number of subform rows dynamically using script in Zoho Creator?

      It´s important to highlight that this post assumes you are already familiar with proper subform creation in Zoho Creator. If you are not please check out our Master Zoho Creator Subforms course in the url below before implementing this custom ...
    • What to do if you get locked out of your Zoho Account ?

      You need to contact Zoho Team directly @ Email:  support@zohoaccounts.com the instructions you need to follow are below Thank you for writing to us. Please respond to the below-requested security questions, so that we can validate and provide you a ...
    • How to search ZOHO CRM Contacts using Phone value?

      Script giving error... con = phn.toLong; contactdetails = zoho.crm.searchRecords("Contacts",("Phone:equals":con*)"); info contactdetails; The correct script is... con = phn.toLong(); contactdetails = ...