Search - Joel Lipman .Com

1. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... = v_Counter + 1; } info "Statement execution limit is 50000"; Additional Note(s): Observation #1: Method Chaining: Contrary to my previously held belief, method-chaining still counted as separate ...; Created on 31 July 2024
2. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; What? A quick article on how to get the pricebook entry using Zoho Deluge for a specific product in your ZohoBooks or ZohoInventory instance. Why? This took me the best part of an hour to determine ...; Created on 23 May 2024
3. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... within ZohoBooks, we know this is just 1 bill record, still... for each r_Bill in bills { v_BillID = r_Bill.get("bill_id"); } // // send attachment request r_Attachment = invokeurl [ url: "https://www.zohoapis.com/books/v3/bills/" ...; Created on 02 October 2023
4. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... Email - Possibly still an issue with delayed payment (check this is not holding status) Date Modified: 2023-03-17 (Joel Lipman) - Enhanced debug messages as function not auto-triggering ...; Created on 27 April 2023
5. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... CancelPending, Completed, Inactive, InProcess v_OrderStatus = "All"; // // calculate from and till v_OrdersFrom = v_Year + "-01-01T00:00:00.000Z"; v_OrdersTill = v_Year + "-12-31T23:59:59.000Z"; // // ...; Created on 29 March 2023
6. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... ze the connection between CRM and ZIA: Click on ChatGPT CRM Click on Reuse Test on keeping conversation context: Still to do: Need to train it on ZohoCRM data with statistics and datase ...; Created on 06 March 2023
7. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Product Photography Real Estate Photography Still Life Photography Tech Photography Camera Angle Note that there others, I'm only listing ones that actually followed the prompt (eg. ...; Created on 11 February 2023
8. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... about 6 hours to 2 days to take effect. Not sure what was supposed to happen but 2 days later it still wasn't working. I followed the process above and it took immediate effect... Update 2024 So ...; Created on 07 April 2022
9. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... one image from Zoho Inventory. I'll need to add to the code to retrieve the other photos from Zoho Inventory Still to run a few tests but if I'm right in my guesses, if you edit the listing in eBay's interface, ...; Created on 31 March 2022
10. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... to "iGPU Multi-Monitor" and set to "Enabled". Exit > Save and Restart Still no luck... I know the pain. Go and have a cup of tea/coffee. Then let's work on that Windows OS: Login to your Windows ...; Created on 12 March 2022
11. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... = v_PreselectedValue; // // hide (comment this out if you are still debugging) hide Hidden_Fields; Then we need a workflow/trigger that runs whenever a user clicks on one of these date boxes (On ...; Created on 09 March 2022
12. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... Why? There were several alternatives we considered beforehand which still didn't fit the requirement: A client's first-line agents would have a lead record with the status "New Lead". The client ...; Created on 11 February 2022
13. 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
14. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... (with different v_Webhook_Key). If it still doesn't work then try solution #2: using a third-party server detailed further in this article. Solution #2: Using Third-Party Server If this doesn't work ...; Created on 10 January 2022
15. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... few days which needs to dynamically change. I am aware of the function .addBusinessDay() but that excludes Saturdays which my client still works on. How? We're going to get today's date, then use ...; Created on 02 November 2021
16. Zoho Creator: Change Radio into Tabs: / Zoho /; ... + ".zc-Tabs-group .choice-table-row"; v_Css = v_Css + ""; input.Note_CSS = v_Css; Yields Then I need to get rid of the circles (radio inputs) but ensure the labels are still visible (I can ...; Created on 22 October 2021
17. Zoho CRM: Upload a Product Photo using Deluge: / Zoho /; What? A quick article to remind me on how to upload a photo using CRM API v2. Yes it's documented and yes it still confuses me now and again. So I'm writing this to remind me and to keep reminding me ...; Created on 27 September 2021
18. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... :zoho.adminuserid to :"This email address is being protected from spambots. You need JavaScript enabled to view it." subject :"TEST ebay Webhook Notification" message :m_Payload ] */ return r_CreateRecord; Save the function While still on the CRM functions page, ...; Created on 20 September 2021
19. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... any other fields I would add the code: if(input.Update_Preview) { input.Audit_Change = "Title: " + zoho.encryption.md5(input.Title); } This still causes endless loops in certain cases because ...; Created on 19 September 2021
20. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... API v1 is deprecated (so no authtokens) and API OAuth2.0 is in full swing... we're still going to cheat. How? 1,2,3 steps really. First we're going to set up a Creator form to receive the JSON. ...; Created on 15 July 2021