Wednesday, February 8, 2017

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 populate 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);




Check How to properly set subforms in Zoho Creator Part 1

Tuesday, January 3, 2017

6 of the Most Popular Zoho Creator posts of 2016

SummaryTagsUrl
Zoho speeds up Innovation with mobile App CreatorZoho Creator, Online Database

https://www.creatorscripts.com/blogs/post/Zoho-speeds-up-Innovation-with-mobile-App-Creator/
Fetch Email Id Associated with a UsernameZoho Creator, onlinedatabase


https://www.creatorscripts.com/blogs/post/Fetch-Email-Id-Associated-with-a-Username/
How QR code and barcode scanning with Zoho Creator works?Zoho Creator, Barcode, QRCode


https://www.creatorscripts.com/blogs/post/How-QR-code-and-barcode-scanning-with-Zoho-Creator-works/
Zoho Creator Hack: Specify "OR"  or "AND" operators when setting criteria for displaying a viewZoho Creator, Views criteria


https://www.creatorscripts.com/blogs/post/Zoho-Creator-Hack-Specify-OR-%C2%A0or-AND-operators-when-setting-criteria-for-displaying-a-view/
Why Zoho Creator is winning the database war against MS AccessZoho Creator, MS Access


https://www.creatorscripts.com/blogs/post/Why-Zoho-Creator-is-winning-the-database-war-against-MS-Access/
How to properly set Subforms in Zoho Creator Part 1Zoho Creator, Subforms


https://www.creatorscripts.com/blogs/post/How-to-properly-set-Subforms-in-Zoho-Creator-Part-1/