Smart Software For Maverick Entrepreneurs

By: CreatorScripts | May 22, 2019

Its 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 function.

https://www.udemy.com/master-zoho-creator-subforms/


That being said let´s jump on to the process in question. We are using a Gym App for testing and the goal is to add Classes to a New Member dinamically so user does not have to add classes everytime.


First, you need to call ( get ) the Member record you are going to be working with. Second, you want to create a Form with the records you want to add. In this case our Main Courses is a predetermined number of classes a member can take. You can up...

Category: Zoho Creator 

Tags: Subforms 

By: CreatorScripts | February 17, 2017

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.

By: CreatorScripts | January 25, 2017

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 form with all the relevant information about the Product. Price, Description, etc.


Second, you  need to fetch the Product information-based "On user input" inside the items Subform and add the below deluge scripting.


prodct  =  Products  [ID == row.Product];
row.Description = prodct.Description;
row.Price = prodct.Price;
row.Qty = 1;
if ((row.Price  !=  null)  &&  (row.Qty  !=  null))
{
    row.SubTotal = (row.Price ...

By: CreatorScripts | November 29, 2016

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.- Orders and Items. An Order can have multiple items and 1 item can be part of many Orders. Creating many to many relationships.


Second, you need to add the Subform Items inside the Form Orders and name it. Then you have to add a Lookup field in the Items Form and click on Existing Relations. 

Category: Zoho 

Tags: Zoho Creator, Subforms