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 コンテンツ






                              ご検討中の方