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
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Fadi Hani
Karthick L
New to Zoho TeamInbox?
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
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Change/reallocate different key combinations to enable the Zia Search feature in Zoho Projects
Hello, Typically the cmd + "/" or Ctrl + "/" keys combination is used for commenting a code line. However, in the custom function module in Zoho Projects (specifically), the key combinations triggers Zia Search widget which distracts during coding andLive webinar: 2024 recap of Zoho WorkDrive
Hello everyone, We’re excited to invite you to our year-end live webinar! This session will take you through the transformative features and updates we’ve introduced in Zoho WorkDrive this year, helping you streamline document management like never before.Streamline appointment booking for patients | Kiosk Studio Session #3
Hello everyone! You may be using kiosks today to help your CRM users streamline their workflows and enhance efficiency. These users could be sales reps in a manufacturing company, agents in a real estate firm, clerks in a government agency, and so on.Function #46: Auto generate list of lapsed customers using Custom Button
Hello everyone, and welcome back to our series! Customer retention is one of the key factors that impact the long-term success and sustainability of a business. High customer retention rates indicate satisfied customers, quality products or services,Help Needed to Recover Emails After Deactivating Zoho Account
Hello Zoho Community, We deactivated our Zoho account two days ago but unfortunately did not properly transfer our email services before doing so. As a result, we’ve lost access to our Zoho emails and data. Is there any way to reactivate our Zoho accountAutomatically update date field based on the pick-list value of another field
Hello everyone, I've been trying to find a way where a date field gets automatically updated according to the value of a different pick-list field. The pick-list field can have the value "3 months from now" or "6 months from now". The logic is that weHow to use an output from a function as a criteria on a decision path on Kiosk
Dear community, Is it possible to use the result of a function executed in a Kiosk flow as a criteria in a decision step in Kiosk studio? Let's supose I have a function that makes an API request. Is it possible to define the next step of the Kiosk flowCreator - Programmatic Update not Triggering Flow
I have a Flow set up to be triggered by a Record Updated action in Zoho Creator. When I update the record manually via the UI, everything works as expected. However, I have a workflow that can be triggered in the UI to update a specific field in the CreatorKaizen #89 - Color Coding using Client Script
Hello everyone! Welcome back to another exciting Kaizen post. Today let us see how you can apply color codes to the List and Detail Pages of Zoho CRM using Client Script. Need for color code in Zoho CRM When you mark things with different colors as aUnattended Access session confirmation exclusion list suddenly not working
As of Friday, the session confirmation exclusion list is not being respected. Instead all remote sessions are prompting for confirmation, including those in the exclusion list. For some of our critical shared machines this is a significant issue as theConnecting Zoho Creator app with Zoho Sites
I created a custom domain on Zoho Creator for my app (and it is verified), but when I click the link for my custom domain, it redirects me to my website. I want to link my portal to my website so that customers don't have to sign in to multiple locations.Add a way of clearing fields values in Flow actions
It would be great if there was an option to set a field as Null when creating flows. I had an instance today where I just wanted to clear a long integer field in the CRM based on an action in Projects but I had to write a custom function. It would beFeature Request: Export\Import Flows
Hi, As A Zoho Systems Builder and implementer, I Like Working With this great tool! Makes my automation work a lot Easier! Thanks! It would Save me a lot of time if I would be able to export And import flows (To JSON).Teaminbox whatsapp integration not working since saturday
Hi, I dropped an email to support@zohoone.com and a web form. But I didn't get any responses. I checked the whatsapp link via the setup > Organization > Organization > Channels, and checked the whatsapp accounts in facebook business portfolio, it's allHow do I list all users and their email addresses within an application?
The application I created is a system where by users submit issues. An admin will then assign the issue to a particular user (not necessarily the one who submitted it). Obviously I need to create the users in the Setting page and allow them access to the parts of the app that are relevant to them. My question is this: Is it possible to create on a form a dropdown box that will show the available users or do I need to create the user a second time within a table (ie. Name, Email, etc...)?Springlearns: How Can Zoho CRM Help Streamline Our Training Program Management and Client Engagement?
Hi Zoho CRM Community, We are a provider of professional training solutions, and are looking to improve our client relationship management and streamline our training program operations. As we expand our offerings in project management, IT certifications,Switch to enable or disable sent notification when close a ticket
Some time you need to turn off the notification email on closing a ticket. But the only way is in the Settings of Zoho Desk. It would be great to have a switch in the ticket just to disbale for once the notification mail when close the ticket.Sync Zoho Desk Teams with Zoho One Departments and/or Groups
Dear Zoho Team, Greetings! We would like to request an enhancement to improve the integration between Zoho Desk and Zoho One. Currently, when creating or updating an employee in Zoho One, we can add them to the Zoho Desk application and configure theirReport to show tickets win non invoiced time entries.
I have a report that lists tickets and associtated time entries for a specified period of time. Is there a filter that can be applied to show only tickets that have time entries that have not been marked as invoiced? Or what is the best way for our billingZoho Desk and Zoho Inventory
I am hoping I am not the only one with this need but has anyone else notice the lack of integration between Zoho Desk and Zoho Inventory and eventual funneling into an Invoice in Zoho Books? As an IT service provider we very often will sell parts (items) along with services for installing said item(s). I have discovered that although you can integrate your Inventory Items into Desk as a "Product", it serves no real functionality. In fact, I found the concept confusing compared to how many ServiceAccess custom view for Boards module - Qntrl Android app update
Hello, everyone! In the latest Android version(v3.0.8) of the Qntrl app, we have brought in support to access the custom views for the Boards module. You can also mark a view as favourite by tapping the star icon next to the view name. The views thatUpdate Comment Field via Macro
Is there a way to update the comments in a ticket, via a macro? I see how to update the resolution via macro, but I cannot see a way to update the comments. Am I missing something?Two Accounts on a deal
I have Reseller accounts that generally Purchase and End-user accounts that I need to track. When I lookup a Deal, I need to see both - easy enough. When I lookup one account or the other, I need to see the deal, but I can only see it in one. How do IAuto-assign ticket to the agent who closes the ticket
Hello Everyone! Here we are again, introducing a custom action to help you track tickets more efficiently and optimize your business operations. Imagine managing hundreds of tickets related to banking activities, similar to Zylker Bank. How do you ensureJiraa to Zoho Projects
I am integrating Jira tasks into Zoho Projects using Zoho Flow, but I need to translate the Jira task names into English during the integration process. I attempted to use Google Sheets as an intermediary, by applying the Google Translate formula, butCreate Report/Query table from multiple Databases
Is it possible to create a Report/Query table from multiple databases? example: SELECT "Date", "Time" FROM dbo.database1.thisTable INNER JOIN dbo.database2.thatTable ON dbo.database1.thisTable.date = dbo.database1.thatTable.dateTax Updates Revert on Zoho CRM Invoices After Running Custom Function
Hi everyone, I'm running into an issue with Zoho CRM that I hope someone here can help me troubleshoot. I've created a custom function to update the tax amount on invoices in Zoho CRM. Initially, the function runs successfully and updates the tax fieldNo duplicates in lookup field
I have a lookup field that is based on items from a material report. The problem is, there are a lot of duplicate material names for the particular field that it's based on. Is there any way to limit it to only show one of each item?Lookup field based on another lookup field
So I have a material entry form with a lookup field to an unrelated form in it. I have another form with a lookup field that shows records from the material entry form. The issue is, I want to set the the lookup field in the second form to be based onSubform Client Script
Good day, I have a subform where users can subscribe to various magazines. I would like to prevent the user from selecting the same magazine twice when adding a new row. Is there a way to prevent the user from doing this? (Can it be done via a clientHow to send emails from a ticket via deluge script
We are planning to send an email from a ticket via deluge script how can we do that?Using Snippets in Comments
One of our Agents asked about using snippets in comments. We don't see this as an option at this time, only in reply mode. Is there a way to enable this?Introducing 'Queries' In Zoho CRM
Hello everyone! We are here with an exciting feature - Queries in Zoho CRM! A little context before we dive right into the feature specifics :) In today’s fast-paced business environment, immediate access to relevant data is essential for informed decision-making.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. StreamlineExport 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 opportunitiesZoho 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 tryingNext Page