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.

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

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

  14.     // b. Adjust Time_Open and Time_Close to the nearest hour
  15.     openTime = operatingHour.Op_Open;
  16.     closeTime = operatingHour.Op_Closed;


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

  31.     // Round down Time_Close to the previous hour if minutes are present
  32.     closeMinutes = closeTime.getMinutes();
  33.     if (closeMinutes > 0)
  34.     {
  35.         closeHour = closeTime.getHour();
  36.         closeTimeString = closeHour.toString() + ":00";
  37.     }
  38.     else
  39.     {
  40.         closeTimeString = closeTime.toString("HH:mm");
  41.     }

  43.     // Trim whitespace from time strings
  44.     openTimeString = openTimeString.trim();
  45.     closeTimeString = closeTimeString.trim();

  47.     info "Processed Open Time String: " + openTimeString; // Debug
  48.     info "Processed Close Time String: " + closeTimeString; // Debug

  50.     // Ensure two-digit format for hours AND handle potential null values
  51.     if (openTimeString != null && openTimeString.length() < 5)
  52.     {
  53.         openTimeString = "0" + openTimeString;
  54.     }
  55.     else if (openTimeString == null)
  56.     {
  57.         openTimeString = "00:00"; // Default value if null
  58.     }

  60.     if (closeTimeString != null && closeTimeString.length() < 5)
  61.     {
  62.         closeTimeString = "0" + closeTimeString;
  63.     }
  64.     else if (closeTimeString == null)
  65.     {
  66.         closeTimeString = "00:00"; // Default value if null
  67.     }

  69.     itemData.put("Open", openTimeString); 
  70.     itemData.put("Close", closeTimeString);

  72.     subformRecords.add(itemData);
  73. }
  74. newLocation.put("Hours_of_Operation", subformRecords);



      • 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