Search - Joel Lipman .Com

1. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
2. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... So create a function in the Zoho App you are checking, or somewhere you can write some Zoho Deluge code. Note that requesting an increase of the limit or an upgrade to the subscription will likely ...; Created on 31 July 2024
3. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... another key) Zoho Deluge Here's the code to retrieve all the product categories. We need this to get the count of all products (if there's another way, I'd love to hear it). We don't have more than ...; Created on 15 April 2024
4. Zoho Deluge: Proper Case for Names: / Zoho /; ... to work using Zoho Deluge. How? There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some European names: // // ...; Created on 13 July 2023
5. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; What? A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a ...; Created on 06 July 2023
6. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; What? If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait ...; Created on 03 July 2023
7. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... each index v_Increment in l_AddPages { l_Pages.add(v_Increment + 1); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details in a JSON or ZohoDeluge Map format m_Response ...; Created on 29 March 2023
8. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; What? A super quick article on getting the business hours set in ZohoCRM. Why? When creating a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing ...; Created on 28 March 2023
9. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... The deluge function So this function will return the word "delivered" or whatever other statuses there are for a package: /* Function: String fn_DHL_CheckShipmentStatus(string p_TrackingNumber) ...; Created on 21 March 2023
10. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; What? A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file ...; Created on 01 March 2023
11. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... as a string x_ResponseBody = invokeurl [ url :v_Endpoint type :POST parameters:x_Params headers:m_Headers ]; Parsing the response into JSON or a Deluge Map This can be appended to the ...; Created on 28 February 2023
12. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... recently modified products at the end of each day and run some Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is considered the source of truth ...; Created on 20 February 2023
13. Zoho Deluge: Generate a loop or list of any size: / Zoho /; What? This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts ...; Created on 21 October 2022
14. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; What? A noteworthy article in my opinion on how to send a CRM quote record using a template the customer created from a button. Why? Yes you can do this already by going to the record, clicking ...; Created on 18 August 2022
15. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; What? A quick article on how to upload an image to the product/item listing in Zoho Inventory. Why? We're enhancing the out-of-the-box integration from eBay to Zoho Inventory bespoke for a customer. ...; Created on 21 June 2022
16. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; What? Following on my article of creating a task using Zoho Deluge and scheduling a call using Zoho Deluge, here's an article on creating a Meeting or an Event using Zoho Deluge. Why? Because at ...; Created on 02 March 2022
17. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... Deluge - Some Useful Regular Expressions list but I felt this deserved its own article. Why? A client wanted the discount displayed on a template and if they gave 10% discount, it would display ...; Created on 08 February 2022
18. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... a HTML entity would be submitted. So it doesn't decode every HTML in existence, only the ones I know will happen. Here's the Zoho Deluge code I use (note that I've put this in a namespace called "DataCleansing", ...; Created on 27 January 2022
19. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; What? A very quick article to remind me how to send a text message using Twilio API in Zoho Deluge. Why? The use-case here is that we want local sense dialing where specific numbers are used both ...; Created on 16 December 2021
20. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; What? An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. ...; Created on 15 December 2021