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
row.Description = prodct.Description;
row.Price = prodct.Price;
row.Qty = 1;
if ((row.Price != null) && (row.Qty != null))
{
row.SubTotal = (row.Price * row.Qty);
}
 |
Great tutorial! Subforms are such a powerful feature in Zoho Creator, especially for managing one-to-many relationships within a single form—like invoices with multiple line items or project tasks. Your step-by-step guidance on setting them up properly is incredibly helpful for avoiding common pitfalls like data duplication or validation issues. For more complex implementations, working with an experienced Zoho Creator consultant can really streamline the process and ensure everything is optimized. Thanks for sharing such practical advice!
ReplyDelete