Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 == 1234567890]; // // for image field type v_PhotoFull = ifnull(c_Document.My_Photo,""); v_PhotoWithExt = v_PhotoFull.getSuffix("/image/").getPrefix("\""); v_PhotoFileExtension = v_PhotoWithExt.subString(v_PhotoWithExt.lastIndexOf(".") +...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 (China),... v_TLD = "eu"; // my creator form f_MyImages = MyImages[Name == "Logo"]; v_Filename = f_MyImages.MyImage.getSuffix("/image/").getPrefix("\""); // specify publish key of published report (not the form) v_PublishKey =...

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

Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-sort-a-map-by-a-specific-field.html

29 January 2021 in reverse order v_DatePart = v_SortingKey.getPrefix("T").toDate().toString("yyyy-MM-dd"); v_TimePart = v_SortingKey.getSuffix("T").getPrefix("+").subString(0,5); v_SqlDateTime = v_DatePart + " " + v_TimePart; l_SortingKeys.add(v_SqlDateTime);...

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

ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-stripe-terminal-integration.html

16 March 2023 != null) { v_ChargeDescription = ifnull(m_Data.get("description"),""); v_ZB_InvoiceID = v_ChargeDescription.getSuffix("ID: "); v_ZB_InvoiceID = if(isNumber(v_ZB_InvoiceID),v_ZB_InvoiceID,0).toLong(); } } // // create payment record if(v_ZB_InvoiceID !=...

• Type: Article
• Author: Joel Lipman
• Category: Zoho Books
• 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 = v_CountImages + 1; v_ImageHtml = ifnull(c_ImageRow.Image,""); 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...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 photo c_Product = Products[ID == c_Quote.Product]; if(c_Product.count() > 0) { v_ProductPhotoFile = c_Model.Product.getSuffix("http").getPrefix("\"").getSuffix("/image/"); v_ProductPhotoURL = "https://creatorexport.zoho.com/file" + zoho.appuri +...

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

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

14 October 2024 Picker: if(!isNull(input.Color_Picker) && !input.Color_Picker.contains("button")) { v_HeximalRef = input.Color_Picker.getsuffix("background-color:").getprefix(";"); input.Hexadecimal = v_HeximalRef; // optional function here but used in my real-world...

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

Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

01 October 2025 v_WebhookBodyDecode = zoho.encryption.urlDecode(v_WebhookBody); v_WebhookBodyString = v_WebhookBodyDecode.getSuffix("Survey="); m_SurveyBody = v_WebhookBodyString.toMap(); // // find contact by email v_CrmContactID = ""; l_SearchContacts =...

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