Search - Joel Lipman .Com

1. Quotes: / Category /; Created on 13 March 2020
2. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; What? This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a ...; Created on 26 August 2021
3. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... /imagine and then a space and then type your idea (eg. "fire mage, steampunk victorian, detailed, full body hyperrealistic female" without the quotes to get the left image here). Type /help for other ...; Created on 11 February 2023
4. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... get the quote details given a record ID r_QuoteDetails = zoho.crm.getRecordById("Quotes",p_QuoteID); // // check target email is not null/blank if(!isnull(r_QuoteDetails.get("Email"))) { v_Url ...; Created on 18 August 2022
5. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... if your search query string has spaces in it, the above without the small apostrophes (single-quotes) will return either a parsing error or just no data. In the line: v_GraphQl = " product } } } }" Change ...; Created on 14 February 2022
6. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... = v_HtmlEntityNames.toList(); l_HtmlEntityChars = v_HtmlEntityChars.toList(); // // add these exceptions (quotes) which wouldn't convert to a list l_HtmlEntityNames.add("quo"); l_HtmlEntityNames.add("apos"); l_HtmlEntityChars.add("\""); l_HtmlEntityChars.add("'"); // // ...; Created on 27 January 2022
7. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... e = "My Test Document"; r_DownloadResponse.setFileName(v_Filename + ".pdf"); r_AttachResponse = zoho.crm.attachFile("Quotes",p_QuoteID,r_DownloadResponse); Use a subform (eg. Product Line Items) ...; Created on 21 October 2021
8. Zoho Deluge: Generate List of TimeZones: / Zoho /; ... this quite a bit and wanted a quick way of extracting a SELECT list in someone else's form. How? So, let's copy the HTML select into a text editor, then escape the double-quotes, then prepend with ...; Created on 19 October 2021
9. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... query v_CoqlQuery = "select distinct Currency from Quotes where Subject!=''"; // // build up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // invokeUrl r_Coql ...; Created on 08 October 2021
10. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... have this selectable for users in their transactional modules (quotes, sales orders, invoices, purchase orders), you need to modify each product record (can be done with "Mass Update") to give them the ...; Created on 02 September 2021
11. Zoho CRM: Permission Denied for Quote Conversion Mapping: / Zoho /; ... clicking on "Save") Hover the mouse over "Quotes" and select "Quote Conversion Mapping" Map your fields that you want and click on "Save" Re-click on "Organize Modules" and disable the "Invoices" ...; Created on 02 September 2021
12. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... + v_OwnerName + "/" + v_AppLinkName + "/#Page:OpenQuote?ID=" + v_CreatorQuoteID; v_QuoteRef = ifnull(r_Result.get("Quote_Ref"),"-"); v_QuoteName = ifnull(r_Result.get("Quote_Name"),"-"); v_QuoteStage ...; Created on 30 July 2021
13. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; ... a custom related list on a Zoho Finance > Sales Orders module but it wasn't finding all the Quotes related to this Sales Order. How? The quick answer is buried in Zoho documentation and due to the ...; Created on 29 July 2021
14. Zoho Creator: Add a subform while creating a record: / Zoho /; ... form is called "Quotes" and my subform is called "Line_Items": // initialize variables // ... this is a demo so ... do your own ... // // get source data r_QuoteDetails = zoho.crm.getRecordById("Quotes", ...; Created on 14 July 2021
15. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; ... every month"... How? Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each value with double-quotes because the values might have commas and ...; Created on 16 June 2021
16. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... So there are a few trigger options but I'm listing the one(s) to stop workflows below to see if this helps anyone: Stop Workflows from executing: l_Quotes = List(); l_Quotes.add(m_CreateCrmQuote); m_Data ...; Created on 16 June 2021
17. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; What? This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. ...; Created on 17 May 2021
18. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... using the invokeUrl() function, the odd thing is that Zoho's request adds double-quotes to the request and escapes the other double-quotes sending something like this: { "auth": "", "data": "" } What ...; Created on 03 February 2021
19. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... all the selected (ticked) records. The example below documents a report of Quotes where we want to merge all the product line items of each quote into one single quote. Why? I've written this ...; Created on 06 December 2020
20. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... the double-quotes and no funny characters). It will initialize a project in a folder called something like “/Users//joels_awesome_app” It will then initialize some NPM dependencies and it will ask ...; Created on 24 October 2020