Search - Joel Lipman .Com

21. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... as 10.00%. And they need the decimal because sometimes they might offer 12.5%. But when it displays in a template, it isn't that pretty to look at: Instead, could they have 10% to display instead of 10.00%, ...; Created on 08 February 2022
22. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; ... This has been raised a few times by multiple clients but the fix is rather quick as long as you can get to the HTML of the template: Login to ZohoCRM > Setup > Customization > Templates > Inventory ...; Created on 03 February 2022
23. Zoho Deluge: a HTML Entity Decoder: / Zoho /; What? A very quick article to document a HTML Entity decoder in Zoho Creator. Why? Sometimes when receiving data from a third-party, we may receive some strings containing "&" or " " ...; Created on 27 January 2022
24. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; What? This is an article to remind me how to calculate various times for an appointment booking system based on the timezones of each party. Why? The use-case scenario is that our Creator server ...; Created on 07 December 2021
25. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... start in CRM format v_SystemAppointmentDateTimeStart = v_SystemCallTime.toString("yyyy-MM-dd'T'HH:mm:00") + v_ApplicationTimeOffset; // // set system/application date time start in US format v_CustomerAppointmentDateTimeStart ...; Created on 18 November 2021
26. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
27. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... isn't what I want because it has returned the same currency several times and thinks they're unique/distinct because the IDs of each quote record are different. Having spoken to Zoho and raised with ...; Created on 08 October 2021
28. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; What? This is an article to document how I got a client's eBay to notify the seller every time a buyer bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications ...; Created on 20 September 2021
29. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; What? A quick article to explain why the full name might appear in the last name field in Zoho CRM. Why? We had a customer report the issue that sometimes the full name of a contact was appearing ...; Created on 01 September 2021
30. ZohoCRM: Process all records of a module: / Zoho /; ... you have a few hundred records, or a few hundred thousand records, we sometimes want to write a function that will check each record and mark it so that the process doesn't repeat on records that have already ...; Created on 24 August 2021
31. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... alphabets is necessary when dealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be times when you have lost the formatting and get weird question ...; Created on 03 June 2021
32. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... > Connections) Click on "Add Connection" and click on "Zoho OAuth" Give a lower connection name, eg. "joels_connector" Select the scope ZohoProjects.timesheets.ALL as a minimum (or CREATE/READ): ...; Created on 30 April 2021
33. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; What? This is a very quick article with examples of managing a multi-user or multi-lookup field in CRM using Zoho Deluge. Why? Sometimes you might need this when data mapping fields from one module ...; Created on 28 April 2021
34. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... sometimes it won't. Escaping the ampersand with a backslash or url encoding to %26 wasn't working for me. I spent several hours trying to write a script that could search for the existing records by company ...; Created on 28 August 2020
35. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... type: GET connection: "joelconnector" ]; Additional I'd always recommend locking down your app privileges by checking the scope(s) you have allowed it to have.... However in those times of ...; Created on 12 August 2020
36. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... time field in Deluge So annoying but sometimes you want to insert a date/time value into a date/time field and you get the error: v_MyDateTimeString = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ssZ"); // ...; Created on 06 February 2020
37. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; What? This is a quick article to demonstrate how to compare two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would ...; Created on 13 January 2020
38. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; ... // init v_Output = ""; l_BadWords = ; l_TimesTried = ; // loop through times you will chance it for each v_TimeTried in l_TimesTried { // init b_BadWordFound ...; Created on 09 May 2019
39. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... to generate the infamous JWT. If you've been trying to check your base64 encoded strings at JWT.io then it's hard because the timestamps, included in the encoding, change every second. You can get it verifying ...; Created on 02 February 2019
40. Zoho CRM: APIv2 using PHP & cURL: / Zoho /; ... of code below is using the functions to read data from Zoho CRM and to write data back to the system. Why? I've rewritten this code a few times and want to store the finalized version (following ...; Created on 30 January 2019