Tip 21: How to dynamically auto-populate rows in a subform

Tip 21: How to dynamically auto-populate rows in a subform



Hi folks,

In our last tip we discussed how to autopopulate values in subform rows while clicking on Add New. As promised, in this tip, we'll show you how to dynamically insert rows in the the subform without clicking the Add New button, using our new feature—Insert rows in Subform dynamically.

Let's say you have an application where you have the product name in the Mainform field, and you need to automatically display the price of the product in the subform field based on the choice selected in Mainform field.

The Mainform contains a dropdown field named Shoes, with a list of choices like "Puma" and "Nike." The main form has a subform called SubForm containing a "Currency" field, as shown in the screenshot below.




When a product is selected from the Shoes dropdown field, the Currency field in the subform should be automatically populated with the corresponding value.

To achieve this, we need to write a Deluge script during On User Input of Shoes, as shown in the below steps:

Step 1
Go to Edit this application in the top right corner of your application, click the + to create a new workflow, and select While using the form. You'll see another popup window now.





As shown above, select the form that you need to run the workflow on—in this case it's Mainform—select the option Created, and enter the name for your workflow.

Step 2
Click Add New Action, select Deluge Script, select On User Input, and then select the subform that you want to use.




Step 3
Before you write the script for your workflow, there are few things you need to do to ensure your workflow runs perfectly.
  • Declare a row variable for the respective subform in the main form
  • Assign values to the subform field by using the row variable
  • Declare a collection variable 
  • Insert the row variable into the collection variable
  • Insert the collection to the subform
Now, let's key in the script:


Let's see what we've done here in detail:

  1. if(input.Shoes=="Puma") // The if statement helps you validate the input
  2. {
  3. row1=Mainform.SubForm(); // Declares a row variable, which belongs to the respective subform in a main form
  4. row1.Currency=100.00; // Assign value to the subform field
  5. rows = Collection(); // Declares a collection variable to hold the rows
  6. rows.insert(row1); // Inserts the row variable into the collection variable
  7. input.SubForm.insert(rows); // Inserts the collection in the subform
  8. }
  9. else if (input.Shoes=="Nike")
  10. {
  11. row1=Mainform.SubForm(); // Declares a row variable which belongs to the respective subform in a main form
  12. row1.Currency=200.00; // Assigns a value to a subform field
  13. rows = Collection(); // Declares a collection variable to hold the rows
  14. rows.insert(row1); // Inserts the row variable into the collection variable
  15. input.SubForm.insert(rows); // Inserts the collection to the subform
  16. }
And don't forget to click Save to save your workflow! Click on Access the application to see how this works.

Step 4

Now it's time for the magic. Let's select a shoe we like from the dropdown field.




You can see that when Nike is selected, it now automatically populates a row with its values.

