Search - Joel Lipman .Com

1. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; ... hitting statement execution limits and rather than proposing an upgrade or add-on to the subscription plan; we wanted some proof using code. How? We're going to use a quick snippet of some code. ...; Created on 31 July 2024
2. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... for a customer who simply wanted a quote template to be rendered for PDF or print format. I have another article for a different client who wants a pretty advanced HTML template (well it's a HTML table ...; Created on 07 May 2024
3. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... true which will automatically send it and mark it as sent. As the function I use before this to generate the invoice, also updates an invoice, I wanted to keep the action of sending separate so that staff ...; Created on 07 March 2024
4. Zoho CRM: Client Script Confirmation Box and Popup Mailer: / Zoho /; ... with the to email address, bcc, subject and message content already populated. How? The example from the Kaizen series uses a record with canvas mode applied; but I wanted to try it without a ...; Created on 06 February 2024
5. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... zoho.creator.createRecord() and wanted to update the first name of a name field but I was getting the following error: { "code": 2945, "description": "EXTRA_KEY_FOUND_IN_JSON" } How? So the ...; Created on 04 October 2023
6. Zoho CRM: Change System Field Length: / Zoho /; What? This is an article documenting how to remove the block on changes to a system field in ZohoCRM. Why? Our use-case today is that a customer wanted to map the Postal Code or Zip from a Lead ...; Created on 19 June 2023
7. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; What? A very quick article of a quick solution but at least a working example of an ANSI-SQL (ZohoSQL) query pivoting campaign results vs contacts. Why? Simply the client wanted a report on customers ...; Created on 20 March 2023
8. Zoho CRM: Manage a subform using Client Script: / Zoho /; What? This is an article with a snippet of code demonstrating how to manage a subform using a Zoho CRM Client Script. Why? A client wanted an automation on-the-fly that when selecting a specific ...; Created on 09 December 2022
9. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... Payment Method, Payment Date, and Last Four Digits. They needed these because sometimes their customers needed to know what card they had paid with (if paid by card). The customer wanted payment method ...; Created on 17 August 2022
10. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; What? This is an article taken from https://goodereader.com/blog/kindle/here-is-how-you-can-read-pdf-files-on-the-amazon-kindle which I wanted to take note of as it is a process that worked at time of ...; Created on 29 June 2022
11. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... the tab and went to the SSL/TLS page in CPanel and clicked on "Generate, view, upload, or delete your private keys". Clicked on "Edit" alongside the domain name I wanted to install this SSL for. Copied ...; Created on 07 April 2022
12. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... fans (3 x 3-packs) but left the 2 fans included with the AIO because 7 of the fans would be on the Coolmoon controller hub and I wanted some color (not a lot, not even Storm trooper) amongst the white. ...; Created on 12 March 2022
13. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... wanted that if the status had changed to something else, the first-line agent would not be allowed to set it back to "New Lead". Automations and workflows could however (run as Administrators). Mapping ...; Created on 11 February 2022
14. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... Deluge - Some Useful Regular Expressions list but I felt this deserved its own article. Why? A client wanted the discount displayed on a template and if they gave 10% discount, it would display ...; Created on 08 February 2022
15. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... the header section) but then they changed address and couldn't change the template. So they had something like: $ $ $ $ $ 11 My Street, My City, My State, My Zip, My Country They wanted to get ...; Created on 25 January 2022
16. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; What? I already have an article documenting Pushing a value to a datetime field in CRM but wanted another article here to remind me of the Deluge code I need to add/subtract time. Why? Just want ...; Created on 11 November 2021
17. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... this quite a bit and wanted a quick way of extracting a SELECT list in someone else's form. How? So, let's copy the HTML select into a text editor, then escape the double-quotes, then prepend with ...; Created on 19 October 2021
18. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... Well eBay returns URLs to images that have been resized to 400x400 (even with tweak to return 800x800). I wanted a way to upload my image directly to Shopify in 3024x3024 resolution (or the size that ...; Created on 17 October 2021
19. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
20. Zoho Creator / Shopify: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's Shopify. Why? The use-case was that I wanted to search ...; Created on 12 October 2021