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 through is required, the following 141 results were found.

  1. Import Excel CSV file as JavaScript arrayhttps://joellipman.com/component/content/article/import-excel-csv-file-as-javascript-array.html?catid=110&Itemid=165

    the resulting object array How? The function with comments: - Uses deprecated XMLHttpRequest to get file contents - Loops through each row and splits by commas (not within quotes) - Sorts the final array by a object label function...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  2. Passwords: Did-you-knowhttps://joellipman.com/component/content/article/passwords-did-you-know.html?catid=116&Itemid=165

    By default, the Mozilla Firefox browser lists your stored passwords in plain text to anyone with access to your browser through the tools > options > security > Saved passwords > Show All. This includes a feature to search through your saved password...

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
  3. How to run a .RUN filehttps://joellipman.com/component/content/article/how-to-run-a-run-file.html?catid=63&Itemid=165

    I've been told of two ways of running a downloaded .RUN file. Note: Bear in mind that the following is all case-sensitive. Through the terminal server Download the .RUN file to your desktop Open a terminal by going to Application > Accessories >...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  4. Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threadshttps://joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html

    changes to the previous code of connecting to OpenAI ChatGPT but the exception here is that there needs to be code to loop through all the messages of the chat/conversation thread so that we send the OpenAI ChatGPT bot the full conversation thread....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  5. Autohotkey - Chrome Profiles in Alphabetical Orderhttps://joellipman.com/component/content/article/autohotkey-chrome-profiles-in-alphabetical-order.html?catid=48&Itemid=165

    a ListView with rows that can be double-clicked to open the profile. As an overview: Setup a standard AutoHotkey GUI Loop through Google Chrome Profile folders named "Profile 1", "Profile 2", etc. Scan the preferences file for JSON key "name" and...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  6. Terms & Conditionshttps://joellipman.com/component/content/article/terms-conditions.html?catid=50&Itemid=165

    we shall not be liable. It shall be your own responsibility to ensure that any products, services or information available through this website meet your specific requirements. This website contains material which is owned by or licensed to us. This...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  7. Disclaimerhttps://joellipman.com/component/content/article/disclaimer.html?catid=50&Itemid=165

    or damage whatsoever arising from loss of data or profits arising out of, or in connection with, the use of this website. Through this website you are able to link to other websites which are not under the control of Joel Lipman .Com. We have no control...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  8. Joes Bug Tracker (JBT)https://joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=53&Itemid=165

    Style). --- Storage folder for files (can be outside of Joomla! for performance). --- Protect storage folder (only accessed through Joomla!?). --- Integrate JComments/Integrate Facebook Comments (for Product Reviews/Feedback). --- Auto-increment...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  9. Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=53&Itemid=165

    display search areas has been switched off in the admin panel. You should keep this enabled so that the filters are carried through to the next search: Go to Components > Search > Options > set "Use Search Areas" to "Yes" Save & Close Future...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  10. Zoho Deluge - Update Creator from CRMhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-update-creator-from-crm.html

    The code to update a form (sample data for demonstration purposes). Note that the payload here is submitted through URL parameters: v_AccessToken = "123abc456def789abc123def456abc"; v_Criteria = "ID=1234567890123456789"; v_EndPoint =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  11. Zoho Deluge: Duplicate/Clone a Recordhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-duplicate-clone-a-record.html

    of original invoice r_Invoice = zoho.crm.getRecordById("Invoices", p_InvoiceID); // start map m_Clone = Map(); // loop through field names for each v_FieldName in l_FieldApiNames { if(!isNull(r_Invoice.get(v_FieldName))) {...

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

    reminder (do not use): v_SearchName = v_SearchName.replaceAll("([&\'])","\\$1",false); Source(s) Zoho CRM - Get Records through a COQL Query Zoho CRM - Query API - An Overview

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  13. Zoho Creator: Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-expecting-zc-subform-250-expression-found-collection.html

    ); // insert the collection into the subform on the current form input..insert( ); // or insert the row(s) into the subform through the record variable r_LeadDetails = Leads[ID == 1234567890]; r_LeadDetails..insert( ); Events I have used this task which...

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

    knowing anything about nodejs, as long as you know JavaScript and HTML/CSS you can use this: Execute the download and go through the installation process with the final step to move it to trash/bin. Open the terminal app on your Mac and type the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  15. Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-set-up-custom-domain-for-customer-portal.html

    Manager system (website where you registered your domain): Setup your subdomain using the registrar's control panel, go through the process until this part is complete. Find the DNS Manager in your control panel, it might be called something like...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  16. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    l_AllTimeOffs = zoho.people.getRecords("P_ApplyLeave",0,200,l_SearchCriterias); Then we need the code to loop through all these matching records (and approved) and determine if it clashes with the requested dates: for each r_TimeOff in l_AllTimeOffs {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  17. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

    expecting nested arrays (not sure if they were PHP) and it works. Why? This took me several days and in the end only going through various forums and documentation, I found a solution which worked for me. Note that usually I could customize the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  18. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

    // // I can see 2 api names for lookups // userlookup221_2 // Requires_Approval_Users My full snippet of code // // loop through users to find the approver for each m_User in l_Users { if(m_User.get("Job_Title").equalsIgnoreCase("CFO")) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  19. Zoho Deluge: Generate and Send a CSV via Emailhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-and-send-a-csv-via-email.html

    this in Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime = zoho.currenttime; // // loop through dataset for each r_Event in zoho.crm.getRecords("Events", 1, 200, "Year_Month:equals:2021-06") { v_ThisEventTime =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  20. Zoho Creator: Receive JSON via a Shopify Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-json-via-a-shopify-webhook.html

    the webhook, scroll to the end of that row listing your webhook and click on the button Send test notification. It will go through your CRM which will in turn forward the JSON payload to your Zoho Creator record: I'll leave it up to you to parse that...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 61 - 80 of 141