Search - Joel Lipman .Com

1. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... Y EVENT" message :v_DebugMessage ] } return ""; Related List for Custom Module Just for good measure (and because it took me an hour to write this), here's the code to generate a related li ...; Created on 06 August 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. ZohoCRM: Import Attachments: / Zoho /; ... Our use-case here is a data migration for a client from a legacy CRM to ZohoCRM. They have a lot of files they want attached to their respective records in CRM. This took me a while as our own documentation ...; Created on 16 January 2023
4. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... in Zoho Analytics as we can't control the out-of-the-box PNL report that comes with Zoho Books. We needed a dataset that took into account "Delivery" as a separate line item on the purchase order. I' ...; Created on 03 November 2022
5. 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
6. 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
7. 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
8. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... It took me a while of playing about with the placeholder reference fields in the template before Zoho advised on a 'hidden' away setting which was key to changing what these display. What I had: $ $ $ $ ...; Created on 07 October 2021
9. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; What? This is an article to hopefully resolve for you quicker than it took me, why a zoho.crm.searchRecords() returns some of the records but omits others. Why? The use-case was that we were creating ...; Created on 29 July 2021
10. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... but I have since sent something similar to an API expecting nested arrays (not sure if they were PHP) and it works. Why? This took me several days and in the end only going through various forums ...; Created on 03 February 2021
11. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... Why? I've written this article as it took a while to achieve. The Zoho People application and its API are documented but there are problems with the documentation at the time that this article was ...; Created on 10 December 2020
12. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... the domain joellipman.com. Why? This took me a bit of going backwards and forwards to Zoho rather than getting my client to do this. The aim is to take up as little time as possible of the third-parties ...; Created on 17 November 2020
13. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... data. And yes, the part that took me about 8 hours and the key point above is to replace the ampersand with its unicode equivalent. I consider myself familiar with Transact-SQL, Oracle PL/SQL and ...; Created on 28 August 2020
14. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... took me so long to find out how to do this even after reading the official documentation and going through the online discussion forums to build this solution. As of May 2020, this is how I do it. ...; Created on 15 May 2020
15. Zoho Deluge: Associate/Link an Invoice to a Sales Order: / Zoho /; ... DuckDuckGo (can't say for Bing, I never get around to searching that). This took several hours but it is possible, I was just about to give up even after having spoken to Zoho Support... And then I started ...; Created on 10 March 2020
16. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; ... vendor, etc. Why? This took me the best part of a month to get working. It is taken from Google's documentation as well as other forums and websites that try to explain it. Do not waste your time ...; Created on 02 February 2019
17. Zoho Deluge: Loop through 30 Minute Slots: / Zoho /; What? This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill ...; Created on 30 November 2018
18. Google Authentication - OAuth 2.0 using PHP/cURL: / Google /; ... Account in PHP/JWT documenting a script which accesses a Google Drive using a Service Account (unattended). Why? This is a big cop-out as I simply took someone else's functions and upgraded them ...; Created on 31 October 2018
19. Android: Keytool and Google Maps displaying grey: / AndroidOS /; ... maps to myself (again). Why? This took me a while to figure out so hopefully this will help others. How? The gist is that I was using the Test SHA1 when adding allowed Android Keys to the ...; Created on 31 October 2014
20. MySQL Updating a database table from another table: / MySQL /; ... all use the ccTLD two letter code. This article was written because it took me so long to work it out. How? UPDATE `table_to_update` a INNER JOIN `table_to_read` b ON a.`CountryName` ...; Created on 22 October 2014