![]() I hope this article has helped you understand how to work with subforms dynamically using this new feature from Zoho Creator. What if we wanted to delete everything from the sub form? We can do that by writing out, “” like this: If we run that custom function and then reload the form, we can see it correctly added rows to the Attendee subform. We replace input with attendee_register_record and it just works □ What if we want to add subform rows from a custom function?įirst of all, we will get the “attendee register record.” The example above was for the scenario where we will add the subform rows while the form is being edited. Because the name section is a Name data type, we use Name.first_name and Name.last_name like this:Īfter that, I insert that row into my collection.įinally, the last step I do is “” with the collection like this: I can then set fields like the email, first name, and last name in that subform row. Once I fetch that data, then I’ve got my new_row variable ready. When its disabled, the Creator APIs will respond with the status code 1130 and message 'You do not have. The API access permission (enabled by default) determines if the usersassociated with a permission set are allowed to use your Creator applications APIs. Then, I need to fetch some of the other information from the Contact records in the CRM. Refer to the Developer API count shown in your accounts usage details. To find the API name of the subform, I click on the subform in the form editor and check the “Field link name” (Attendees) To find the API name of the form, I go to “Edit this application” and there in the URL, I can see that the API name is Attendee_Register. In order to add a row to the sub form, it is important to know that this is the name of the main form (Attendee_Register): In order to add data to the collection, I iterate over the data I fetch from Zoho CRM: The attendees. I’ve recorded a video about the difference between collections, lists, and maps, but for now, just think of it as a list. I set up a collection called attendees_to_add. Import data Description Learn how to import data into your Zoho Creator application with spreadsheets. ![]() ![]() What I wanted to do is show the attendee details in the Zoho Creator subform. Inside that module, I have a multi-select lookup for the course attendees. However, once I choose a course, you can see it has automatically populated ten attendees. I found the documentation a bit confusing, so I’m going to show you an example on how it works.Īs you can see on this initial page, there aren’t any subform rows. Zoho recently released a new feature that has been eagerly anticipated for many years: The ability to add or remove rows from the subform. ![]() Select the SubForm report from the Reports tab, click on Column Properties and select. For this tutorial in video form, refer to this youtube link. Zoho Creator Lookup Field Dynamic Filterdata entered in a form. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |