Smart Software For Maverick Entrepreneurs

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  *  row.Qty);
}
 

Subform Zoho Creator

Category: Zoho Creator 

Tags: Deluge Scripts, Subforms 

Comments:

Lara Hutchinson

Posted on : June 03, 2017

Google


Post a Comment