Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 "Time_Field". The following reads from a form (creator data table) where thisServiceRecord.Opening_Time is returning an hour value (eg. "08:00") and thisServiceRecord.Closing_Time returns an hour value (eg. "20:00"). This will output a picklist which...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 Happens if you don't convert the field-value pair dataset to a string: m_RecordData = Map(); m_RecordData.put("Field_To_Update", "Value_To_Put"); m_Data = Map(); m_Data.put("data",m_RecordData.toJSONList()); r_RecordUpdate = invokeUrl [ url :v_EndPoint...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 Type: set this to "Header" Grant Type: set this to "Authorization Code" Client ID: Copy & paste from the previous step this value into this field. Client Secret: Copy & paste from the previous step this value into this field. Authorize URL: Enter the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 This is an article to remind me how to search for CRM records by a value that may contain an ampersand or parenthesis. Why? I wrote this article because some searches will work for me and sometimes it won't. Escaping the ampersand with a backslash or...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 ZC_SUBFORM_250 expression found COLLECTION expression Another error you may get when using the deluge script is: LIST value cannot be assigned to 'mySubform' -- or -- COLLECTION value cannot be assigned to 'mySubform' or expecting ZC_SUBFORM_70...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 in r_Response.get("fields") { if(r_Field.get("api_name") == "Customer_s_Timezone") { // loop through all the picklist values of this dropdown for each r_TimeZone in r_Field.get("pick_list_values") {...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Inventory: Mark a package slip as delivered and shippedhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

14 July 2022 ]; info "Marked as Delivered:"; info r_Delivered; } } } } Error(s) Encountered {"code": 4,"message": "Invalid value passed for salesorder_id"}: Not sure about what ended up fixing this one. I think I converted the sales order to an invoice and created a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 + v_RequestId; r_RequestDetails = invokeurl [ url :v_Url type :GET headers:m_Header ]; // // retrieve the value of field "Deal_Ref" from the ZohoSign Document Request v_DealRef = ""; if(!isnull(r_RequestDetails.get("requests"))) {...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 key is mandatory when you include Who_id and What_Id. FREQ (String): Defines the frequency of the reminder. The possible values are DAILY, WEEKLY, MONTHLY, YEARLY, NONE. If you specify, NONE, the system sets a one-time reminder and TRIGGER becomes...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 each v_Field in m_ThisGoal.keys() { m_OutputRecord.put(v_Field, m_ThisGoal.get(v_Field)); //info "Field: " + v_Field + " || Value: " + m_ThisGoal.get(v_Field); } m_OutputAll.put(v_GoalKey, m_OutputRecord); } } // // for testing I'm doing 3 records at a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 m_CrmLineItemTax.put("name",ifnull(m_XeroLineItem.get("TaxType"),"NONE")); m_CrmLineItemTax.put("value",m_XeroLineItem.get("TaxAmount")); l_CrmLineItemTax.add(m_CrmLineItemTax); m_CrmLineItem.put("Line_Tax",l_CrmLineItemTax); //...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 based on the pull from invoices article I wrote earlier but with quotes from Xero, things panned out differently: Date/Time values don't include a timezone Issues with tax rates meant replicating a tax list copy from Xero to Zoho the Client doesn't use...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Windows 7 and Google Chrome incognito mode by defaulthttps://www.joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 in the context menu Left-click on Properties Add the word -incognito (including the hyphen/dash) to the end of the Target value Ok that and see if it works Note that if in point 4, if there are any spaces in that value, you should add a double-quote...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

If Then Else in Report Builder 2.0 Expressionshttps://www.joellipman.com/articles/microsoft/ssrs/if-then-else-in-report-builder-20-expressions.html

06 May 2010 if statement: If (MyFieldName = 0) Then Return 1 Else Return MyFieldName Can be expressed as: IIf(Fields!MyFieldName.Value = 0, 1, Fields!MyFieldName.Value)

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

MySQL Commands to display all columnshttps://www.joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 as "tablename.columnname") that had the data_type TEXT across all databases: SELECT CONCAT(TABLE_NAME, '.', COLUMN_NAME) AS value FROM information_schema.COLUMNS WHERE DATA_TYPE='text' ORDER BY TABLE_NAME, COLUMN_NAME The following is a MYSQL query that...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Increase Recent Documents Number in Windows XPhttps://www.joellipman.com/articles/microsoft/windows-os/increase-recent-documents-number.html

28 July 2011 Run > Regedit > OK Browse to HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer Create New DWORD Value Name it "MaxRecentDocs" Double-click on the new DWORD Set value data to "19" ( equals 25 ) Leave Base as "Hexadecimal" OK...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Functions to convert Hex 2 RGB and vice-versahttps://www.joellipman.com/articles/automation/autohotkey/functions-to-convert-hex-2-rgb-and-vice-versa.html

27 September 2011 code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal to RGB: HEX2RGB(HEXString,Delimiter="") { If Delimiter= Delimiter=, StringMid,R,HexString,1,2...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

SSRS Change Background Color of Imagehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 expression as well (I embed these and then refer to them in the expression by name). For example: =IIF(Fields!SummaryStatus.Value="Success", "status_ok", IIF(Fields!SummaryStatus.Value="Unknown", "status_unknown", "status_fail"))

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 = 1; // // map to retrieve all records (to include approved and converted records, this needs to be specified as the query value) m_IgnoreRestrictions = Map(); m_IgnoreRestrictions.put("approved","both"); m_IgnoreRestrictions.put("converted","both"); //...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 name of this contact (not sure why this returns both first and last) var v_ContactName = ZDK.Page.getField('Last_Name').getValue(); // get the email of this contact var v_ContactEmail = ZDK.Page.getField('Email').getValue(); // get the value of the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *