Search - Joel Lipman .Com

1. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; What? This is a quick article on how I built my 2022 workstation and got 5 monitors working with only 1 graphics card. Why? This took me a good few hours to get working so I thought this article ...; Created on 12 March 2022
2. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; What? This is an article which is the updated version of my article Zoho Deluge: Push Item to Shopify API for 2022 using the new policy that Shopify have implemented when creating a custom app. Why? ...; Created on 14 February 2022
3. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... 2022-01-17 (Joel Lipman) - Initial release - Forwards webhook to Zoho Creator Date Modified: 2024-04-22 (Joel Lipman) - Minimized amount of processing ...; Created on 22 April 2024
4. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... order/package slip/invoice (if not exist) Date Created: 2022-05-05 (Joel Lipman) - Initial release Date Modified: 2023-01-23 (Joel Lipman) - Revamp of code - ...; Created on 27 April 2023
5. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... 1000 ]) // the actual number may be less than this but this is for pagination estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the filter for orders by status to return: All, Active, Cancelled, ...; Created on 29 March 2023
6. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... on Shopify,Modified on Shopify,Published on Shopify"; l_CsvFileRows = List(); l_CsvFileRows.add(v_ReportCSV); // // app specific v_ShopID ="joels-awesome-shop"; v_ShopifyApiVersion = "2022-01"; v_AccessToken ...; Created on 20 February 2023
7. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... console.log("Joel Lipman - 20221018 -------------------------"); // get some values from the current record var v_CurrencyCode = ZDK.Page.getField('Currency').getValue(); var v_ConsultantLocation ...; Created on 09 December 2022
8. 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
9. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... print (6 June 2022) and I wanted to make sure it didn't just disappear or be difficult to find in future. How? The process of sending a PDF file to your Kindle device is also quite straightforward. ...; Created on 29 June 2022
10. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... = 123456789012345678; // // your organization ID (optional) v_BooksOrgId = 20220621; // // download photo from eBay r_DownloadedPhoto = invokeurl [ url :v_EbayPictureUrl type :GET ]; // // ...; Created on 21 June 2022
11. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... ID v_BooksOrgID = 20221234567; // // determine URL of file to download (note the DC here is EU but yours might be COM) v_Url = "https://inventory.zoho.eu/api/v1/items/" + input.Zoho_Inventory_ID ...; Created on 31 March 2022
12. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... need the offset so that when a user clicks on the #9 entry, the system will know this is March 9th 2022 and not June 9th 2021... To do this, we have 2 date fields which will be hidden to the user but ...; Created on 09 March 2022
13. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... recurring pattern (this one sets to everyday from today) m_Pattern = Map(); m_Pattern.put("RRULE","FREQ=DAILY;INTERVAL=1;DTSTART=2022-03-02"); m_ScheduleMeeting.put("Recurring_Activity",m_Pattern); // // ...; Created on 02 March 2022
14. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... String crmAPIRequest Outputs: output message to user Date Created: 2022-02-11 (JoelLipman.com - Joel Lipman) - Initial release - Checks the user profile ...; Created on 11 February 2022
15. Zoho CRM: searchRecords with sorted results: / Zoho /; ... (CRM, Creator, Books) seems to interpret this sorting feature differently. This article is an effort to find clear and working solutions. It is working again as of 2022-02-10. How? Two methods ...; Created on 10 February 2022
16. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... int p_ItemID (eBay Item ID) Purpose: Fetches a line item transaction per item ID Date Created: 2022-01-22 (Joellipman - Joel Lipman) - Initial release More Info: ...; Created on 22 January 2022
17. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
18. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; What? So this is an article expanding on my article Zoho Deluge - Connect to Xero API and explores how instead of a schedule, we can get Xero to tell ZohoCRM whenever an invoice or contact gets updated ...; Created on 10 January 2022
19. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... Year): Sunday, 2021-03-14 02:00 End Date (Current Year): Sunday, 2021-11-07 02:00 Start Date (Next Year): Sunday, 2022-03-13 02:00 End Date (Next Year): Sunday, 2022-11-06 02:00 Europe: DST ...; Created on 07 December 2021
20. 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