Zoho Creator: isBlank and isNull: Before or After?https://joellipman.com/articles/crm/zoho/zoho-creator-isblank-and-isnull-before-or-after.html

10 February 2025 A really quick article to test when to use isNull and isBlank. Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {......

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 // // read and process CSV file v_FileContent = f_CSVfile.getFileContent(); l_FileRows = List(); if(!isBlank(v_FileContent)) { l_FileRows = v_FileContent.toList("\n"); } // loop through each row for each r_Data in l_FileRows { // initialize record...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 l_Messages.add(m_Thread); // // if the message is not blank nor the trigger, send to OpenAI ChatGPT API if(!isBlank(v_Message) && v_Message!="Ask ChatGPT") { // // Need to add your own OpenAI token here v_Token =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 if(c_ThisCustomer.count() > 0) { v_CustomerName = c_ThisCustomer.Customer; if(!c_ThisCustomer.ZohoBooks_Customer_ID.isBlank()) { v_ZB_CustomerID = c_ThisCustomer.ZohoBooks_Customer_ID; } } if(c_ThisOrder.count() > 0) { // // get invoice details...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 m_Message.put("content",v_Content); l_Messages.add(m_Message); } } // // if the message is not blank, send it to OpenAI if(!isBlank(v_Message)) { v_Question = v_Message; // // Need to add openAI token here v_Token =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Get Images in Report to be Exported to PDFhttps://joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 if(v_ImageHtml.contains("\"")) { v_ImageSrc = v_ImageHtml.getSuffix("\""); v_ImageSrc = v_ImageSrc.getPrefix("\""); if(!isBlank(v_ImageSrc)) { // use a try...catch as some file types may cause this to partially fail try { v_CountNew = v_CountNew + 1;...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Workdrive: Getting Team Folder IDhttps://joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

11 September 2024 he who shall not be named, Re: " + v_Subject + " Please find attached the CSV export file containing the Data. "; // if(!isBlank(v_PermaLink)) { v_Message = v_Message + " The export file has been uploaded to the workdrive. The direct link to the file is...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Input Color Pickerhttps://joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 // // default to black on blank form, if loading an existing record, the value stored will be used. v_DefaultColor = if(isBlank(input.Hexadecimal), "#000000", input.Hexadecimal); // // a color palette l_ColorPalette = List();...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *