Search - Joel Lipman .Com

21. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... I don't know how to refer to the public URL of a subform row other than making the subform link to an existing form and not a blank form. The document form contains the fields: Ticket (lookup to Ticket ...; Created on 26 January 2024
22. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... module that are calculated and will sometimes return numbers with more than 6 decimal places. As this is more than specified on the ZohoCRM field properties, as soon as the staff user tries to save the ...; Created on 13 December 2023
23. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... for the above demo. Invalid OAuth Scope: Might be an invalid scope, or the TLD (datacenter) is incorrect. The above demo uses the EU datacenter (zoho.eu) rather than the US datacenter (zoho.com). ...; Created on 05 December 2023
24. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... has the scopes as specified in the function header. Also note, that this Zoho instance is in the EU datacenter (zoho.eu) rather than the US datacenter. The most important tweak in order for the below ...; Created on 05 December 2023
25. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... + ")AND(Valid_Till:greater_than:" + encodeUrl("2023-11-01") + "))"; v_Endpoint = "https://www.zohoapis.com/crm/v5/Quotes/actions/count?criteria=" + v_CountCriteria; r_MaximumCount = invokeurl [ ur ...; Created on 14 November 2023
26. Zoho Books: System Values Maps: / Zoho /; What? A collection of code snippets I seem to be regularly using to generate a dynamic map of system values held in a ZohoBooks instance. Why? Rather than hard-coding and having a ton of if..then ...; Created on 07 November 2023
27. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; What? There are other sources on the web which show you how to deduplicate a contact but usually involve entering a customer name or other key to check if there are already records in the system with ...; Created on 12 July 2023
28. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... for anything else than tracking stock...? How? So the quick answer is one missing parameter to send through which is "item_type=inventory"... A little longer, is do ensure you have Zoho Inventory ...; Created on 04 May 2023
29. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... or create. - Loop through eBay payments to record all the different payments received. Date Modified: 2023-03-14 (Joel Lipman) - Resolved fix of incorrect customer (Use Email rather than ...; Created on 27 April 2023
30. 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
31. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... to make a subform equal the collection rather than inserting the collection into the subform using insert(). Invalid update task found corresponding properties: Trying to update a time field with a ...; Created on 28 March 2023
32. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... only use this in another dataset which won't use a sub-query more than 2 levels deep. We're only displaying the maximum value alphabetically found in member status per contact per campaign (should be only ...; Created on 20 March 2023
33. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... (Joel Lipman) - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of invoice. More Information: TEST PAYMENT SCENARIOS WITH PHYSICAL TEST ...; Created on 16 March 2023
34. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... that are in your listing, it will then generate the number of pages it thinks it has to loop, so try and give a number higher than the actual number of products you have in your shop, it will stop when ...; Created on 01 March 2023
35. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... and Zoho is the data to be overwritten, ensuring that Product IDs, Variant IDs, Inventory IDs, Current Selling Price, Inventory Level, and Barcode all match. Our problem is that sometimes more than ...; Created on 20 February 2023
36. ZohoCRM: Import Attachments: / Zoho /; ... Too Small (less than 1Kb)" } if(v_Col04 == "-") { v_Reason := "File not associated to a Zoho CRM Record" } v_CsvLine := v_Col01 "," v_Col02 "," v_Col03 "," v_Col04 "," v_Col0 ...; Created on 16 January 2023
37. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... ed to include those credit notes for refunds, etc. This tweak is if we want to calculate credit notes issued in a particular month rather than the one-to-one with an invoice as profits in the past wou ...; Created on 03 November 2022
38. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; ... return false to prevent saving of record return false; Caveat(s) This only happens if the record is being edited (as in user clicked on "Edit") rather than the inline edits that can be done (eg. ...; Created on 20 July 2022
39. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; What? A quick article on a code snippet to mark a package as shipped and delivered in Zoho Inventory. Why? As usual, any task like this that takes me longer than an hour, I'd like to document ...; Created on 14 July 2022
40. 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