Search - Joel Lipman .Com

1. Zoho Deluge - InvokeConnector and useful snippets: / Zoho /; What? So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode. List CRM Users (ActiveUsers) Note that this is somewhat superseded ...; Created on 23 January 2020
2. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
3. 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
4. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... was not accurate enough... but here's the snippet: r_CommentsHistory = Map(); l_Comments = ifnull(r_CommentsHistory.get("comments"),List()); for each m_Comment in l_Comments { if(m_Comment.get("description").containsIgnoreCase("Purchase ...; Created on 09 July 2024
5. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... is sitting right now. The code snippet to get the item record from the price book Note that I'm using a connection called "zbooks" and it has every permission under the sun (the naughty ZohoBooks.fullaccess.all) ...; Created on 23 May 2024
6. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... = User Acceptance Testing) to ensure this behaves as expected. So I found another function was being run when a contact record is created and I appended this snippet of code to the end of it. Note tha ...; Created on 14 May 2024
7. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... pages but then you hit the PDF button and it pretty much vomits your output back to the 90s. The code snippet below is just for a standard template with a modern design. How? Ok, admittedly, when ...; Created on 07 May 2024
8. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; What? This is an article to show how to setup a scheduled function that checks and restores a missing webhook as well as the snippets when receiving the webhooks and storing them. Why? We found ...; Created on 22 April 2024
9. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... parts but otherwise it is intended to be all in the same function as there are references to some variables in earlier snippets of code on this page. Error(s): 2945: UPLOAD_RULE_NOT_CONFIGURED Was ...; Created on 25 March 2024
10. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... but the revised instructions here should also help. Then lastly, I'll post the snippet of code using in the widget to connect to Zoho based on a parameter passed in the URL that a Zoho Creator Page can ...; Created on 14 March 2024
11. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... API having a few email addresses as the recipients: A sample code snippet: For the below, I have a connection to ZohoBooks from ZohoCreator called "zbooks". It has fullaccess as a scope but I'm sure ...; Created on 07 March 2024
12. 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
13. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... clients set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are. void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID ...; Created on 06 July 2023
14. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; ... agent, HQ, server; we would create a separate table to manage this data. I can't do this for every client, so here's a quick snippet to just check if Daylight Savings are in effect for the United Kingdom. ...; Created on 03 July 2023
15. Zoho Inventory: Enable Tracking using the API: / Zoho /; What? One of these articles because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory: Why? Who uses ZohoInventory ...; Created on 04 May 2023
16. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... I'm storing this here as a reference and taking the bits that I need for the various clients that request an eBay integration. This is a comprehensive snippet which does the whole lot. How? Using ...; Created on 27 April 2023
17. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... invoice and then when it prompts for some code, you give it the snippet below. The Magic You would create a button for each terminal /* ******************************************************************************* Function: ...; Created on 16 March 2023
18. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... function too often either for debugging/monitoring purposes but it's easier to use an access token then getting the OAuth access codes from the client. How? I'm going to split this into 2 code snippets ...; Created on 28 February 2023
19. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... historical records The below snippet is what I used to bring all the past records into the custom module. The client would be able to determine what jobs have started/expired based on their Candidate ...; Created on 08 February 2023
20. ZohoCRM: Import Attachments: / Zoho /; ... of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets ...; Created on 16 January 2023