Search - Joel Lipman .Com

1. Zoho Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
2. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; What? A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me ...; Created on 16 June 2021
3. Zoho Deluge - Generate 5 Letter Booking Retrieval Code: / Zoho /; What? This is a quick article on how to generate a 5 letter code from several functions: one which returns 5 randomly selected characters and another two which convert a number to 5 letters. Why? ...; Created on 09 May 2019
4. Generate a Timesheet in MySQL: / MySQL /; What? This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with ...; Created on 05 December 2013
5. Generate Academic Calendar using MySQL: / MySQL /; ... is to quickly generate a calendar for a full academic year for referencing by staff/students. How? Let us assume that we have a system holding a calendar in the following table (called "joes_weekstructure"): ID ...; Created on 27 November 2012
6. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... set the data type r_DownloadedPhoto.setParamName("image"); // // build up request to Zoho m_Params = Map(); m_Params.put("image",r_DownloadedPhoto); // // generate endpoint v_Url = "https://books.zoho.eu/api/v3/items/" ...; Created on 21 June 2022
7. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... on the "Generate, view, upload, or delete SSL certificates" link in the right sidebar Scroll down and click on "Choose File" button under the "Upload a new certificate" section > Then select the certificate ...; Created on 07 April 2022
8. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Zoho Creator to accept this ID, download the file, and upload it to a "File Upload" field Get Zoho Creator to generate a published / public URL of the file Get Zoho CRM to scan Creator for the public ...; Created on 31 March 2022
9. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... } } } } Source(s): Shopify Partners - How to Generate a Shopify Access Token (legacy) Shopify Community - API To Search Products By SKU Zoho Deluge: Push It ...; Created on 14 February 2022
10. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... XML of a GetItemTransactions request to eBay. How? You'll need an access token for eBay which I documented on how you can generate one in my article: Zoho Creator: Push to eBay Listings. Then you ...; Created on 22 January 2022
11. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; ... which in turn generates an order in Shopify. This article is primarily for myself as I need to do this for some other clients and I just want to continuously refine and improve my code below. How? ...; Created on 21 January 2022
12. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... ******************************************************************************* // Generate your access token to connect to Xero and query Xero records // See my article: https://www.joellipman.com/articles/crm/zoho/zoho-deluge-sync-to-xero-api.html // v_TenantID ...; Created on 10 January 2022
13. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: List of tz database time ...; Created on 07 December 2021
14. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... Source(s): Joel Lipman: Zoho Deluge: Generate List of TimeZones Joel Lipman DataSources: Time zones supported by Zoho (MS Excel file) Wikipedia: Daylight saving time by country Wikipedia: ...; Created on 07 December 2021
15. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; What? An article to save time where a customer wants to click a button to generate a merged document in Writer and attach it to the CRM record. Why? Our use-case is that we have a client who has ...; Created on 21 October 2021
16. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... You will note that I use the access token function (one that regenerates an access token or reuses if not expired). Thereafter, I use the GetMyeBaySelling API Call with specific criteria to only return ...; Created on 13 October 2021
17. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; What? A quick note for when I want to quickly generate maps of a currency or a tax from a client's Zoho Books. Why? The use-case here is that we are creating a Sales Order in Zoho Books from Zoho ...; Created on 24 September 2021
18. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... on the function that generates an access token from a refresh token: string API.fn_eBayConnect_AccessToken() { b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api = API_Integration[Connection_Name ...; Created on 20 September 2021
19. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... the following code which generates a sample CSV and then loops through storing each row as a data record and outputting it to screen: // generate a sample CSV file v_DataCSV = "1,Joel Lipman,Kings ...; Created on 26 August 2021
20. Xero API: Send Multiple Invoices: / Xero /; What? A really quick article for anyone who got stumped by the same issue: How to send multiple invoices to Xero in one API call? Why? Our use-case is in Zoho Deluge which couldn't generate more ...; Created on 15 August 2021