Tip 8 : How to dynamically add rows to a subform via script.

Hi everyone,

A fortnight has gone by, and we are back with a new tip that would help you dynamically add rows to a subform via script.

To understand how to do this, let's put ourselves in the shoes of an event manager. As an event manager, we need to regularly keep track of on-going events and the number of registrations received for each of the events.

For this we need to create a form to record the details of all our events. Let's name this form as Events. This form would have the following fields: Event Name and Even Date.

Now to get more registrations, we need to create a stateless form called Register for an Event Form which can be published and embedded in our blogs and websites. It would help us to record the details of all the attendees enrolling for our events. Here, we can even customize the submit button to “Register Now”.

But, how do we fetch the attendee details (from the Register for an Event form) and link it to events listed in the All Events report?

For this we need to create another form called Attendees Details which would be added as a subform in our main form — Events.

Here, Selected Event field would be a Lookup from the Events Form. For which you need to choose "Existing Relation", select the subform and name the Lookup field as "Selected Event". (This is how a bidirectional relationship is created between two forms. For more details click here)

Now, we need to fetch data from the Register for an Event Form on click of the Register Now button and dynamically add it to the subform in the All Events report.

Let's see how to do this:

For this, let's use the Add Record task on click action of Register Now button to push the data collected along with its Lookup value (Selected Event).

rec = insert into Attendees_Details
[
Added_User=zoho.loginuser
Selected_Event=input.Select_the_event
Attendee_Name=input.Name
Phone_Number=input.Phone_Number
Accomodation_Needed=input.Accomodation_Needed
];

Note: The primary key is the bidirectional Lookup Selected Event for which we are passing the value of the event selected by the Attendees in Register for an Event Form.

That's it, whenever an attendee registers for an event, the attendee details will get auto-populated in the subform in All Events Report. You can now easily view the attendee details for each of your events as given below.

Hope you got a fair idea on how to dynamically Add Rows to a subform via script. Keep watching this space for more such tips.

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Sticky Posts
[SESSION ENDED] Ask the Experts #07| Live Q&A: Building workflows with Blueprint in Zoho Creator |
Hello, Post the release of Zoho Creator Blueprint last month, we're happy to tell you that we'll be launching a new 'Ask the Experts' session on 16th September (Thursday) this month focussing on creating blueprints in Zoho Creator. The session will be
Zoho Creator Community Webinars | October - November 2020 [Completed]
Hello everyone, I’m happy to announce that Zoho Creator is hosting a new Community Webinar Series starting this October. This series is a learning initiative aimed at our developer community, where every session will take spotlight use cases focused on
Community Learning Webinar - Zoho Creator Blueprint & other release updates | July 29, 2021
Dear developers, This June, the Creator team unveiled a slew of updates including UI enhancements to the Detail View of reports, an new capabilities in Data Import and Connections, and most important of all, the release of Blueprint in Creator. Customize
Community Learning Webinar: Delve deep into the core concepts of Zoho Creator | 17th June, 2021
Dear developers, Every customer has unique business needs and unique problems to solve. To be able to give solutions to these problems, to get over any stumbling blocks and to be able to build applications expeditiously that tailor to specific needs,
[RECORDING: Community Webinar] | Build complex reports and documents with a Zoho Creator & Zoho Writer integration | March 23, 2021
Dear developers, Report generation is an essential activity to ensure decision makers have the best information available to be able to monitor and improve performance. Enterprises may need to generate and distribute stakeholder specific documents in