Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming initialize is required, the following 40 results were found.

  1. 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

    new key" Copy & paste into a text editor for use in the code below Edit the Message Handler code ChatGTP 3.5 Turbo // // initialize m_Response = Map(); l_Messages = List(); v_Message = message.trim(); // // if the message contains a question mark, send...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  2. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    key. Give the project a name: eg. “joels_awesome_app” (without 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. 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

    { l_FileRows = v_FileContent.toList("\n"); } // loop through each row for each r_Data in l_FileRows { // initialize record m_Record = Map(); m_Record.put("EmployeeID",""); m_Record.put("Name",""); m_Record.put("Address","");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  4. Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

    2022 But if I were to maintain the idea above and skip a selected day, I would write something like the following: // // initialize list to hold valid appointment dates l_AppointmentDates = List(); // // initialize Start Date v_GivenDate = '2022-07-21';...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  5. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-real-time-invoices-receive-webhook.html

    // // receive parameter crmAPIRequest (of datatype string in your function) m_Payload = crmAPIRequest; // // initialize response variable m_Response = Map(); // // get xero signature v_XeroSignature = "SIGNATURE_FAIL";...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-integrate-chatgpt-to-zohozia.html

    Handler Function" We're going to use the following deluge code for our first pass at this awesome functionality: // // initialize v_Response = previousParam; m_Response = Map(); m_Response.put("todo","prompt"); l_Messages = List(); // // capture latest...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-error-code-2945-extra_key_found_in_json.html

    you get the above error; I'm just saying this what I was doing and this is what fixed it when I ran into this error: // initialize m_QuoteRecord = Map(); // // build quote request m_QuoteRecord.put("Name.first_name",v_SellerName_Firstname);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  8. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-updating-a-crm-record-using-api-v7.html

    Any information that may help ******************************************************************************* */ // // initialize m_UpdateQuote = Map(); // // get quote details v_Endpoint = "https://www.zohoapis.com/crm/v7/Quotes/" + p_QuoteID;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-getrelatedrecords-invalid_data.html

    View ID: 123456000012345678 ******************************************************************************* */ // // initialize v_CountTotal = 0; v_CountUpdated = 0; l_Pages = {1}; v_PerPage = 1; // for each v_Page in l_Pages { l_Deals =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    undefined) { a_QuotedItems = JSON.parse("[" + o_ParsedQuote._details.statusMessage.details.output + "]"); } } } } // re-initialize var a_NewSuformRows = []; // if final balance, then include the line items from the quote / if deposit, then don't include...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. 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

    // // -------------------------------- Invoice Customer -------------------------------- // // initialize v_CrmAccountID = ""; v_CrmContactID = ""; v_CrmPhone = ""; v_CrmMobile = ""; b_CreateAccount = true; b_CreateContact = true; // // set date/time of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. 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

    // // -------------------------------- Quote Customer -------------------------------- // // initialize v_CrmAccountID = ""; v_CrmContactID = ""; v_CrmPhone = ""; v_CrmMobile = ""; b_CreateAccount = true; b_CreateContact = true; // // set date/time of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. 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

    to get organization level messages. But in ths example below, we're going to query a message to the ChatGPT bot: // // initialize m_Response = Map(); v_Message = message.trim(); v_ChatID = ifnull(chat.getJSON("id"),0); // // get conversations from last...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  14. Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/component/content/article/basic-webpage-controls-with-javascript-com.html?catid=48&Itemid=165

    ; Make the IE object visible pwb.Navigate( "www.AutoHotkey.com" ) ; Navigate to a webpage Code: ; AHK Basic: COM_Init() ; Initialize COM pwb := COM_CreateObject( "InternetExplorer.Application" ) ; Create an IE object COM_Invoke( pwb, "Visible", True ) ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  15. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    Deluge Code - Uses the EU datacenter Note that using this method, you don't have to escape parentheses characters (): // initialize v_MatchedCount = 0; v_MatchedAccountID = 0; v_SearchName = "Father & Sons (Incorporated)"; // // replace apostrophes with...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  16. 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

    Build up a map with sample data (you won't need to this, use your own data, this one is for this demonstration only) Initialize a list to hold the keys which we will use to sort in ascending/descending order and a map created to hold all the records....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-add-a-subform-while-creating-a-record.html

    and to make it clearer). In the below example, my 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",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  18. Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-crm-zoho-books-custom-related-lists-deluge.html

    that I tend to use regularly for my benefit later on when I simply copy & paste the below code templates. Zoho CRM // // initialize v_Index = 0; // // search in Creator v_OwnerName = ; v_AppLinkName = ; v_FormLinkName = ; v_ViewLinkName = ; v_Condition...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  19. 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

    webhooks (1 to download each photo and base64 encode it but no extras to upload it in addition to the product update): // initialize m_Product = Map(); b_CreateProduct = true; // // I have a field called Shopify Product ID which stores the... um......

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  20. Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-a-html-entity-decoder.html

    but you can call it whatever you like): string DataCleansing.fn_DecodeHtmlEntities( string p_StringToDecode ) { // initialize v_StringToDecode = ifnull(p_StringToDecode,""); // // map string replacements m_HtmlEntity = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 1 - 20 of 40