Search - Joel Lipman .Com

1. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... Queries eBay for all orders given a from and till date Date Created: 2023-02-28 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: ...; Created on 28 February 2023
2. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... get the quote details given a record ID r_QuoteDetails = zoho.crm.getRecordById("Quotes",p_QuoteID); // // check target email is not null/blank if(!isnull(r_QuoteDetails.get("Email"))) { v_Url ...; Created on 18 August 2022
3. Oracle SQL - Convert given list (CSV) into Rows: / Oracle PL/SQL /; Just a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've ...; Created on 30 August 2011
4. Joomla - How to preview module positions in a given template: / Joomla /; I was asked "... how do you find out where the positions are, like USER 1 and TAB 4 etc..." To open a web-browser window or tab with this preview, type the following in the address bar after ...; Created on 02 April 2010
5. Zoho Creator: Input Color Picker: / Zoho /; ... a radio type field into a color picker. Pre-amble: Create a Zoho Creator form Create a form, I'm calling mine "Color Picker" Add a note field, I've given it the field link name "Note_ColorPicker_Css" ...; Created on 14 October 2024
6. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... we take each character from the given string and convert it to its RGB value. Replace letters A to F with their numeric equivalents. Made up of 2 characters to convert to an RGB subset, the 1st value ...; Created on 11 October 2024
7. Zoho Projects: Get All Events: / Zoho /; ... convert a Zoho Project DateTime to a DateTime datatype (given 12/12/2023 12:00:00 PM... remove ambiguity: mm/dd or dd/mm?) if(!isNull(m_PastEvent.get("scheduled_on"))) { if(m_PastEvent.get("scheduled_on").contains(" ...; Created on 22 July 2024
8. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... of user was given in the brief but removed here for privacy). Finally, we delete any of these tasks when they get transferred to the contact record. Step 1: Workflow on Create and function to ...; Created on 14 May 2024
9. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... function to rule-them-all This code was used for testing, then for correcting any historical records, and then when given just one ticket reference; will create or update the images associated in the ...; Created on 26 January 2024
10. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... != null) { // // let's format a little as the business days are given in the correct order m_ShiftRow = Map(); m_ShiftRow.put("open","00:00"); m_ShiftRow.put("close","00:00"); m_ShiftBuildU ...; Created on 28 March 2023
11. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; What? A quick note here on how to connect to the DHL API and check on a package given a tracking number. Why? In our megafunction to generate a customer, a product/item, a sales order, an invoice, ...; Created on 21 March 2023
12. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"... ...; Created on 01 March 2023
13. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... and payment date to appear on the invoice. How? This sounds rather straightforward, write a function that given an invoice, checks the customer payments and updates the custom fields. Executing ...; Created on 17 August 2022
14. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... of mine (see my pinterest) to build a nicer looking computer and I was given £1000 towards a new computer... It's more than enough to get a running White Snow Edition PC but I put in some more to get the ...; Created on 12 March 2022
15. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... was to recover the relevant product based on any given Product SKU. Making the above into a function as well as returning the inventory item ID and the product ID: map API.fn_SearchShopifyBySKU( string ...; Created on 14 February 2022
16. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... record; use Zoho's GeoCode function to convert this into a latitude and longitude, then we're going to use a free TimeZone API (one that returns a timezone given a lat/lng). The added feature is that we ...; Created on 15 December 2021
17. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... Friday at 08:00 in the morning and will create a task if time logged is too low and will remind via Popup at about 4pm (16:00). You will need a connector (I've called mine joel_timesheet) and I've given ...; Created on 02 December 2021
18. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... dates given a number of days So here's another scenario where you have a start date and you are asked to list the working days, 7 days after the start date. I'm aware of the method .workdaysList(): date1='2022-07-21'; date2='2022-07-29'; info ...; Created on 02 November 2021
19. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... a list of all the listed active products in a fixed price item listing. The example below is a function which, if given the page number and the number of entries per page, returns these in JSON as a Zoho ...; Created on 13 October 2021
20. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... that any change was made. Instead, I need to add an additional field called "eTag_Title", check if the new MD5 is different, if it is then I proceed with the automations otherwise I stop it. // get given ...; Created on 19 September 2021