Search - Joel Lipman .Com

1. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... = 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", v_ParentFolderID); // m_Params ...; Created on 11 September 2024
2. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... 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 ...; Created on 25 July 2024
3. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... each v_DataSourceKey in m_DataSourceInfo.keys() { v_Message = v_Message + "" + v_DataSourceKey + " " + ifnull(m_DataSourceInfo.get(v_DataSourceKey),"?") + " "; } } else { v_Messag ...; Created on 02 July 2024
4. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... DTSTART in RRULE keys. Specify the mandatory keys. Error: INVALID_RRULE: You have specified an incorrect value for FREQ, INTERVAL, or BYMONTHDAY, BYDAY, BYMONTH, BYSETPOS. Specify the correct value fo ...; Created on 14 May 2024
5. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... 100 product categories so we'll just to page 1 but specifying 100 per page as the default is only 10. // // API keys (these are made up so enter your own in these 2 lines below v_MyWordPressSiteUrl ...; Created on 15 April 2024
6. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... 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_StartTi ...; Created on 28 March 2023
7. ZohoBooks: Stripe Terminal Integration: / Zoho /; What? A quick article on some code added to a button in ZohoBooks off the invoice module to initiate your Stripe terminal to take a payment. Why? Just to make it easy on the staff at a counter ...; Created on 16 March 2023
8. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... Update November 2024 Code to get this working with GPT 4o Mini: // requires a paid account: https://platform.openai.com/api-keys v_ChatGPT_ServiceAccount_Key = "sk-XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"; // m_Header ...; Created on 06 March 2023
9. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... edit 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 ...; Created on 13 February 2023
10. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... 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 ...; Created on 07 April 2022
11. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... ID from Shopify. How? The below details on 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 ...; Created on 14 February 2022
12. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... replacements m_HtmlEntity = Map(); m_HtmlEntity.put("&","&"); m_HtmlEntity.put(" "," "); // // loop through each of the above replacing where found for each v_HtmlKey in m_HtmlEntity.keys() { v_StringToDecode ...; Created on 27 January 2022
13. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... field and the Session 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 ...; Created on 20 September 2021
14. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... - 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 name of the linked module. A module called "Opportunities_X_Products" ...; Created on 28 April 2021
15. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... code is doing, let me give an overview: Build up a map with sample data (you won't need to this, use your own data, this one is for this demonstration only) Initialize a list to hold the keys which we ...; Created on 29 January 2021
16. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; ... = l_Data.toString(); info v_Data; // yields // , Some formatting and a lot of replaceAll: l_Keys = List(); l_Keys = v_Data.toMap().keys(); v_DataHtml = v_Data.replaceAll("},{", true); v_DataHtml ...; Created on 11 January 2021
17. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... 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); ...; Created on 10 December 2020
18. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... 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 ...; Created on 24 October 2020
19. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... = ifnull(r_Coql.get("data").get(0).get("id"),0); } Note that for 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 ...; Created on 28 August 2020
20. Zoho Deluge: Convert Map to URL Parameters: / Zoho /; What? A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id"); m_Payload.put("redirect_uri","https://www.joellipman.com"); m_Payload.put("response_type","code"); m_Payload.put("scope","my_api_scopes"); m_Payload.put("prompt","login"); Great! ...; Created on 09 March 2020