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 subfield called 'Hours_of_Operation' The columns in that subform are Days(s) (Multi-Select), Open (pick list), and Close (pick list).  I also can't figure out how to get the API for the CRM Subform fields. Any help with that would appreciated too. 
  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

                                • Como gerar gatilhos para pagamento de impostos no Zoho Books?

                                  Olá Pessoal, boa tarde! Gostaria de saber como vocês estão escriturando os impostos a pagar no Zoho Books. Vi que temos a opção de Bills, porém se eu escriturar nesta aba do Zoho Books para gerar lembretes de tempo de vencimento por exemplo vai refletir
                                • Editor limitations to define screen types

                                  Guys I have noticed that even in version 2.0 of the editor (which is this new one we use) we still have a lot to improve... When I compare to some more global solutions like Wix, Zyro, Go Daddy, Squarespace and Weebly feel that we have some limitations
                                • Dúvidas do Zoho Creator

                                  Pessoal, Estou colocando um tópico para dúvidas do Zoho Creator. Um abraço, Leandro
                                • Tropicalize Books

                                  Books is an incredibly powerful tool that works well in many countries. But I feel that it is a product that is not yet "tropicalized" for Brazil as we speak (this would be like adapting the local reality). We have many strong competitors who do more
                                • Automatic Sitemap Generation

                                  Guys are all right? Doesn't make sense for me to have to generate a map site and upload it... because it's not automatically generated just as it is done in WIX? where the customer doesn’t have to worry about this.
                                • SEO improvements with ZIA

                                  Are you okay? I would like to bring an idea that would be amazing to improve the product that is the possibility of being able to improve the SEO of the pages (this of each page or each article on the blog) through ZIA so that it could create page Summary
                                • Automatically updating field(s) of lookup module

                                  I have a lookup field, which also pulls through the Status field from the linked record. When the lookup is first done, the Status is pulled through - this works perfectly. If that Status is later updated, the lookup field does not update as well. As
                                • Initiating a SalesIQ Zobot from a custom button on Zoho Sites

                                  I have created a Zobot set to initiate on a custom action called "Fast_Answers". On Zoho Sites, I created a code snippet button and set it to on-click run the event called "Fast_Answers". I installed the SalesIQ integration code into the Zoho Sites Page
                                • Zoho Desk -> Zoho Analytics : Where is the field for "Layout" ?

                                  I have many different layouts on my helpdesks and I want to be able to identify the stats for each one, however I can not file the field in the raw data from the Zoho Desk datasource. I thought it might be under "Tickets" but there is nothing. There is
                                • Set resolution mandatory field

                                  Hi,  i have 2 questions:) : - i want to set the resolution field mandatory before close the ticket. Because for now, i can close the ticket without writing how i solve it - how can i setup zoho desk to receive ticket by email(e.g. clients sent email to support@mydomain.com) and it create a ticket in zoho desk
                                • Impuesto automatico en cotizaciones

                                  Buen dia Mi pregunta es como se puede poner alguna operacion para que las cotizaciones me salgan automaticamente con impuestos ya que uno al cargarla al final tienen que añadir el porcentaje de impuesto Saludos
                                • Zoho Assist "Agree and Download" Button "Greyed Out" ("Light Blued" Out)

                                  Anyone else having issue where support clients are unable to click "Agree and Download" to access the client so that we can provide remote support? This is for "on demand" support via accessing the support page and entering the support key and name. This
                                • Project Billing with the Staff Hours Method in Zoho Projects

                                  The Staff Hours Billing Method in Zoho Projects allows you to bill your clients based on the actual time spent by each team member on a project, at the rate set for each user. This is useful for projects where different skill sets are needed and service
                                • 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'.
                                • custom fields not populating from deluge script into invoice

                                  Hello, I've created some Deluge script that is meant to take a few inputted invoice custom fields and calculate a few others. I can see when I execute the function that my inputted custom fields are being passed, yet im still ending up with all "null"
                                • tax summation function - getting error

                                  Hello, I'm trying to create a function that adds all of individual tax rates from a few jurisdictions. I'm getting an error on line 9 - Value is empty and 'get' function cannot be applied. I've checked that I have data in each of the required fields,
                                • Backstage / Zoho Books integration

                                  Hello. We have Zoho One and have slowly started using Backstage. Loving it. Problem is, we have ZERO accounting control over what is sold through this product. When will we be able to connect it to our existing Zoho Books tenant? Thank you very much!
                                • Getting list of calendar events over api for zoho mail calendar

                                  Hi, I am using just Zoho mail without using Zoho CRM. I wanted to get all events booked in my zoho mail calendar through an api at regular intervals. I could find such API support for Zoho CRM calendar but not for zoho mail calendar. Can you kindly let
                                • Allocate emails to user in a shared mailbox

                                  Hi, This might be obvious, but I cannot find the answer. I have 3 shared mailboxes so any team member can see the emails. Is there a way of allocating a specific email to a user so that it is their responsibility to deal with it? Thanks in advance.
                                • Introducing Zoho Campaigns' own gateway for SMS campaigns

                                  We are excited to announce the launch of our SMS Gateway to send SMS through Zoho Campaigns. We have also made a few other changes in our current SMS Campaign model to improve your over all user experience. These updates are planned with an aim to expand
                                • Update a lookup field in CRM from Creator using deluge

                                  I have a Creator form that creates a new account. When it creates the new account in the Accounts Module, I need it to also populate the Parent Account, which is a lookup field coming from the Module Parent Accounts, field Parent Account Name. I have
                                • SMS Keyword Tracking in Zoho CRM From Zoho Campaigns

                                  Is there a way to track SMS leads in campaigns by associating them with specific keywords or codes? Additionally, can these leads be pushed to the CRM while retaining the keyword for tracking and reporting purposes?
                                • Projects Multiselect API

                                  Having troubles setting a mutli select field via API. updateMap = map(); updateMap.put("UDF_MULTI1","picklist_id1,picklist_id2"); updateProjectRes = invokeurl [ url :"https://projects.zoho.com/restapi/portal/XXXX/projects/" + projectID + "/" type :POST
                                • Bill quantity received / PO quantity

                                  PO's are raised & often the quantity received is greater than the PO quantity, so when we receive the bill & adjust the quantity on the bill we get.... Quantity recorded cannot be more than quantity ordered. This necessitates the adjustment of the PO
                                • ZOHO BOOKS - RECEIVING MORE ITEMS THAN ORDERED

                                  Hello, When trying to enter a vendor's bill that contains items with bigger quantity than ordered in the PO (it happens quite often) - The system would not let us save the bill and show this error: "Quantity recorded cannot be more than quantity ordered." 
                                • Adding Bluesky channel

                                  Hello, Is Bluesky (AT protocol) soon added on Social ? Bluesky is being developped and is now open to anyone (no more invitation) Thank you
                                • Work Orders / Bundle Requests

                                  Zoho Inventory needs a work order / bundle request system. This record would be analogous to a purchase order in the purchasing workflow or a sales order in the sales cycle. It would be non-journaling, but it would reserve the appropriate inventory of
                                • Using Queries with dynamic parameters in Kiosk Studio

                                  Hi, I'm pretty new when it comes to developing within Zoho (I'm really a .NET developer), as it was just added to my responsibilities. For a new feature in the CRM, I'm trying to develop a Kiosk function to show a list of records (retrieved by the new
                                • Unused items should not count into the available number of custom fields

                                  Hey, I realized that unused Items reduce the number of available custom fields. I can't see a case where that makes sense. Especially in our case where we have two different layouts in Deals with a lot of different fields, this causes problems.
                                • Introducing Bot Filtering for Accurate Email Campaign Analytics

                                  Dear Marketers, We're excited to announce a new feature designed to enhance the accuracy of your email campaign analytics: bot filtering. This feature helps you filter out bot-generated opens and clicks, ensuring your campaign reports reflect genuine
                                • Tip 37: Time Log Restriction in Zoho Projects

                                  Timesheet in Zoho Projects helps you big time in entering log hours for the tasks and issues and approving them. Now, with the new Time Log Restriction option, you can set daily and weekly log hour limits. You can restrict users from entering extra log hours than the permissible limit. The limits are restricted to 24 hours per day and 168 hours per week by default based on business hours. To customize, navigate to Task & Timesheet settings under Portal Configuration in Zoho Projects setup and enable
                                • Chart showing schedule

                                  I want to be able to create a chart for everyday to check and which of which driver is available on the timeframe. Here's my table Name City Day Start Time End Time Driver1 Medicine Hat Monday 11:45 AM 4:45 PM Driver 2 Medicine Hat Tuesday 11:00 AM 7:00
                                • Multiple Vendor SKUs

                                  One of the big concerns we have with ZOHO Inventory is lack of Vendor Skus like many other inventory software packages offer. Being able to have multiple vendor skus for the same product would be HUGE! It would populate the appropriate vendor Sku for
                                • In Zoho Projects, is there a way to create a folders template under documents that can be used once a project is created?

                                  We have a specific folder structure that we would like to use that is standard across every project. Instead of having to create this structure every time a project is created, is there a way to create a template for the folders that can be added?
                                • Workflows for Timesheet

                                  Good day, Any way to have timesheet as triggers? I looked into Zoho Flow and into Zoho Project automation but no where can I have timesheet as a trigger. Basically, I would like to trigger something upon timesheet approval. Right now, the only way to
                                • Zoho Payroll in France

                                  When will Zoho Payroll be available in France ?
                                • Blueprint - 'On hold' state with an automatic transition?

                                  I think I'm missing something here so I'm hoping if I explain what I'm trying to achieve someone might be able to give me a way around it. We sometimes get request far in advance but we don't want to action them unless it is 7 days from when they are
                                • Zoho One. Client Script

                                  Hi, I would like to know if the Client Script feature is available in Zoho One. If it's, how can I enable it?
                                • HOW TO VIEW INDIVIDUAL COST OF NEWLY PURCHASED GOODS AFTER ALLOCATING LANDED COSTS

                                  Hello, I have been able to allocate landed costs to the purchase cost of the new products. however, what i need to see now is the actual cost price (original cost plus landed cost), of only my newly purchased products to enable me set a selling price
                                • Client Script: $Client.refresh({ triggerOnLoad: true }); not triggering onLoad Client Scripts

                                  Hey friends! I'm trying to store a temporary var, refresh the page for the user, then check that temporary var and do some actions. Theoretically using the title's code: $Client.refresh({ triggerOnLoad: true }); should refresh the page and trigger on
                                • Next Page