Zoho Creator makes building on-the-fly business apps a breeze. And today it gets even better: Introducing subforms!
Zoho Creator users are familiar with the many fields you can include on a form. For example, we’ve had a Look Up field for a while. Lookup fields are useful when you want to associate data in one form with a single piece of data in another form.
But what happens if you want to associate one record in a form with multiple records in another form? For example, what if you have an application of students and you want to keep track of the classes they are taking? Students will be attending more than one course. That’s when subforms become very useful.
In this case, you can create a form that holds the student’s general details (i.e Name, ID number, etc), and another form that holds the course details (Course Name, Instructor, etc). Then, while on the parent form (the form that holds the student details) you’ll insert a subform field, and you can choose to insert the course details – and thus that will become the child form. Using the subform field, you’ll give the user the ability to create multiple courses for each student. Here’s a quick video that explains how to add subforms to your application.
Any new feature in Zoho Creator, comes with some Deluge Power to it. Subforms are scriptable too. When you build your app, you can add workflows and business rules to the parent form and to the subform. The subform itself is listed among the fields in the script builder. In addition, “On Add Row” and “On Delete Row” are 2 new events meant specifically for subforms. These tasks can be executed when a child record is added to or deleted from the subform.
We would love to hear what you think of this latest addition to Zoho Creator.