Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 = List(); v_QuoteRefID = "0"; v_CrmOppID = "0"; v_OwnerName = ; v_AppLinkName = ; v_FormLinkName = ; v_ViewLinkName = ; if(!isnull(salesorder.get("salesorder_id"))) { v_CreatorSoID = salesorder.get("salesorder_id"); } v_SearchCriteria =...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 = invokeurl [ url :v_TokenEndpoint type :POST parameters:m_Params headers:m_Headers ]; //info r_eBayResponse; if(!isnull(r_eBayResponse.get("access_token"))) { // info "New Token Generated"; r_Api.Access_Token=r_eBayResponse.get("access_token");...

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

Zoho Creator / Shopify: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

12 October 2021 invokeurl [ url :v_Endpoint type :GET headers:m_Header ]; for each r_ShopifyProduct in r_GetProducts.get("products") { if(!isnull(r_ShopifyProduct.get("id"))) { l_ProductIDs.add(r_ShopifyProduct.get("id")); } } l_ProductIDs.sort(); v_LastID =...

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

Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

21 October 2021 "pdf", r_ContactRecord.get("Email"), m_MergedData, "joels_connector"); if(!isNull(r_SendResponse.get("records"))) { v_Grammar = if(r_SendResponse.get("records").size()==1,"","s"); v_OutputMessage = v_OutputMessage + "Generated and sent " +...

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

Zoho Creator: Change Radio into Tabshttps://joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 Tab_Section_2; hide Tab_Section_3; hide Tab_Section_4; hide Tab_Section_5; hide Tab_Section_6; hide Tab_Section_7; // if(isNull(input.Tabs) || input.Tabs == "Quote") { show Tab_Section_1; } else if(input.Tabs == "Product Details") { show Tab_Section_2;...

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

Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 to most recent) r_SearchResults = zoho.books.getRecords("customerpayments",v_BooksOrgID,m_SearchCriteria,"zbooks"); if(!isnull(r_SearchResults.get("customerpayments"))) { l_SearchResults = r_SearchResults.get("customerpayments"); for each r_Result in...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 + "\""; } v_Shopify_Created = v_ProductCreated.getPrefix("Z").replaceAll("T"," "); v_Shopify_PublishedStr = if(!isNull(v_ProductPublished),v_ProductPublished,v_Shopify_Created); v_Shopify_Published =...

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

ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

27 April 2023 url :"https://books.zoho.eu/api/v3/settings/taxes?organization_id=" + v_BooksOrgID type :GET connection:"joel_books" ]; if(!isnull(r_Taxes.get("taxes"))) { for each r_Tax in r_Taxes.get("taxes") {...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 = 0; v_TotalCategories = r_Categories.toJSONList().size(); for each m_Category in r_Categories.toJSONList() { if(!isNull(m_Category.get("count"))) { v_TotalProducts = v_TotalProducts + m_Category.get("count"); } } info v_TotalProducts + " in " +...

• 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 + ";}"; v_CssStyle = v_CssStyle + ""; input.Note_ColorPicker_Css = v_CssStyle; Code for On User Input of Color Picker: if(!isNull(input.Color_Picker) && !input.Color_Picker.contains("button")) { v_HeximalRef =...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 :GET connection:"zcrm" ]; l_DealData = ifnull(r_RecordDetails.get("data"),List()); for each m_DealData in l_DealData { if(!isNull(m_DealData.get("id"))) { r_DealDetails = m_DealData; if(!isNull(r_DealDetails.get("Pipeline"))) { v_Pipeline =...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 values from 'arguments' passed in the javascript code m_Arguments = ifnull(m_RequestParams.get("arguments"), Map()); // if(!isNull(m_Arguments.get("p_AccountID"))) { v_AccountID = m_Arguments.get("p_AccountID").toString(); v_Output = "Info: Recognized...

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

Cheat Sheet for mySQL vs t-SQLhttps://joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 ) IIF( expression,value_if_true,value_if_false ) If Null IFNULL(column_name,value_if_null) ISNULL(column_name,value_if_null) Rank/Rownum (@rownum:=@rownum+1) AS Rownum LIMIT from_index, number_of_rows ROW_NUMBER() OVER(ORDER BY column_name ASC) AS...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 value doesn't exceed the column size p.SetValue(Row, ValueToConvert, null); } } catch (Exception e) { // Only handle ColumnIsNull and NullReference Exceptions if (e.GetBaseException() is Microsoft.SqlServer.Dts.Pipeline.ColumnIsNullException ||...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

10 March 2020 v_OldKey = v_OldInvoiceItemID + "|" + v_OldInvoiceLineItemQuantity + "|" + v_OldInvoiceItemRate; if(!isnull(m_NewLineItems.get(v_OldKey))) { m_LineItem.put("salesorder_item_id",m_NewLineItems.get(v_OldKey)); } l_UpdateLineItems.add(m_LineItem); } // //...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 records (and approved) and determine if it clashes with the requested dates: for each r_TimeOff in l_AllTimeOffs { if(!isnull(r_TimeOff.get("Employee_ID"))) { v_ThisStatus = r_TimeOff.get("ApprovalStatus"); v_ThisFrom = r_TimeOff.get("From").toDate();...

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

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

29 January 2021 // for each r_Record in l_MyListUnsorted { // field we want to sort by v_SortingKey = ifnull(r_Record.get("date"),""); if(!isNull(v_SortingKey)) { // as this is a date from CRM (atomic date format), arrange so it can be sorted alphabetically in reverse...

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

Zoho Creator: Add a subform while creating a recordhttps://joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

14 July 2021 // // transform variables for main record v_QuoteName = ifnull(r_QuoteDetails.get("Name"),"Test Quote"); if(!isNull(r_QuoteDetails.get("Contact_Name"))) { r_ContactDetails = zoho.crm.getRecordById("Contacts",...

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

Zoho CRM & Zoho Books: Get SalesPersonshttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-salespersons.html

30 August 2021 r_SoDetails = zoho.crm.getRecordById("Sales_Orders",p_SoID); // // check if owner and get matching salesperson ID if(!isnull(r_SoDetails.get("Owner"))) { v_OwnerID = r_SoDetails.get("Owner").get("id"); v_Filter = "crm_reference_id=" + v_OwnerID;...

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

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 // output response info r_CreateSO; // read response if(!isnull(r_CreateSO.get("salesorder"))) { v_SalesOrderID = r_CreateSO.get("salesorder").get("salesorder_id"); // v_AddressIndex = 0; m_ShippingAddress = Map(); // set field api names that we will...

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