We hope from now on you use this tip whenever you use subforms in your application!  If you have any questions, feel free to ask in the comments below, and we'll be happy to address them soon!





    Access your files securely from anywhere








                            Zoho Developer Community



                                Bootcamp
                                Community
                                Pricing
                                Webinars
                                What's New
                                Integrations
                                Contact Support
                                Contact Sales
                                  Zoho Survey Resources
                                    Features
                                    Survey Templates
                                    Integrations
                                    Community
                                    iOS Mobile Surveys
                                    Pricing
                                    Android Mobile Surveys
                                    Insurvey Blogs
                                    Insight Blogs
                                    Tips & Tricks





                                                Latest Feature Updates

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                  • Ask the Experts




                                                      Zoho SalesIQ Resources


                                                            Manage your brands on social media
                                                            Access Zoho Social

                                                              Zoho Pagesense Resources


                                                                  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 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

                                                                                              Get Started. Write Away!

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

                                                                                                Zoho CRM コンテンツ



                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                              • Recent Topics

                                                                                                              • WhatsApp Report in Bigin CRM

                                                                                                                Reporting feature for Bigin CRM’s integrated WhatsApp that provides insights such as: Number of WhatsApp conversations closed Number of messages sent and received Number of conversations replied to Response and closure metrics for WhatsApp chats More

                                                                                                              • Issue with Azure DevOps Integration in Zoho Flow

                                                                                                                Hello, All workflows between Zoho Flow and Azure DevOps have stopped working for several days now. Upon further investigation, it seems that the connection to Azure DevOps is no longer directly supported. Indeed, Microsoft has deprecated the Azure DevOps

                                                                                                              • Narrative 16: Simplify with workflows

                                                                                                                Behind the scenes of a successful ticketing system: BTS Series Narrative 16: Simplify with workflows What is a workflow? A workflow organizes business tasks in a defined sequence that makes each step clear to all participants. This ensures work is completed

                                                                                                              • Zoho Invoice Customer Login Portal

                                                                                                                Are there any plans for a customer portal to Zoho Invoice, ala Freshbooks?  I would like customers that I invoice to be able to login to review invoices and invoice history.  I have not switched from Freshbooks for this very reason.

                                                                                                              • Random Leads are being created

                                                                                                                Hi, Every few days I am getting random leads that are being created with no form interactions at all. The email addresses are from obvious spam, such as 'Easymerchantsx'. When I look at the timeline, there is a Visit record and then a Lead Created record,

                                                                                                              • Print a price list or price book

                                                                                                                Hi Community. Am I right in concluding that Zoho has no functionality to print a price list from either Zoho CRM, Zoho Inventory or Zoho Books? I won't get stuck on the fact that Zoho doesn't sync price books between Zoho CRM and Books/Inventory (more

                                                                                                              • Bar Chart -- sort X-axis

                                                                                                                Hi! I created a bar chart ("Top 10 Products by Revenue") X-axis: Product Name Y-axis: Revenue Filter: Revenue - Top 10 Here's a picture: http://screencast.com/t/ZTJlZTdkNz The x-axis is sorted alphabetically by Product Name. How can I force it to sort numerically by Revenue?

                                                                                                              • ZoHo Flow Custom Function not Processing JSON

                                                                                                                JSON is being escaped and converting all the quotes in the JSON to '"' Here's the Code: void InsertRowInE123EligibitySheet(map input) { rawData = get("data",""); decodedData = rawData.htmlDecode(); data = decodedData.toMap(); sheet_id = "ID GOES

                                                                                                              • Managing functions

                                                                                                                Can someone let me know if there are any plans to improve the features for managing functions in CRM? I have lots of functions and finding them is hard. The search only works on the function name and the filter only works on function type. I have created

                                                                                                              • Zoho FSM - Service Appointment Trouble Adding Field Agent

                                                                                                                Hello, I just started using Zoho FSM and I'm currently adding older work orders from prior Field Service application I use. The work order that im trying to add is from an earlier date, and when I try to add a field agent to a service appointment it does

                                                                                                              • 年内最後のユーザー向けイベント：5名限定！ 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (12/18)

                                                                                                                ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 12月開催のZoho ワークアウトについてお知らせします。 今回はZoomにて、オンライン開催します。 参加登録はこちら（無料） https://us02web.zoom.us/meeting/register/QHn6kJAcRs-znJ1l5jk0ww ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは？ Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho ワークアウト」を開催します。

                                                                                                              • How do I get my account id?

                                                                                                                Hello, I followed the instructions to get a list of accounts of the currently authenticated user (which is me, and I am logged in). But when I follow the below instructions I get the following error: ERROR: {"data":{"errorCode":"INVALID_TICKET","moreInfo":"Invalid ticket"},"status":{"code":400,"description":"Invalid Input"}} Instructions that I am following: GET - User account details Purpose The API retrieves the list of accounts of the currently authenticated user.  Request URL  http://mail.zoho.com/api/accounts

                                                                                                              • This domain is not allowed to add. Please contact support-as@zohocorp.com for further details

                                                                                                                I am trying to setup the free version of Zoho Mail. When I tried to add my domain, theselfreunion.com I got the error message that is the subject of this Topic. I've read your other community forum topics, and this is NOT a free domain. So what is the

                                                                                                              • Zoho Quartz Screen Recording

                                                                                                                Hello, can we get access to Quartz, please, as a standalone solution? It would be great for creating training videos for current and future staff on how to use Zoho software according to our company requirements. Thank you

                                                                                                              • auto close automated alert tickets which are similar

                                                                                                                Hello ZOHO Community, we are using ZOHO Desk to process automated monitoring alerts. Scenario: Our monitoring system creates a ticket when a threshold is exceeded, e.g. Subject: Computer 1 – CPU usage 100% – Error A few minutes later, once the issue resolves

                                                                                                              • Maintain knowledge base integrity by moderating article comments

                                                                                                                Hello everyone, A knowledge base provides a self-service platform where customers can refer to articles, user manuals, and other resources to learn about the company's products or services and troubleshoot problems. Often, readers leave a comment on the

                                                                                                              • Making another calendar your default calendar

                                                                                                                I am trying to make another calendar my default calendar when I add events to it. It keep going to a single calendar, I need it to go to my google calendar by default, as this is linked to other services / websites. I cannot find an option to make it

                                                                                                              • Option to Delete Chats in IM

                                                                                                                Currently, there is no option to delete any chats in IM, regardless of their source.

                                                                                                              • Referencing a cell from another sheet

                                                                                                                My workbook has multiple sheets. Each sheet has some calcluated totals in certain cells. The front master sheet has a list of everything that is detailed on the other sheets, with the totals. These could change at any time, so the totals need to be references to the other cell's value, not a fixed number. So on the master sheet, I put in =, then go the other sheet and choose the cell and hit Enter. In regular Excel, this works. But in the Zoho sheet, it doesn't work. I have to edit the result by

                                                                                                              • Group mail for external email addresses

                                                                                                                Hello, I was just wondering if the Group mail feature works with external email addresses - e.g. gmail.com or a completely different domain? it seems only internal addresses (hosted with Zoho) receive the mail. Thanks, Oliver

                                                                                                              • 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

                                                                                                              • Use Zoho Flow Credits for CRM ‘Actions by Zoho Flow’

                                                                                                                Hello Team, We would like to submit a feature request regarding credit usage for “Actions by Zoho Flow” in Zoho CRM. Use Case: We are Zoho One users and actively use Zoho Flow, where our organization has 52,000 Flow tasks per month. In Zoho CRM, we use

                                                                                                              • Unusual activity detected from this IP. Please try again after some time.

                                                                                                                Hello Zoho admin and IT team We are a registered website in Eloctronic services and we been trying to add our users to the zoho system but this issue faced us ,, hope you unlocked us please.

                                                                                                              • Alert if a field is ticked.

                                                                                                                Hi There, We have two modules named Opportunities (Deals) and End Users (CustomModule1), as per the image below. Within Opportunities, we have a lookup field that looks up from the End Users Module. We are looking to get an alert either via email or another

                                                                                                              • Zoho CRM Analytics - Allow To Reorder Dashboards

                                                                                                                I would like to suggest that you add the ability to reorder dashboards in the Analytics Module. I can see that this has been requested some time ago, the latest 9 years ago. I am not sure if this is a big or small endeavor, but such a small fix can go

                                                                                                              • Sending a Template to Sign

                                                                                                                hi, trying to send a template to be signed using this as a test: $accessToken = "1000.xxx" $templateId = "1234" $uri = "https://sign.zoho.eu/api/v1/templates/$templateId/createdocument" $payload = @{ templates = @( @{ template_id = $templateId request_name

                                                                                                              • Adding Choices in a Sub-Form Dropdown

                                                                                                                Hi, Has anybody tried Adding Choices to a Dropdown in a Zoho Creator Sub-Form programmatically? My Deluge code adds rows to a subform with 2 fields A and B. A - text field. B - dropdown. My Deluge script adds the row and displays A successfully. For the

                                                                                                              • Zoho CRM Email Templates 100% Width No Background How?

                                                                                                                Hi, On the Zoho CRM Email Templates in setup > customization > templates > new templates > I choose blank template, but still it puts in a gray background and a max width for the email. I just want to make an email that looks like an email I would send from gmail that has no background or max width. How do you do this? 

                                                                                                              • Checking client unsubscribe details

                                                                                                                Hi team, Can you please let me know where we can check if a client has unsubscribed, along with the date and time it was done? If this information is not available at our end, please help confirm the unsubscribe date for the below email ID from the backend:

                                                                                                              • Optimum CRM setup for new B2B business

                                                                                                                Can some advise the most common way to setup Zoho CRM to handle sales for a B2B company? Specifically in how to handle inbound/outbound emails. I have spent hours researching online and can't seem to find an accepted approach, or even a tutorial. I have

                                                                                                              • Scan and Fill CRM Lookup Field

                                                                                                                Not sure if there is a reason why this isn't possible or if I'm just missing it. But I would like to be able to use the scan and fill feature on the mobile app to prefill the CRM lookup field and fetch the rest of the data in the form.

                                                                                                              • Customer Management: #2 Organize Customers to Enhance Efficiency

                                                                                                                When Ankit started his digital services firm, things felt simple. A client would call, ask for a website or a one-time consultation, Ankit would send an invoice, get paid, and move on. "Just one client, one invoice. Easy.", he thought. Fast forward a

                                                                                                              • Zoho Mail and Zoho Flow integration to automatically create ToDo tasks from outbound emails

                                                                                                                How do i setup Zoho Mail and Zoho Flow integration to automatically create ToDo tasks from outbound emails

                                                                                                              • Attachments between Zoho and Clickup, using Flow.

                                                                                                                Olá suporte Flow, tudo bem ? Estamos usando o flow para integrar Zoho Desk com o clickup. Não localizamos a opção de integrar anexos entre do zoho Desk para o clickup. Gostaríamos de saber se migrando para o plano pago, teremos suporte para fazer a integração

                                                                                                              • Adding an Account on Zoho Mail Trigger in Zoho Flow

                                                                                                                I'm trying to create a flow using the zoho mail trigger "Email Receive". My problem is that when I select this trigger, it only shows one account from the account dropdown. I'm planning to assign it on a different email. How can I add other email ad

                                                                                                              • Linnworks

                                                                                                                Unless I am missing something, the Linnworks integration is very basic and limited. I have reached out to support but the first response was completely useless and trying to get a reply in a timely manner is very difficult. Surely I should be able to

                                                                                                              • Test data won't load

                                                                                                                I am using a Flow to receive orders from WooCommerce and add them to a Zoho Creator app. I recently received an order which failed, and when attempting to test the order I found that it just shows a loading animation and shows up in the history as "queued."

                                                                                                              • AddHour resets the time to 00:00:00 before adding the hour.

                                                                                                                Based on the documentation here: https://www.zoho.com/deluge/help/functions/datetime/addhour.html Here's my custom function: string ConvertDateFormat(string inputDate) { // Extract only the date-time part (before the timezone) dateTimePart = inputDate.subString(0,19);

                                                                                                              • WhatsApp Link is not integrating

                                                                                                                Hello, I am using zoho flow. when new row added in google sheet it sends email to respected person. In email body I have a text "Share via WhatsApp". behind this text I putted a link. But when the recipient receives email and wants to share my given info

                                                                                                              • Zoho flow - Webhook

                                                                                                                If I choose an app as a trigger in Zoho Flow, is it still possible to add a webhook later in the same flow?

                                                                                                              • Next Page