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 the above, if there are no matching records, r_Coql will simply return an empty string. Hence the check for isNull on the keys info and data. And yes, the part that took me about 8 hours and the key point above is to replace the ampersand with its...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 0.23.6) Create a project In the terminal, type zet init You will be given a list of Zoho services, use the arrow up/down keys to select “Zoho Creator” and press the return/enter key. Give the project a name: eg. “joels_awesome_app” (without the...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 The following allows only 1 user in a department to apply for leave in a day. c_Response = Collection(); for each d in dd.keys() { c_Params= Collection(); c_Params.insert("date":d); c_Params.insert("type":"3"); c_Params.insert("userId":empid);...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 Enter (DO NOT START TYPING FOR A MODULE NAME - LET THE SYSTEM POPUP YOUR OPTIONS AS PER THE FOLLOWING SCREENSHOT - USE ARROW KEYS OR MOUSE): As you can see from the screenshot above, there are modules concatenated with one module an "X" and then the...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 ID fields that we didn't use in my previous article but are going to use now. You get the Dev ID from your application keys page: For the next steps, it's best if you create these 2 functions beforehand, as there isn't much time between getting the...

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

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 how we set up an access token in Shopify using the new process. Preparation: You don't have to do this, but I store all the keys in a Zoho Creator form (I call mine "API Integration") ready with the following fields: Connection Name (Single Line) Dev ID...

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

GoDaddy Apache cPanel: Install SSL Certificatehttps://www.joellipman.com/articles/linux/cpanel/godaddy-apache-cpanel-install-ssl-certificate.html

07 April 2022 Duplicated the tab and went to the SSL/TLS page in CPanel and clicked on "Generate, view, upload, or delete your private keys". Clicked on "Edit" alongside the domain name I wanted to install this SSL for. Copied the "Encoded Private Key" to clipboard...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 the code for the "Message Handler" Get an OpenAI API Key Login to OpenAI Browse to https://platform.openai.com/account/api-keys Click on "Create a new key" Copy & paste into a text editor for use in the code below Edit the Message Handler code ChatGTP...

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

ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 m_Response.put("code",0); return m_Response; Source(s): Stripe Dashboard - Developers - API Keys Stripe Docs - Decline codes - Learn about decline codes and how to resolve them when a charge fails.

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

ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 // // great now let's build a ZohoCreator subform c_UsualShift = Collection(); for each v_WorkDay in m_ShiftBuildUp.keys() { info v_WorkDay; // // format the opening time and closing time v_StartTime = zoho.currenttime.toString("yyyy-MM-dd ") +...

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

Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics-zoho-people-monitor-datasource-sync.html

02 July 2024 we have is as follows: "; if(!isNull(m_DataSourceInfo.get("datasourceName"))) { for each v_DataSourceKey in m_DataSourceInfo.keys() { v_Message = v_Message + " " + v_DataSourceKey + " " + ifnull(m_DataSourceInfo.get(v_DataSourceKey),"?") + " "; } } else...

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

Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 be presented with a table of about 10 columns called "Untitled-1". I enter some labels in the first column. These will be keys later on to link my report to so keep them short without any special characters. I then saved this table with the name "Joels...

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

Zoho Workdrive: Getting Team Folder IDhttps://www.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 = "{parent_id}"; v_WorkdriveFolderID = ""; v_WorkingFolderName = zoho.currentdate.toString("yyyy"); if(!m_SubfolderNames.keys().contains(v_WorkingFolderName)) { m_Attr = Map(); m_Attr.put("name", v_WorkingFolderName); m_Attr.put("parent_id",...

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