Creator Subform to CRM Subform

Creator Subform to CRM Subform

Hello all,

Has anyone successfully written data from a Creator Subform into CRM subform? I have been able to get the rows to populate but none of the data will come through. I'll add my code and the result in CRM.   Creator Subform is 'Delivery_Receiving_Hours'. The 3 fields inside it are: Day (Dropdown), Time_Open (Time), and Time_Close (Time). I need this information to go to the CRM subform called 'Hours_of_Operation' The columns in that subform are Days(s) (Multi-Select), Open (pick list), and Close (pick list).  When I check the Report that shows submitted entries, all of the info is there. I can't seem to figure out how to get it in the CRM Subform. 
UPDATE: The problem seems to be that when I try to get the data from the Creator Subform it's pulling null values. Which is weird because I entered values. And if I go into the reports I can see those values. Any help would be greatly appreicated.

  1. //Write to CRM Hours of Op Subform in Locations
  2. subformRecords = List();
  3. // Use the correct subform link name: Site_Operating_Hours
  4. for each operatingHour in input.Site_Operating_Hours 
  5. {
  6.     itemData = Map();

  7.     // a. Convert Creator 'Day' (Dropdown) to CRM 'Days_s' (Multi-Select) format.
  8.     crmDays = List();
  9.     crmDays.add(operatingHour.Op_Day);
  10.     itemData.put("Days_s", crmDays);

  11.     // b. Adjust Time_Open and Time_Close to the nearest hour
  12.     openTime = operatingHour.Op_Open;
  13.     closeTime = operatingHour.Op_Closed;


  14.     // Round up Time_Open to the next hour if minutes are present
  15.     openMinutes = openTime.getMinutes();
  16.     if (openMinutes > 0)
  17.     {
  18.         openHour = openTime.getHour() + 1;
  19.         openTimeString = openHour.toString() + ":00";
  20.     }
  21.     else
  22.     {
  23.         openTimeString = openTime.toString("HH:mm");
  24.     }

  25.     // Round down Time_Close to the previous hour if minutes are present
  26.     closeMinutes = closeTime.getMinutes();
  27.     if (closeMinutes > 0)
  28.     {
  29.         closeHour = closeTime.getHour();
  30.         closeTimeString = closeHour.toString() + ":00";
  31.     }
  32.     else
  33.     {
  34.         closeTimeString = closeTime.toString("HH:mm");
  35.     }

  36.     // Trim whitespace from time strings
  37.     openTimeString = openTimeString.trim();
  38.     closeTimeString = closeTimeString.trim();

  39.     info "Processed Open Time String: " + openTimeString; // Debug
  40.     info "Processed Close Time String: " + closeTimeString; // Debug

  41.     // Ensure two-digit format for hours AND handle potential null values
  42.     if (openTimeString != null && openTimeString.length() < 5)
  43.     {
  44.         openTimeString = "0" + openTimeString;
  45.     }
  46.     else if (openTimeString == null)
  47.     {
  48.         openTimeString = "00:00"; // Default value if null
  49.     }

  50.     if (closeTimeString != null && closeTimeString.length() < 5)
  51.     {
  52.         closeTimeString = "0" + closeTimeString;
  53.     }
  54.     else if (closeTimeString == null)
  55.     {
  56.         closeTimeString = "00:00"; // Default value if null
  57.     }

  58.     itemData.put("Open", openTimeString); 
  59.     itemData.put("Close", closeTimeString);

  60.     subformRecords.add(itemData);
  61. }
  62. newLocation.put("Hours_of_Operation", subformRecords);

    Zoho Desk Resources

    • Desk Community Learning Series


    • Digest


    • Functions


    • Meetups


    • Kbase


    • Resources


    • Glossary


    • Desk Marketplace


    • MVP Corner


    • Word of the Day


      • Sticky Posts

      • Share your success story

        We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. Charles
      • Merge and Store v1 API depreciation

        Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operation
      • Zoho Creator Developer's Conference 2017 !!!

        We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders.       Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from around

      Zoho CRM Plus Resources

        Zoho Books Resources


          Zoho Subscriptions Resources

            Zoho Projects Resources


              Zoho Sprints Resources


                Zoho Orchestly Resources


                  Zoho Creator Resources


                    Zoho WorkDrive Resources



                      Zoho Campaigns Resources

                        Zoho CRM Resources

                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner




                          Zoho Writer Writer

                          Get Started. Write Away!

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

                            Zoho CRM コンテンツ






                              ご検討中の方

                                • Recent Topics

                                • Getting email status through api

                                  Refer to code below for getitng status of mail sent through CRM any modules. You can get the subject as a key in each response, so if you want to filter a specific email you just put an if condition for that. Note that the status will be given as a JSON
                                • Présentation d'une nouvelle fonctionnalité de webinar à la demande

                                  De nos jours, les gens s'attendent à un accès instantané aux informations et aux ressources, qu'il s'agisse de divertissement en continu ou d'apprentissage en ligne. Conscients de cette évolution, nous sommes ravis de vous présenter une nouvelle fonctionnalité
                                • An accurate email totals report

                                  DOes anyone know how to create an email totals report that actually works? I am running the outlook integration and if I count the actual total number of emails that I sent last month, it is ten times higher than what zoho reports.
                                • Settings - Time Display 12-hour vs 24-hour

                                  Hi All This is probably a question for developers as it only seems to be an issued on applications published from Developer account to client accounts. Usually a client would update how they want to view their time (12-hour vs 24-hour) in the Settings
                                • AMP HTML in Email Templates on Zoho CRM?

                                  Hello Team! Is it possible to add AMP HTML features to the email tempalte in Zoho CRM? Im using an external service to create tempaltes and they provide me with AMP HTML features, or dynamic HTML modules. But when I try to add them to the Email template
                                • Error : Bin Locations Provided are not valid

                                  1. We just moved our data from the US to Indian Data Center 2. Now, in one of my organisations, I am unable to save invoices or purchase bills for items and it shows an error 3. Irony is, we dont' even use Zoho Inventory. Operations are completely on
                                • [FREE LIVE WEBINAR] Maximize the impact of your marketing campaigns using a centralized Brand Studio

                                  Hey everyone, We're introducing a free live webinar on Zoho Marketing Plus entitled Maximize the impact of your marketing campaigns using a centralized Brand Studio. The main agenda of the webinar is to give you a complete overview of how Zoho Marketing
                                • Trouble Creating Basic Chart for Accounts - past 6 months

                                  We run a sports performance gym, and I want to create a chart to track member growth, by month, over the last 6 months or so. We group members under the Accounts module (e.g. a family of 4 contacts has 1 billing account). Accounts are termed "Active"
                                • Possible to pause/control the data refresh schedule for data visualisation triggered from custom button?

                                  In a module record view, I have created a custom button action to show a data table view from Zoho Analytics, using https://help.zoho.com/portal/en/kb/crm/customize-crm-account/custom-links-and-buttons/articles/custom-buttons. I noticed that the view
                                • Sorting a list of record acquired from the zoho.crm.searchRecords function.

                                  This is something for which I'm trying to figure out a straightforward way to do. The searchRecords does a great job fetching me the records that I want. However, in some cases, where it returns multiple records, I want it to sort the returned list by date of creation of that record, so that when I do records.get(0), I get the most recent record.  As an example, here's my sample pseudo code: records = zoho.crm.searchRecords("Clients", "Office_Number:equals:123456"); Now the "records" list above contains
                                • Creating cadences Unable to save

                                  Hi, I'm creating a cadence for sales based on the leads module I have email templates in a folder "sales Cadence emails" when I add follow up 1 I select the email address of the user the cadence is for but it won't save....why not? Moderation Update (2nd
                                • Tab order for custom phone fields.

                                  Our Lead records utilize multiple custom phone fields, appearing in multiple sections. The tab order has been configured from top to bottom for each section. When users create a new record, or edit one in a way that makes a custom phone field appear for
                                • Sales IQ needs to capture both first and last names

                                  Sales IQ chat only has one field for name. When this then syncs with Campaigns, the field populates the "last name" field in Campaigns. However most people fill in the "name" field of Sales IQ with either their full name or their Christian name. This
                                • Export PDF from Zoho Books via API

                                  Hi, I'm trying to export a PDF of all the invoices from a customer in Zoho Books via API. I'm doing it this way: $url = 'https://books.zoho.com/api/v3/invoices/pdf?'; $token = "xxxxxxxxxxxxxxxxxxxxx"; $org_ID = "xxxxxxxx"; $invoice_ids = "6289710000XXXXXXXX,62897100000YYYYYYY"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url . 'authtoken=' . $token . '&organization_id=' . $org_ID . '&invoice_ids=' . $invoice_ids); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER,
                                • is there a way to tag the form rule? so that the email workflow can be sent through zoho begin for that perticular response?

                                  I have a form rule; based on which the response like a program to be sent via begin workflow. How do i do that?
                                • Zoho Writer page break in a merge repeating region always adds an unwanted blank page

                                  Hi I'm merging a Zoho CRM record to a Zoho Writer document with a repeating region to display subform records on their own page within the document. When I try to insert a page break in a repeating region, the resulting merge always adds an unwanted blank
                                • Introducing bot filtering for accurate analytics

                                  Dear Zoho Campaigns Users, We're happy to introduce bot filtering to enhance the accuracy of your email campaign analytics. This new feature is designed to help you filter out bot-generated opens and clicks, which will ensure your campaign reports reflect
                                • Zoho Mail POP & IMAP Server Details

                                  Hello all! We have been receiving a number of requests regarding the errors while configuring or using Zoho Mail account in POP/ IMAP clients. The server details vary based on your account type and the Datacenter in which your account is setup. Ensure
                                • Company domain with Zoho Mail as support email in Zoho Desk

                                  Hello, We are a Zoho One customer. We just converted to Zoho Mail from Google Workspace Mail yesterday. We have a domain name for our company. With Gmail, we were able to forward our info@company.com email to Zoho Desk. Customer would then be able to
                                • Best way to organize Zoho Desk with CRM products

                                  I'm having a bit of trouble finding out how I'm supposed to organize our Zoho Desk (departments vs teams vs products) and how to use it. We want to use the KnowledgeBase, Community, and Tickets sections. Here's a general overview of our company to get
                                • Settings Icon No Longer in ZOHO Desk?

                                  In ZOHO desk, there has been a gear icon for settings. as of yesterday, it is no longer there. I showed up briefly this morning but is gone again.  Anybody else experiecing this? 
                                • Emoji Support in Bigin CRM

                                  We request the implementation of emoji support across Bigin CRM. This feature should allow users to seamlessly use emojis in text fields, headlines, and deals. It would enhance communication, improve the visual appeal of records, and bring more personalization
                                • Does Zoho Learn integrate with Zoho Connect,People,Workdrive,Project,Desk?

                                  Can we propose Zoho LEarn as a centralised Knowledge Portal tool that can get synched with the other Zoho products and serve as a central Knowledge repository?
                                • Workdrive API Get list of Sub Folders not working

                                  Hello Workdrive API "et list of Sub Folders" not working. Can you please check this. https://workdrive.zoho.com/apidocs/v1/teamfolder/getteamfolderfolders
                                • is there a way to add tag in the "form rule" so that the email workflow can be automated through zoho begin for that perticular response?

                                  I have a form rule; based on which the response like a program to be sent via begin workflow. How do i do that?
                                • Email address with + char is incorrectly invalid

                                  cannot enter contact with email address containing +, i. e. valid+email@example.com. this is a perfectly valid email address by but fails Zoho Campaigns validation. https://en.wikipedia.org/wiki/Email_address#Local-part
                                • Update Regarding Zoho Finance Applications' Domains For API Users

                                  Hi users, Until now, both the Zoho Finance apps and their APIs shared a common domain. We've recently introduced separate domains for APIs. You can now start using the new domains for API calls. The old domains will not work for API users starting April
                                • Zia powered by GPT is already available for MExico?

                                  Hi there! Is Zia powered by GPT is already available for MExico? I have Zoho ONE membership is Zia powered by GPT compatible with my membership? What's the specs? Do I have to get Chat GPT Plus plan? Thanks!
                                • Adding a Download field to a form

                                  I want to set up a form on my website so that people can download a pdf file once they have submitted their email details. It has been really easy to set up the template but I cannot locate a field with the function. I can see file upload, but not download. This is the main task I want to add to my website as part of the "sales funnel" so hope there is the option.
                                • Campaign Edit - Vertical Align Text to Center

                                  I have a layout in one of my campaigns that is using the split box with a picture on the left and text on the right. I can't find where I can vertically align the content of these boxes. It's forcing my text to be at the top vs centered. Am I missing
                                • Introducing Dark Mode / Light Mode : A New Look For Your CRM

                                  Hello Users, We are excited to announce a highly anticipated feature - the launch of Day, Night and Auto Mode implementation in Zoho CRM's NextGen user interface! This feature is designed to provide a visually appealing and comfortable experience for
                                • is it possible to pull the landing page and email campaign from Zoho app to Zoho marketing? Can I get all the benefits that exclusive app that offers in ZMA?

                                  There is a exclusive Zoho apps for landing page design, email campaign, and same features are there within ZMA as well for to setup landing page and email campaign. can ZMA offer all or limited features of those apps? I request please provide demo and
                                • Enable 2FA / MFA in Bigin

                                  Hi, Our company started using Bigin. I (sysadmin) want to require MFA for Bigin as some users also have integrated their calender and mailbox into Bigin and regardless of that, in general, MFA logins are preferred in our company as it strengthens our
                                • Forwarding Zoho Desk Support Email to a different e- mail

                                  Hello, I am using ZohoDesk and I have a Zoho Desk Support e-mail setup. I would like to know if there is a way to forward the e- mail inbound to this Zoho Desk Support e- mail to a different e- mail?  Thanks!
                                • We are being overbilled by Zoho and they refuse to correct it

                                  We are being overbilled for CRM Ultimate Add-on. Zoho has acknowledged that they know this, but refuses to address and issue billing credits for the amounts we have been overpaying. Our company has been downsizing (unfortunately) and in the past 3 months
                                • is there a better way to routinely export my project timesheets?

                                  Hi there, I am somewhat happy with how Zoho books handles time.  One thing that is missing is more user driven control over my data.  I have a workflow where I constantly need to give customers feeds of work done.  So I pick a project, and would ideally
                                • Does the ability exist to make tax on the customer profile mandatory?

                                  I am reaching out to inquire about the possibility of making the "Customer Tax" field mandatory when creating a new customer in Zoho. We want to ensure that all customers have their tax information recorded to maintain compliance with our internal processes.
                                • Triggering rules on lead conversion

                                  There is no field on the Rule list for rule conversion to trigger an alert on liead conversion to a potential. I assigned a rule to file on any creation or update of a lead. The lead was changed a lead to a potential but no rule was fired. Rajesh Bhadra
                                • How do you remove a user from SalesIQ?

                                  I have a user in Sales IQ who needs to be removed (she's no longer involved with sales and chat) but I can't find any way to remove her. How do I do that?
                                • Integrate SalesIQ with tiendanube.com

                                  Tiendanube.com is the leading e-commerce platform designed to help businesses create and manage online stores. It provides tools for entrepreneurs and companies to set up, customize, and operate their online shops with ease. Tiendanube is particularly
                                • Next Page