Multiple connected subforms in one form or a suggested workaround

Multiple connected subforms in one form or a suggested workaround

I have several objects that are 1-many related objects in a kind of vertical hierarchy so for example Courses have several Units and Units have several Objectives and Objectives have several Criterias etc.

I would like to make it easy for the user to add this structure in one form since a lot of the information is common so no need to repeat the whole hierarchy again every time they want to add a Criteria for example.

I created a Add Course form which allows adding Units (as a subform):


I was also trying to allow him to add the Objectives in the same form since Objectives are a subform of the "Units" form which is added as a subform to this main form. Basically Objectives was a subform of the subform but it does not look like this is possible.

Since I am new to Zoho Creator I was wondering if any of you experts had any suggestions to tackle this problem.

Can I add two sibling subforms and use Deluge to connect between the two? But if so, how do I "select" a record in a subform so that I can connect the other subform to it? Subforms seems to only have "input" fields not like a record where you can "select".

Should I be using Pages/Reports instead? How do I connect the different parts in a Page so that when I select a "record" on one part I show the list of child records on another part? And can I add new records and have them immediately appear in the same screen?

Any help would be greatly appreciated

    Access your files securely from anywhere

          Zoho Developer Community




                                    Zoho Desk Resources

                                    • Desk Community Learning Series


                                    • Digest


                                    • Functions


                                    • Meetups


                                    • Kbase


                                    • Resources


                                    • Glossary


                                    • Desk Marketplace


                                    • MVP Corner


                                    • Word of the Day



                                        Zoho Marketing Automation


                                                Manage your brands on social media



                                                      Zoho TeamInbox Resources

                                                        Zoho DataPrep Resources



                                                          Zoho CRM Plus Resources

                                                            Zoho Books Resources


                                                              Zoho Subscriptions Resources

                                                                Zoho Projects Resources


                                                                  Zoho Sprints Resources


                                                                    Qntrl Resources


                                                                      Zoho Creator Resources



                                                                          Zoho Campaigns Resources


                                                                            Zoho CRM Resources

                                                                            • CRM Community Learning Series

                                                                              CRM Community Learning Series


                                                                            • Kaizen

                                                                              Kaizen

                                                                            • Functions

                                                                              Functions

                                                                            • Meetups

                                                                              Meetups

                                                                            • Kbase

                                                                              Kbase

                                                                            • Resources

                                                                              Resources

                                                                            • Digest

                                                                              Digest

                                                                            • CRM Marketplace

                                                                              CRM Marketplace

                                                                            • MVP Corner

                                                                              MVP Corner





                                                                                Design. Discuss. Deliver.

                                                                                Create visually engaging stories with Zoho Show.

                                                                                Get Started Now


                                                                                  Zoho Show Resources


                                                                                    Zoho Writer Writer

                                                                                    Get Started. Write Away!

                                                                                    Writer is a powerful online word processor, designed for collaborative work.

                                                                                      Zoho CRM コンテンツ






                                                                                        Nederlandse Hulpbronnen


                                                                                            ご検討中の方





                                                                                                  • Recent Topics

                                                                                                  • New in Writer: Create personalized documents with Bigin!

                                                                                                    Hi everyone, We're excited to announce that Bigin now integrates with Zoho Writer as a data source for mail merge templates. This opens up new possibilities for generating personalized invoices, contracts, emails, letters, and other documents. Streamline
                                                                                                  • Export Invoices to XML file

                                                                                                    Namaste! ZOHO suite of Apps is awesome and we as Partner, would like to use and implement the app´s from the Financial suite like ZOHO Invoice, but, in Portugal, we can only use certified Invoice Software and for this reason, we need to develop/customize on top of ZOHO Invoice to create an XML file with specific information and after this, go to the government and certified the software. As soon as we have for example, ZOHO CRM integrated with ZOHO Invoice up and running, our business opportunities
                                                                                                  • Zoho Desk - Trial Extension Error - Insufficient Privileges to perform this operation. Contact your Administrator.

                                                                                                    Zoho Desk - Trial Extension Error - "Insufficient Privileges to perform this operation. Contact your Administrator." I am receiving this error above when trying to extend my trial, and I am the Administrator. Please advise on how to bypass.
                                                                                                  • Can we turn off archiving views?

                                                                                                    Is there a way to turn off view archiving? Some views aren't used regularly, and archiving may force us to recreate them.
                                                                                                  • Employee User to see Hours not $$

                                                                                                    We have a Role of Project Manager who needs to be able to see Project Budgets in terms of Hours, but not the $ associated with the budget. We also don't want this Role to see the Hourly rates associated with users on a project. Is this possible? 
                                                                                                  • Elektronische Rechnung (PDF) im xRechnung / ZUGFeRD-Format

                                                                                                    Hat jemand eine Lösung in Books realisiert? Wir sind am Export- und am Eingangsrechnung-Import interessiert.
                                                                                                  • ADDDATE formula using 2 calculations

                                                                                                    Hello, I want to create an ADDDATE formula using 2 calculations, add 1 month and deduct 1 day. the formula that I need should look like this: ADDDATE(due_date, 1, "Months")+ ADDDATE(due_date, -1, "Days") Each row itself works fine, but when I'm trying
                                                                                                  • How to pass dynamic parameters in an iframe inside Webtab

                                                                                                    Hello, I have a custom url like htts://www.test.com?zoho_id= 123456789. I know that if a have a custom button and using a custom function (openurl) I can open the above link by passing dynamically the Zoho ID (lets say the record ID in the Contacts Module).
                                                                                                  • Zoho Creator Embedding a Zoho Form in a Creator App

                                                                                                    Hi I've created multiple Zoho Forms for my company for internal use by myself, I am trying to find a way I can either create an app using creator that when I open it then I'll have all my forms listed on the left hand side, so each one will have it's
                                                                                                  • Agrément Norme Française Européenne Zoho Books, Zoho CRM, Zoho Invoice

                                                                                                    Bonjour, Je fais partie des nombreux Fan de Zoho depuis 10 ans ! Les logiciels zoho (permettant la facturation) sont super mais non agrée depuis 2018  ! J'ai tout capitalisé sur zoho et fait confiance depuis des années et me retrouve dans une impasse. 
                                                                                                  • Zoho Books - agrément français ?

                                                                                                    Bonjour, J'utilise Zoho Books pour ma facturation. Je vais bientôt changer de régime de TVA et essaye donc de vérifier si je suis en conformité pour mon logiciel de facturation. Est ce que Zoho Books est agrémenté (selon l'article 286-I-3° bis du CGI)
                                                                                                  • Factur-X la norme pour la facturation électronique

                                                                                                    Hello la team Zoho France, J'espère que vous allez bien. J'écris ce post car j'aimerais que Zoho rende conforme les factures émises depuis les apps Zoho Finance (Zoho Books, Zoho Invoice, Zoho Subscriptions) avec le format Factur-X qui devient la norme
                                                                                                  • Convert invoice from zoho to xml with all details

                                                                                                    How to convert an Invoice to XML format with all details
                                                                                                  • Cannot reorder fields in Page Layout in Expenses and Purchase Requests

                                                                                                    It is very inconvenient that the custom fields in Page Layout cannot be re-ordered. The only way is to remove the fields and re-create them; however, it is impractical. This would affect the reports and dashboards we are having. Not able to re-order the
                                                                                                  • Trigger a Workflow Function if an Attachment (Related List) has been added

                                                                                                    Hello, I have a Case Module with a related list which is Attachment. I want to trigger a workflow if I added an attachment. I've seen some topics about this in zoho community that was posted few months ago and based on the answers, there is no trigger
                                                                                                  • Billable Entries Not Syncing Between Zoho People and Zoho Books

                                                                                                    Hello Zoho Support Team, I’m experiencing an issue with the integration between Zoho People and Zoho Books. Here are the details: I created a project in Zoho People and linked it to a customer in Zoho CRM. The project successfully synced to Zoho Books.
                                                                                                  • [Free Webinar] Learning Table Series - Creator for the Finance Industry

                                                                                                    Hello Everyone! The Learning Table Series is a free monthly webinar that runs for around 45 minutes. It's offered to our Community users and aims to provide a dynamic learning experience by demonstrating how Creator can be used as a solution for various
                                                                                                  • New UI of zoho people

                                                                                                    I recently switched to the new Zoho People UI, and I’m not happy with it. It’s confusing, and the navigation isn’t easy to use. In the old UI, I could easily view all leave applications for the whole organization. But now, I can only see leave requests
                                                                                                  • Issues with email signature not showing up correctly

                                                                                                    I've recently set up my Zoho mail account, and I've noticed some issues with my signature doing funny things such as the logo image getting blown up really large or showing up as an attachment or as text. The text next to which has my name and title is
                                                                                                  • Unable to fetch SaleOrders

                                                                                                    We are trying access SalesOrders on the new API, but we keep receiving the following error. We are using Postman to test. Error: URL: https://www.zohoapis.com/crm/v2/SalesOrders { "code": "INVALID_MODULE", "details": {}, "message": "the module name given
                                                                                                  • Automatic archive sent emails

                                                                                                    Hi, for compliance reasons we need to archive automatically sent emails, even when an email is deleted from the "Sent" folder. How to achieve that? Thx
                                                                                                  • Zero Support For A Paying Customer

                                                                                                    I opened a support ticket to get absolutely no responses. My support request is being 100% ignored. What am I paying for exactly?
                                                                                                  • Enable and disable modules within the Zoho Projects mobile app

                                                                                                    Hello, everyone! In the latest Android (v3.9.14) and iOS (v3.9.2) versions of the Zoho Projects app, we have introduced an option to enable and disable the modules within the app. Now, when an user signs up on the app, they can choose modules of their
                                                                                                  • Emails "To" showing Subject

                                                                                                    When I send an email template from a custom module, the To section is showing the Subject instead of the recipient email. When I click on it it still shows the email and sends, but it confuses people using it. Anyone know why this is showing this way?
                                                                                                  • NodeJS version for CRM custom functions

                                                                                                    It's been possible to write custom CRM functions in JavaScript: The NodeJS version seems to be quite old, according to the scripting functions docs though: The NodeJS editor uses the NodeJS 8.11. Is that version correctly documented? That is obviously
                                                                                                  • Zia Suggestions Bug

                                                                                                    Please fix this issue it's annoying (check video attached).
                                                                                                  • The email address you have entered belongs to a different deployment/region.

                                                                                                    Hi, I am trying to create the user - mprust@crombiecomputers.co.uk but keep getting the message below -  The email address you have entered belongs to a different deployment/region. Please contact support@zohoaccounts.com for assistance. Look forward
                                                                                                  • Update quote information without having to edit or force an edit function

                                                                                                    Hopefully I can explain this correctly!! Our quotes are created in a 3rd party system and then integrated into Zoho CRM Quotes module via the API. In Zoho quote I have some formula fields such as discount % and some aggregate fields for sub total and
                                                                                                  • Introducing Screen Share with Audio

                                                                                                    Share your entire screen or just the chrome tab with audio for more engaging presentations. Your audience will hear sound just like you do, whether it's a video, demo or any other content. This is ideal for training sessions, team meetings, and client
                                                                                                  • Blueprint automatic transition based on a field in the module

                                                                                                    I've made a Blueprint for sales orders. At some point, we have to ask a subcontractor to contact the customer to agree on an inspection date. If the desired delivery date is less than 21 days from today (Urgent), we want to sent the subcontractor an automatic
                                                                                                  • Zoho People in Nederland?

                                                                                                    Goedemiddag allen, Zijn er bedrijven in Nederland die naar tevredenheid gebruik maken van Zoho People? Wij zitten in de transitie naar Zoho One en vanuit de 'beste of suite' gedachte zou Zoho People dan ook een mogelijkheid zijn voor de HR administratie.
                                                                                                  • Access extensions while performing task blueprint transition - Zoho Projects iOS app update

                                                                                                    Hello, everyone! In the recent iOS version of the Zoho Projects app update, we have brought in support to access the extensions while performing the blueprint transition on the tasks. Please update the app directly from the App Store or using the link
                                                                                                  • 2nd and 3rd Email in Workflow fails to send

                                                                                                    I'm having trouble sending a 2nd and 3rd email in a Workflow. Here's a screenshot of the workflow. Again...like the last topic I posted...it's VERY SIMPLE and it still will not work. This is incredibly frustrating.
                                                                                                  • How to Perform Global Search

                                                                                                    Hi everyone, I am working on an integration project using the Zoho CRM JavaScript SDK. I’ve implemented functionality to create and open entity records, but I am stuck on a specific requirement: I need to implement a global search feature where given
                                                                                                  • Subscription warning makes no sense -- no response from support so far...

                                                                                                    I have a warning message on my Mail that reads: "Your Zoho Mail Subscription has expired and your account will be suspended on Nov 23, 2024. Renew immediately to continue services." I can see the invoice was paid on Nov 23rd and I'm confused as to why
                                                                                                  • Zoho Mail

                                                                                                    My domain and email hosting is Ionos, I'd like to switch to ZOHO, I purchased 1 user to do the test, I don't know how to set up. I have the following issue: 1. I tried to only transfer 1 mail account to test, once I set up as the suggestion, all other
                                                                                                  • Option to start the whatsapp conversation with a lead or deal from within crm

                                                                                                    Currently in zoho crm there is no option to start a conversation with a lead. However we can send templates to contacts or leads in Zoho CRM through approved templates using workflows. But Users are not permitted to initiate conversations with leads or
                                                                                                  • Error while setting up IMAP configuration

                                                                                                    Hi. We're getting the following error when we try to set up the IMAP configuration. How can we solve this problem?
                                                                                                  • Identify if fields used in function

                                                                                                    We're doing a lot of tidy up on our Zoho CRM modules but have 100s of functions. We need a way of identifying if these fields are used in any functions before deleting them. Is there a way to do this? Is there a way to search Deluge scripts on mass for
                                                                                                  • Export blueprint as a high-resolution PDF or image file

                                                                                                    This would be a good feature for organizations that want to share the blueprint process with their employees but don't want them to have access to the blueprint in the system settings. At the moment all that users can do is screenshot the blueprint or
                                                                                                  • Next Page