Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; What? A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file ...; Created on 01 March 2023
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. ZohoCRM: ZDK Client Script to retrieve Contact Email: / Zoho /; ... on save of the record, but the client wants the email to be prefilled in the field as soon as a contact is selected. How? This needs to behave like a formula field which changes and displays before ...; Created on 20 July 2022
20. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... All you need to do is send the PDF file to your Kindle email id. It is here that things might begin to seem a bit complicated in that not many might be aware Amazon allots an email address to every Kindle ...; Created on 29 June 2022