Zoho Creator: isBlank and isNull: Before or After?https://www.joellipman.com/articles/crm/zoho/zoho-creator/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 Creator
• Language: *

ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 v_XeroAddressAttn = m_XeroAddress.get("AttentionTo"); } } // l_AddressStreet = List({v_XeroAddressLine1}); if(!isBlank(v_XeroAddressLine2)) { l_AddressStreet.add(v_XeroAddressLine2); } m_CrmAccount.put("Billing_Street",l_AddressStreet.toString(", "));...

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

ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

13 October 2025 v_XeroAddressAttn = m_XeroAddress.get("AttentionTo"); } } // l_AddressStreet = List({v_XeroAddressLine1}); if(!isBlank(v_XeroAddressLine2)) { l_AddressStreet.add(v_XeroAddressLine2); } m_CrmAccount.put("Billing_Street",l_AddressStreet.toString(", "));...

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

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/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 Deluge
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/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 CRM
• Language: *

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/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 Books
• Language: *

Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threadshttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html

06 March 2023 l_Messages.add(m_Message); } } // // if the message contains a question mark, send it to OpenAI if(!isBlank(v_Message)) { v_Question = v_Message; // // Need to add openAI token v_Token = "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"; // // build...

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

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 has no effect on .toTime() v_ZohoTZ = v_XeroTime.replaceAll(v_RegexPattern,"$2",false); info v_ZohoTZ; v_ZohoTimeZone = if(isBlank(v_ZohoTZ), zoho.currenttime.toString("Z"), v_ZohoTZ); info v_ZohoTimeZone; v_ZohoTime =...

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

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-other/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 Other
• Language: *

Zoho Creator: Get Images in Report to be Exported to PDFhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/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 Creator
• Language: *

Zoho Workdrive: Getting Team Folder IDhttps://www.joellipman.com/articles/crm/zoho/zoho-workdrive/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 Workdrive
• Language: *

Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/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 Creator
• Language: *