Subform Time field to string.

Subform Time field to string.

Good afternoon All.

I have a Subform 'Delivery_Receiving_Hours' that captures Day (Dropdown), Time_Open (Time), and Time_Close (Time). I need to capture this data and send it to a multiline field in the CRM. The code, posted below, below will capture the day but keeps posting the time as N/A. I am performing the tests and I am putting time in. I can't figure out why it's not capturing the time input. Any help would be greatly appreciated.
  1. // Initialize the combined information string
  2. combined_info = "";

  3. // Access the subform and iterate through its rows
  4. for each row in input.Delivery_Receiving_Hours {
  5.     // Check and retrieve values for Day, Time_Open, and Time_Close
  6.     day = ifnull(row.Day, "Unknown Day");
  7.     time_open = ifnull(row.Time_Open.toString("hh:mm a"), "N/A");
  8.     time_close = ifnull(row.Time_Close.toString("hh:mm a"), "N/A");
  9.     
  10.     // Concatenate the current row's information
  11.     combined_info = combined_info + day + ": " + time_open + " - " + time_close + "\n";
  12. }

  13. // Log the combined information for debugging
  14. info "Combined Info: " + combined_info;

  15. // Update the CRM field with the combined information
  16. newLocation.put("Dock_Hours", combined_info);
    • Recent Topics

    • Default Sorting on Related Lists

      Is it possible to set the default sorting options on the related lists. For example on the Contact Details view I have related lists for activities, emails, products cases, notes etc... currently: Activities 'created date' newest first Emails - 'created
    • Send email to all contacts related to a module

      My use case: I have a module named products, the records of which contains a related list of contacts associated with subscribing to that product. In cases where i need to trigger emails manually to give specific unprecedented updates of that product,
    • Custom Modules Support for Zoho Creator Integration

      The title says it all. We have to create custom coded widgets for every little thing because this is not supported. Zoho Creator does not support custom modules. Zoho Forms does not support Multi-select-lookups. The point of Zoho is to not have to code
    • C# SDK net8.0 compatibility

      The NuGet packages seem to be targeting .net4.6.1 only. Are there any plans to target .net8.0, which is the current LTS version? Which package should I be using to interact with the API when targeting .net8.0, if any? If the SDK does not readily support
    • Notifications

      I am facing a problem with notifications, the mobile crm app does not notify me at all for any mail, task, activity, ... etc., the web is slightly better as i can see a notification on the bell icon however with a delay from real time and without a sound,
    • Disable All

      I want to disable all the fields on the form when it loads.  I know there is a way to do this by listing all the fields as follows: disable Name; disable Address; disable City;  ... I have over 50 fields on my form and i am wondering if there is a single command or way to just disable all fields on load.   On load = disable All Thank you for any help.  
    • Zoho Mail - CRM Widget

      When I click on Associate this email to a contact within the CRM widget, I get "Oops! Something went wrong". This happen when I try to associate an email in a shared mailbox. The widget detect correctly the contact and show his informations from the CRM
    • Kanban View for Projects.

      At our organization, we describe active projects with various statuses like "In Proofing" or "Printing" or "Mailing". In the Projects view, one can set these project statuses by selecting from the appropriate drop-down. While this works, it's difficult to view and comprehend the progress of all of your projects relative to each other in a table. Creating a Kanban view for projects where I can move them from one status to another allows me to see where each project is in the order of our workflow.
    • Feature request - export as video

      Export presentation as video. I think that it would be super useful for many users. Thanks
    • Display Company Logos in Pipeline View

      To improve deal management and enhance usability, we propose adding the option to display the associated company's logo directly in the pipeline view. Currently, users can only see the deal owner's avatar, but having the company's logo would make it easier
    • Attention: Scheduled Maintenance at US DC on Dec 19, 2024

      Dear Bookings users, We would like to inform you that we've scheduled maintenance activity at our US data centers on Thursday, December 19th, 2024, from 5:30 PM to 5:45 PM PT. During this period, Zoho Bookings will be completely unavailable for the accounts
    • StatusIQ

      Please add StatusIQ to data sources. We using site24x7 and StatusIQ together and site24x7 integration is already there. Thanks and regards, Torsten
    • Set Display for Numbers/Currency/etc with Client Script/Customization in Canvas List Page

      Is it possible to set a display mask for a number/currency field using Client Script or customization? I have custom fields that I would like to keep the decimal places for calculation purposes, but do not need them displayed to the user. So 101.3568
    • Cross module filtering is now supported in CRM

      Editions: All DCs: All Release plan: This enhancement is being released in phases. It is now available in AU, JP, and CN DCs. Help resource: Advanced filters While the feature is being released in phases, you can also request for Early Access. Early Access
    • Filter Criteria - Default Option for text fields should be "Contains" and not the current default "is"

      When in a list view and filtering by an input text field it would be a lot more helpful to have the default criteria be "contains" instead of "is". The "is" criteria is too specific and I'm forever changing it to "contains" in order to use the filter
    • Getting email status through api

      Refer to code below for getitng status of mail sent through CRM any modules. You can get the subject as a key in each response, so if you want to filter a specific email you just put an if condition for that. Note that the status will be given as a JSON
    • Présentation d'une nouvelle fonctionnalité de webinar à la demande

      De nos jours, les gens s'attendent à un accès instantané aux informations et aux ressources, qu'il s'agisse de divertissement en continu ou d'apprentissage en ligne. Conscients de cette évolution, nous sommes ravis de vous présenter une nouvelle fonctionnalité
    • An accurate email totals report

      DOes anyone know how to create an email totals report that actually works? I am running the outlook integration and if I count the actual total number of emails that I sent last month, it is ten times higher than what zoho reports.
    • Settings - Time Display 12-hour vs 24-hour

      Hi All This is probably a question for developers as it only seems to be an issued on applications published from Developer account to client accounts. Usually a client would update how they want to view their time (12-hour vs 24-hour) in the Settings
    • AMP HTML in Email Templates on Zoho CRM?

      Hello Team! Is it possible to add AMP HTML features to the email tempalte in Zoho CRM? Im using an external service to create tempaltes and they provide me with AMP HTML features, or dynamic HTML modules. But when I try to add them to the Email template
    • Error : Bin Locations Provided are not valid

      1. We just moved our data from the US to Indian Data Center 2. Now, in one of my organisations, I am unable to save invoices or purchase bills for items and it shows an error 3. Irony is, we dont' even use Zoho Inventory. Operations are completely on
    • [FREE LIVE WEBINAR] Maximize the impact of your marketing campaigns using a centralized Brand Studio

      Hey everyone, We're introducing a free live webinar on Zoho Marketing Plus entitled Maximize the impact of your marketing campaigns using a centralized Brand Studio. The main agenda of the webinar is to give you a complete overview of how Zoho Marketing
    • Trouble Creating Basic Chart for Accounts - past 6 months

      We run a sports performance gym, and I want to create a chart to track member growth, by month, over the last 6 months or so. We group members under the Accounts module (e.g. a family of 4 contacts has 1 billing account). Accounts are termed "Active"
    • Possible to pause/control the data refresh schedule for data visualisation triggered from custom button?

      In a module record view, I have created a custom button action to show a data table view from Zoho Analytics, using https://help.zoho.com/portal/en/kb/crm/customize-crm-account/custom-links-and-buttons/articles/custom-buttons. I noticed that the view
    • Sorting a list of record acquired from the zoho.crm.searchRecords function.

      This is something for which I'm trying to figure out a straightforward way to do. The searchRecords does a great job fetching me the records that I want. However, in some cases, where it returns multiple records, I want it to sort the returned list by date of creation of that record, so that when I do records.get(0), I get the most recent record.  As an example, here's my sample pseudo code: records = zoho.crm.searchRecords("Clients", "Office_Number:equals:123456"); Now the "records" list above contains
    • Creating cadences Unable to save

      Hi, I'm creating a cadence for sales based on the leads module I have email templates in a folder "sales Cadence emails" when I add follow up 1 I select the email address of the user the cadence is for but it won't save....why not? Moderation Update (2nd
    • Tab order for custom phone fields.

      Our Lead records utilize multiple custom phone fields, appearing in multiple sections. The tab order has been configured from top to bottom for each section. When users create a new record, or edit one in a way that makes a custom phone field appear for
    • Sales IQ needs to capture both first and last names

      Sales IQ chat only has one field for name. When this then syncs with Campaigns, the field populates the "last name" field in Campaigns. However most people fill in the "name" field of Sales IQ with either their full name or their Christian name. This
    • Export PDF from Zoho Books via API

      Hi, I'm trying to export a PDF of all the invoices from a customer in Zoho Books via API. I'm doing it this way: $url = 'https://books.zoho.com/api/v3/invoices/pdf?'; $token = "xxxxxxxxxxxxxxxxxxxxx"; $org_ID = "xxxxxxxx"; $invoice_ids = "6289710000XXXXXXXX,62897100000YYYYYYY"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url . 'authtoken=' . $token . '&organization_id=' . $org_ID . '&invoice_ids=' . $invoice_ids); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HTTPHEADER,
    • is there a way to tag the form rule? so that the email workflow can be sent through zoho begin for that perticular response?

      I have a form rule; based on which the response like a program to be sent via begin workflow. How do i do that?
    • Zoho Writer page break in a merge repeating region always adds an unwanted blank page

      Hi I'm merging a Zoho CRM record to a Zoho Writer document with a repeating region to display subform records on their own page within the document. When I try to insert a page break in a repeating region, the resulting merge always adds an unwanted blank
    • Introducing bot filtering for accurate analytics

      Dear Zoho Campaigns Users, We're happy to introduce bot filtering to enhance the accuracy of your email campaign analytics. This new feature is designed to help you filter out bot-generated opens and clicks, which will ensure your campaign reports reflect
    • Zoho Mail POP & IMAP Server Details

      Hello all! We have been receiving a number of requests regarding the errors while configuring or using Zoho Mail account in POP/ IMAP clients. The server details vary based on your account type and the Datacenter in which your account is setup. Ensure
    • Company domain with Zoho Mail as support email in Zoho Desk

      Hello, We are a Zoho One customer. We just converted to Zoho Mail from Google Workspace Mail yesterday. We have a domain name for our company. With Gmail, we were able to forward our info@company.com email to Zoho Desk. Customer would then be able to
    • Best way to organize Zoho Desk with CRM products

      I'm having a bit of trouble finding out how I'm supposed to organize our Zoho Desk (departments vs teams vs products) and how to use it. We want to use the KnowledgeBase, Community, and Tickets sections. Here's a general overview of our company to get
    • Settings Icon No Longer in ZOHO Desk?

      In ZOHO desk, there has been a gear icon for settings. as of yesterday, it is no longer there. I showed up briefly this morning but is gone again.  Anybody else experiecing this? 
    • Emoji Support in Bigin CRM

      We request the implementation of emoji support across Bigin CRM. This feature should allow users to seamlessly use emojis in text fields, headlines, and deals. It would enhance communication, improve the visual appeal of records, and bring more personalization
    • Does Zoho Learn integrate with Zoho Connect,People,Workdrive,Project,Desk?

      Can we propose Zoho LEarn as a centralised Knowledge Portal tool that can get synched with the other Zoho products and serve as a central Knowledge repository?
    • Workdrive API Get list of Sub Folders not working

      Hello Workdrive API "et list of Sub Folders" not working. Can you please check this. https://workdrive.zoho.com/apidocs/v1/teamfolder/getteamfolderfolders
    • is there a way to add tag in the "form rule" so that the email workflow can be automated through zoho begin for that perticular response?

      I have a form rule; based on which the response like a program to be sent via begin workflow. How do i do that?
    • Next Page