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

        • Recent Topics

        • Marketing 2.0 has been a catastrophe

          Anyone else having significant issues with their link between their CRM and Marketing automation since moving to version 2.0? We had an easy flow for triggering leads in the CRM to journeys in Marketing Automation but now nothing seems to work properly.

        • Cannot average "Duration (Time)" from Pick List History Tracking in Reports

          Okay, let's say I have a custom module. In this custom module I have a pick-list named "Status" with "New", "In-Progress", "Completed" values. I also have turned ON pick-list history tracking and chose "Time" to track the duration in (instead of "Calendar

        • Customer Statement Template

          Hi. how can i add order number "customer LPO number" in the customer statement. regards

        • Authorize.Net Update: Disable Transaction IP Velocity Filter to Avoid Payment Failures

          Update: The Authorize.Net integration was updated on November 20, 2024. To prevent recurring transaction failures, we recommend disabling the Transaction IP Velocity Filter at the earliest. We’re updating the Authorize.Net integration in Zoho Books on

        • Need to send a single email to up to 20 recipients

          I want to send a single email to ~16 or 20 recipients. It appears that I cannot do this in Zoho email as it gets flagged as unusual activity. I need to be able to communicate with this group on a regular basis. What am I missing that Zoho doesn't allow

        • Unable to Schedule One-to-One Emails in Zoho CRM

          Hi everyone, I’m using the Zoho CRM Professional Edition and facing an issue with scheduling one-to-one emails directly from CRM. While I can send immediate emails without any problem, I don’t see an option to schedule these emails for a later time. I’ve

        • Canvas Detail View Related List Sorting

          Hello, I am having an issue finding a way to sort a related list within a canvas detail view. I have sorted the related list on the page layout associated with the canvas view, but that does not transfer to the canvas view. What am I missing?

        • Repeatable Fields/Sections in Zoho CRM

          Hi Zoho Team, We have a module in CRM named "Clients". We would like to know whether it is possible to have a feature enables us to have repeatable sections in our clients' profiles? For example, if we customized a section in the clients' profiles named

        • Zoho Analytics: Requests for view access

          Hello, We have a user that might request access to a certain view, report etc. However this request for access is being sent to different admins within the workspace, is is possible to set who the "approver" is of these requests? If not what are the rules

        • Boolean Fields in Mail Merge Displaying as Checkmarks

          I'm really liking the new mail merge functionality. It's replaced the Zoho Sign extension for us. One problem I've seen is that boolean operators (i.e. Checkbox fields) in CRM merge as "True" or "False". This looks a little ugly in my final document — is there a way I can get those to display as checkboxes?

        • Formula in Sub Form

          Hello - I have created a sub-form and the data is going to be insurance policy information. However some of the policy amounts are based on a percentage of a main coverage. For example, Debris removal coverage is 5% of the main dwelling policy. Is there

        • Email alias already exist

          Hello, I'm getting an error message the email alias already exist when attempting to add 2 email addresses. The emails are associated with an account I deleted. I started a new account and need to add them back to get 1 email at each. I have an open ticket

        • Migrate emails from a shared mail box to a private mail box

          How is possible migrate a shared mail box if the migration tool require a password, and the shared mail dosent have ?

        • Support poor service

          I just wanted Zoho support to give me some more concrete answers. I’m facing SMTP error issues, and they told me that the South American IP was experiencing problems, but they didn’t provide an estimate for when it would be resolved. Now my company is

        • Zoho say my domain seems to be already associated with another account

          I created a zoho account for try my domain mail configuration. When I want to add my domain in this page https://mailadmin.zoho.com/hosting?plan=free then this shows an error that is "This domain is already associated with this account a*****n@f*****."

        • Incorrect Device Time

          Hi On my windows laptop I can't sign into Zoho mail due to "incorrect device time". I'm in Toronto, Canada. How can this be resolved?

        • Get user images by API

          Hi For our internal management software, I want to retrieve user photos via REST API: curl --location --request GET 'https://profile.zoho.com/file?fs=thumb&ID=<zoid>' \ --header 'Authorization: Zoho-oauthtoken <token>' The token has `profile.userphoto.ALL`,

        • Depois de 1 ano não consigo receber e-mail

          Consigo enviar e-mails mas não estou recebendo nenhum e-mail isso aconteceu pontualmente após eu completar 1 ano de uso. Me ajudem por favor

        • Submitted form URL

          I am using the feature "Include a link to allow respondents to edit their responses" for the first time. This URL is included in the email sent to the user after they press Submit. If a form is Saved, there is a section called Partially Saved Entries

        • API to post drafts for social media

          I we want to post draft posts to our zoho social account and then approve and schedule them within Zoho social. is this possible with for example: https://apis.zoho.com/social/v2/post TIA Jon

        • Function for Emails tranfer from Lead to Deal

          Hi Due to the fact that my Deals conversion needs to be done in 2 ways - depending on the fact if those records already exists or not - resources in fields are different. I am making function control conversation for Leads but I have problem with transferring

        • Create a new immigration service- Similar to immigration law software

          It will be good if you can build a new service. Data will be pulled from the employee form. Then automatically users should be able to complete immigration forms like I 129, ETA 9089, ETA 9035 E, G- 28, W4, I 9 PDF forms and then be able to send for signature with Zoho sign. Immigration Softwares like docketwise can be used for ideas. The advantage with this it sits within Zoho people and employees don't have to feed data in another system

        • Accessibility in Zoho CRM: Not just a feature—a way to empower

          For instructions on setting up these controls, please check this help document: Configuring accessibility controls. Hello everyone, Today (December 3, 2024), on the International Day of Persons with Disabilities, we begin our journey towards a CRM that

        • Zoho Meeting very bad video quality

          Hello, I need 1080p HD on my Zoho Meeting as explained here: Low Resolution/Quality Video (zoho.com) Currently, video quality is lagging with 400mb internet which is not acceptable for my business. My 1080p 60FPS webcam performs well on platforms like

        • Contacts with Deals not appearing.

          What: I simply want to see all of the contacts that are tied to an open deal Problem: In Contacts Module > When filtering on Contacts with an open deal, Zoho only shows some Contacts instead of all. Details: More specifically, I should have ~200 contacts

        • Auto-sync field of lookup value

          This feature has been requested many times in the discussion Field of Lookup Announcement and this post aims to track it separately. At the moment the value of a 'field of lookup' is a snapshot but once the parent lookup field is updated the values diverge.

        • CRM limit reached: only 2 subforms can be created

          we recently stumbled upon a limit of 2 subforms per module. while we found a workaround on this occasion, only 2 subforms can be quite limiting in an enterprise setting. @Ishwarya SG I've read about imminent increase of other components (e.

        • Version of Cliq included with Zoho One and Limitations

          I'm confused by the information presented in the application detail page of Zoho One. I'm a solopreneur with a single-seat Zoho One Enterprise license and I need to communicate externally .. extensively. The plan details page suggests channels are limited to 100 members. Whereas the pricing plan comparison page on the Cliq marketing site says 2500 for enterprise level.  If it's 100... that's going to kill my use case as it is my understanding that external customers can only be communicated with

        • Resubmit for Approval for Zoho Books Module in CRM

          The integration between CRM and Books is great, but it is incomplete in many areas. One of them is if an estimate/invoice/sales order is rejected, the users in CRM cannot resubmit it for approval. Let's face it, sales people will mostly be in CRM and

        • Upload edited meeting recording for attendees to download

          Hi Would it be possible to let meeting organisers upload an edited version of the meeting recording? Usage case: most of us probably start a meeting 15 minutes before the official start time. It would be nice to trim that dead time off the recording.

        • Why does the embed feature within the article editor seem to be not functional?

          I would like to embed media into an article, but that feature seems to be non-functioning. Am I doing something wrong? to clarify, I do not want to create an article by embedding. I want to embed media into an article I have created in a manual.

        • Get all fields using COQL

          Hi Is it possible to get all the fields of a record using COQL?. Something similar to select * from Accounts in SQL.

        • Mapping a new Ticket in Zoho Desk to an Account or Deal in Zoho CRM manually

          Is there any way for me to map an existing ticket in Zoho desk to an account or Deal within Zoho CRM? Sometimes people use different email to put in a ticket than the one that we have in the CRM, but it's still the same person. We would like to be able

        • Can it change the language ?

          Hello ! The question is in the title ;) 

        • Notes and Notebook integration

          Maybe I missed it, but is there a way to synch notes in the desktop with the notes in the Notebook app? I've been combing through the help topics and other forum entries and not finding anything. When I downloaded the android app I assumed there was integration with the desktop notes. Is that not the case? thanks.

        • Tags on notes aren't syncing correctly on Android

          I've created notes on the desktop version that have several tags assigned, but on both my Android devices those notes only have ONE of those tags instead of all of them, despite the actual content of the note being correctly synced, and I'm also starting

        • Text formatting does not work (Notebook Mac)

          The text formatting does not work at all. It seems, that the program loses the selection and therefore hitting bold, italic, etc. does not do anything.

        • For Each Loop only returns 1st result of List, not the whole list?

          I have a custom function that collects event data from Google calendar using invokeURL. I want to create meetings in CRM from this URL response. The invokeURL response contains over 100 records and works perfectly (code line 2). Then I'm using a For Each

        • Delete Zoho Mail Account accidently from Admin panel

          Is it possible to restore deleted email accounts with all data.

        • How do I delete a test email address to which I am supposed to send a test email?

          How do I delete an email address added to a test email recipient that is no longer needed due to resignation or other reasons?

        • Next Page