Search - Joel Lipman .Com

1. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... how to troubleshoot issues with this. One important thing to note is that the setup needs to be done by whoever manages the domain for the client. Who owns the domain (eg. mycompany.com) So this ...; Created on 04 May 2023
2. 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
3. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... on the employee record So now we just need to append the following code which loops through the map / associative array we just created and shove this onto every employee's record. My employee recor ...; Created on 28 March 2023
4. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... specify your DHL API Key (no need for the secret or base64 encoding) v_DHL_API_Key = "1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ"; // // build up header m_Header = Map(); m_Header.put("DHL-API-Key",v_DHL_API_Key); // ...; Created on 21 March 2023
5. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... Pivot" cp ON cp."Contact Id"=c."Id" Caveat(s) You may have noted a few caveats with this solution: This query needs each campaign name specified to see the results per contact person. You can ...; Created on 20 March 2023
6. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... && v_Message!="Ask ChatGPT") { // // Need to add your own OpenAI token here v_Token = "sk-XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"; // // build header of request m_Header = Map(); m_Header.put("Authorization","Bearer ...; Created on 06 March 2023
7. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... in certain cases v_NewLineChar = hextoText("0A"); Thought I needed to add the following but this makes absolutely no difference: f_CSVFile.setCharSet("UTF-8"); f_CSVFile.setFileType("csv"); ...; Created on 01 March 2023
8. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
9. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... the displayed note of "Add your Note here...") input.CSS_Overrides = v_CssNotes; Additional If you don't want to apply this to the every subform on that form, you will need to brush up a little ...; Created on 28 February 2023
10. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... 100 products are modified in a day... We need to be able to do more than 100 or at least resume from a record... We need pagination. How? To resolve this, I'm building on top of my initial GraphQL ...; Created on 20 February 2023
11. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... contains a question mark, send it to OpenAI if(v_Message.contains("?")) { v_Question = v_Message; // // Need to add your own OpenAI token here v_Token = "sk-abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"; // // ...; Created on 13 February 2023
12. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... defaults certain arguments to any prompt you submit. I don't really recommend this unless you're doing a batch of images which need to match the same style and dimensions. To start, type /prefer suffix ...; Created on 11 February 2023
13. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... module which then allows you to link the Candidates to the Job Openings; but my client needed to be able to query this via API and the "Associate" table or whatever it is, was not visible in API... How? ...; Created on 08 February 2023
14. 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
15. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... let v_DealID = r_DealLookup.id; let r_DealDetails = ZDK.Apps.CRM.Deals.fetchById(v_DealID); // get Deal/Opportunity fields we need to refer to var v_OppType = r_DealDetails.Type_of_Opportunity; ...; Created on 09 December 2022
16. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; What? An article on the reasoning and steps to generate a dataset using Zoho's ANSI-SQL queries to generate the margins of each invoice in ZohoBooks. Why? We need to create a profits/losses dashboard ...; Created on 03 November 2022
17. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; ... deals against a deal owner and needed to repeat this for all the invoices against a sales person. It adds to the effect on loading the page that a widget has clearly defined values based on the filters ...; Created on 24 October 2022
18. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... of weeks thereafter). This needs to be dynamic as it is a schedule run daily checking the availability of a staff member for the upcoming week. How? As mentioned, using leftpad takes 2 parameters, ...; Created on 21 October 2022
19. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... CRM record. STEP 1: REGISTER A NEW CLIENT First, you need to register your application with Zoho’s developer console to get your Client ID and Client Secret. (Login as the client super admin or ascentcloud ...; Created on 17 October 2022
20. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... you can parse the multi-line into a nice HTML table. But on a mobile device, it's somewhat better to use the built-in interfaces provided by Zoho Creator. What I really needed was a way to display ...; Created on 18 August 2022