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. 

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();
8. 
   
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);
13. 
    
14.     // b. Adjust Time_Open and Time_Close to the nearest hour
15.     openTime = operatingHour.Op_Open;
16.     closeTime = operatingHour.Op_Closed;
17. 
    
18. 
    
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.     }
30. 
    
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.     }
42. 
    
43.     // Trim whitespace from time strings
44.     openTimeString = openTimeString.trim();
45.     closeTimeString = closeTimeString.trim();
46. 
    
47.     info "Processed Open Time String: " + openTimeString; // Debug
48.     info "Processed Close Time String: " + closeTimeString; // Debug
49. 
    
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.     }
59. 
    
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.     }
68. 
    
69.     itemData.put("Open", openTimeString); 
70.     itemData.put("Close", closeTimeString);
71. 
    
72.     subformRecords.add(itemData);
73. }
74. newLocation.put("Hours_of_Operation", subformRecords);

• Topic Participants

• Charles

• 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

• 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?

• 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

• 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

• Calculate months and years between 2 dates on subform

  I am looking for a function syntax for an employment candidate to calculate the number of years and months (decimal format. eg 1.2 years) they are employed. I have their start date entered, but if the end date is blank, that tells me they are still employed

• Combine related grouping values into categories in CRM analytical components

  Hello everyone, Analyzing large datasets can be challenging when dealing with numerous individual data points. It's often difficult to extract meaningful insights when information is scattered and ungrouped. To address this, we're adding options to create

• How Kiosk Studio can simplify sales for bank employees | Kiosk Studio Session #4

  Hello everyone, Banks can boost revenue by cross-selling to their current customers. For example, they can sell credit cards, personal loans, and more to existing account holders. To do this, bank employees move all around the CRM, open and close records,

• Tip #19 - Create checkbox tracker in your spreadsheet

  Hello Sheet users! We are here with yet another tip to help you get the most out of Zoho Sheet. Spreadsheets can be used to handle a variety of tasks, but ever tried using checkboxes to track the progress of your action items dynamically? Here's a sample

• Integrate Oracle with ZOHO CRM

                       Please let me know if its possible to Integrate Oracle with ZOHO CRM. If yes then help me in doing it. 

• UUIDs

  Has anyone coded a Universal Unique Identifier (UUID) generator in Deluge?

• Introducing signer groups: Streamline signature collection and make it even faster

  Hello everyone, We're excited to introduce signer groups, a feature designed to make your signing process quicker, more efficient, and collaborative. With signer groups, you can send an envelope to a group of people, and any member of the group can open

• Calendar - Recurring Event - End of Month and Last Weekday of Month

  How do I set a calendar event to recur on the last day of every month? How do I set a calendar event to recur on the last weekday of the month?

• Duplicate Zoho Invoices and Sales Receipts

  We have been running into an issue where upon saving an invoice or a sales receipt, we get a duplicate: same information saved twice but with a different invoice id/number and sales receipt id/number. I have logged a ticket but so far no response. It

• Introducing revamped Zoho Creator Developer Console—a powerful platform for developing and distributing apps

  Hello everyone! We're thrilled to announce the launch of the revamped Zoho Creator Developer Console—a dedicated platform designed specifically for Creator developers and Partners to build, test, and distribute apps to your clients. Developer Console

• Phone App of CRM doesn't find contacts

  I open the crm to and do a contact search but nothing comes up. If I do a full zia search it will find an old note that is attached to a contact and I can open the contact. BUT I still can't enter notes of calls, set appointments, etc. It requests I go

• [Product Update] Deprecation of 'Inbound Transport Details' module in Zoho Analytics - Amazon Seller Central integration

  Dear Customers, Please be informed that the Amazon Seller Central will be deprecating the 'Inbound Transport Details' module APIs effective December 20, 2024. As a result, this module will no longer be supported in the Amazon Seller Central - Zoho Analytics

• Is there any support for Drivers license and other forms of ID scanning capabilities?

  When scanning a drivers license barcode for data input to a Form, the scanning tool receives all the raw data but there doesnt seem to be a function to limit or remove the unnecessary fragmrnts, like a prefix. Is there any support or info in the help

• Exciting Update: Multi WhatsApp Business Account (WABA) Support Now Available in SalesIQ!

  We’re pleased to share an important update that will enhance the way you manage your WhatsApp Business accounts (WABAs) within SalesIQ. With the launch of Multi WABA support, you can now connect and manage multiple brands more effectively, each under

• Gravity Forms plugin not passing some fields

  I use the gravity form zoho plugin to push data from my lead form into my lead page in Zoho CRM. Everything was working file for about 6 months. Suddenly on Oct 1st, some of the fields are no longer getting passed to Zoho. The fields with the problem

• Can't delete bank transactions (i changed from 14 days trail to free just now)

  Hi, I manually added one bank transaction When i try to delete it, it say below: What should I do?

• Feature Request: Search in the PC client. Some thoughts about the search.

  Hi all. I'm really excited to start using Zoho Notebook, but I'm missing some of the search capabilities on my desktop. There are also some thoughts on improving search in general. Search is very important to me, without it it is difficult for me to use

• Leave Policy for Brazil

  Hi, Brazil asked us to configure Zoho People to apply the following policy: · To block starting vacations 2 business days before holidays or weekends; Employees cannot start their vacations 2 days before holidays or weekends. Example: If December 25th

• Adding date field to each individual Items when creating Invoices?

  When adding items into an invoice I need to be able to have a date for each item. Example below: Date Item Description Qty Rate Discount(%) Tax Amount 31/07/13 Brown Sugar Performance 1.00 3,000.00 0.00 10% $3300 Is this possible or will it be in the

• Auto-Create OneDrive Folder Structure Upon Lead Creation

  Hello, New to Zoho and looking for help on a critical process automation I'm looking to implement. My company currently utilizes OneDrive for file management and the folder structure is Proposals -> Client Name -> Address (where I need to initially create

• Profile Page View Customization

  I need to change the fields, sections from the profile view of an emplyoyee.

• What do the Image Sizes mean in Zoho CRM Email Templates?

  Below you can see the image options in email templates: Banner, Fit, Small, Medium, Original, Custom. Can someone from Zoho please share with me: What each is/means? How each will look on desktop AND mobile? How to edit "custom"?  If I choose "Custom"

• Translate any published presentation to the language of your choice

  As part of our constant effort to enrich your presentation experience, Zoho Show has rolled out a new feature for translating published presentations. Consider the following scenario: Zylker IT services, a multinational corporation, has announced product

• Blueprint: multi-select lookup field not available in the criteria option

  I read this old forum post which stated that multi-select lookup fields are now selectable as an option in a Blueprint transition configuration: https://help.zoho.com/portal/en/community/topic/blueprint-multi-select-lookup-field-not-available-within-blueprint-transition

• Apply Credit Note Automatically

  We need the ability to apply open Credit Notes toward invoices generated by recurring invoice as the first, priority payment. This should be an option that we can enable/disable in the recurring profile and/or the Credit Note. Other invoicing systems can do this. I'm not sure why Zoho Invoice doesn't have it. Here's an example for a Recurring Invoice... If a customer has open Credit Notes, and a saved credit card set for auto-pay, once an invoice goes out, the credit balance gets automatically applied

• Workflow for "Expenses" module?

  Hi there, over the last 2 years, Zoho Expense has seen tremendous growth and we are happy with it. But, sometimes it is frustrating to see things are being implemented halfheartedly, or so it seems. For example, There is the possibility to create workflows

• Next Page