Search - Joel Lipman .Com

1. ZohoBooks: Code 15 Ensure Billing Address has less than 100 characters: / Zoho /; ... these in her estimate template... But I'm sending them anyway. Note(s) The following code accesses APIs on the EU datacenter. I have a connection called "zbooks" which has the necessary scope(s) ...; Created on 18 September 2023
2. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... { r_InvoiceSO = zoho.books.createRecord("invoices",v_BooksOrgID,m_InvoiceDetails,"abzohobooks"); } Note(s): There are 2 other payment terms which is by setting payment terms to 0 whic ...; Created on 06 July 2023
3. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; What? If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait ...; Created on 03 July 2023
4. Zoho CRM: Change System Field Length: / Zoho /; ... but it is a workaround I have used and that worked when converting a lead to a deal. Note that this hack doesn't work on the system field label name (I tried) just on the length field. Use the translations ...; Created on 19 June 2023
5. 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
6. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
7. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... = Map(); l_JsonOrders = List(); // // start preparing CSV file to email for export v_ReportCSV = "Date,Order ID,Status,Amount,Currency,Notes"; l_CsvFileRows = List(); l_CsvFileRows.add(v_ReportCSV); // // ...; Created on 29 March 2023
8. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; What? A quick note here on how to connect to the DHL API and check on a package given a tracking number. Why? In our megafunction to generate a customer, a product/item, a sales order, an invoice, ...; Created on 21 March 2023
9. 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
10. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... invokeurl (note the Zoho endpoint here will depend on your datacenter; .com / .eu) r_Coql = invokeurl [ url :"https://www.zohoapis.eu/crm/v2/coql" type :POST parameters:m_Params.toString() ...; Created on 06 March 2023
11. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... "Fn - eBay - Get Active Products" and give it the internal name as "fn_GetEbayActiveProducts" without any arguments. Something to note in the below is that it asks you to set an estimated number of products ...; Created on 01 March 2023
12. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... that were in practice added to the same function and that worked at time of print. Note that this uses the old Trading API as the new API is only available in Sandbox??? I won't go into how to generate ...; Created on 28 February 2023
13. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... of print, this is the only way I know: add a note field to inject some CSS into it and hide the delete icon as well as the "Add new row" link. In Design mode: Add a special field of type "Add Notes" ...; Created on 28 February 2023
14. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = l_CsvFileRow.toString(); l_CsvFileRows.add(v_CsvRow); // // note the cursor so that we resume from the last cursor v_Cursor = r_Node.get("cursor"); // // ...; Created on 20 February 2023
15. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; What? A quick article on my adaptation of some code posted by Poorvik Palanikumar on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article ...; Created on 13 February 2023
16. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... prompt combining any of the following in a table (this is not an exhaustive / limited list). Do note that the images below were generated using MidJourney v4: Type of Photography Nature Photography ...; Created on 11 February 2023
17. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... // update the record (note the API name being used here) r_Create = zoho.recruit.addRecord("CustomModule6",m_Create,0,false,"jl_recruit"); //info r_Create; } } } } For historica ...; Created on 08 February 2023
18. 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
19. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... // other fields to fill in for this subform row v_RateCardDisp = v_RateCard.indexOf(" (")>0 ? v_RateCard.substring(0, v_RateCard.indexOf(" (")) : v_RateCard; json_Arg.Rate_Change_Notes = v_RateCardDisp; ...; Created on 09 December 2022
20. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... inExclTax", 0)) AS "Credit Margin excl Tax", SUM(if_null(ab2."ItemMarginInclTax", 0)) AS "Credit Margin incl Tax" FROM "My Credit Note Items" ab2 WHERE ab2."Status" IN ( 'Open' , 'Closed' ) GROUP BY ab2."SalesP ...; Created on 03 November 2022