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

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

    Excel along with double-quotes label1,label2 item1a,item2a item1c,"item2c,c" item1b,item2b What I want: To read the file (stored on the server) and convert to a JavaScript array of objects var my_object_array = [ { my_col1_val: 'item1a', my_col2_val:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  2. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    So this is an article for me to store prompts for the MidJourney AI text-2-image discord tool. Why? The results from the MidJourney bot are beyond unpredictable however with the correct prompts you can direct it to focus on the elements you want from a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  3. GDPR Privacy Policyhttps://www.joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  4. 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

    //break; } } } } else if(r_ChatGPTResponse.get("responseCode") == 429) { // store in response text m_Response = {"text":"I dont have any knowledge on this. Consider doing a Google search."}; } } return m_Response;

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  5. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/component/content/article/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html?catid=48&Itemid=165

    The easiest way to do this is to right-click and drag to the desktop (or wherever you want to store shortcuts) then run the shortcut: RunWait, "C:\Users\Joel\Documents\_shortcuts\Mail - Shortcut.lnk" Without a shortcut, the command to run is: RunWait,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  6. AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/component/content/article/autohotkey-get-media-information-and-display.html?catid=48&Itemid=165

    To: Microsoft Windows 7 Professional v6.1.7601 32-bit AutoHotkey v1.1.33.02 What? This is a copied article just to store a permanent reference for if I ever need to build an app similar to the file explorer in the Microsoft Windows OS. Why? I had an app...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  7. Copyrighthttps://www.joellipman.com/component/content/article/copyright.html?catid=50&Itemid=165

    not, except with our express written permission, distribute or commercially exploit the content. Nor may you transmit it or store it in any other website or other form of electronic retrieval system.

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  8. Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=53&Itemid=165

    to retrieve accidentally deleted programs from my backup drives. I downloaded a load of media files (all legitimately :) and stored them in my music folder. I then run my MP3 software to convert all the files into MP3 format and store these in another...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  9. Zoho CRM: APIv2 using PHP & cURLhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-apiv2-using-php-curl.html

    to read data from Zoho CRM and to write data back to the system. Why? I've rewritten this code a few times and want to store the finalized version (following updates) making it as generic as I can in order to apply it to any client. How? Firstly, you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: en-GB
  10. Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-refresh-access-token.html

    tokens generated after will overwrite the oldest one. Access Token This will expire after 1 hour so either you find a way to store the access token for reuse or generate a new one in every request. v_ClientID = "1000.ABCDEFGHIJKLMNOPQRSTUVWXYZ1234";...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  11. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    each field in the displayed order. Method #3: Use an eTag I use to use an eTag for a database-driven system I created to store the record details of properties. It was a quicker way of detecting a change on the record rather than comparing all the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

    the REST API and InvokeURL in Zoho Deluge to look at Zoho Books. This uses up an extra 2 calls so you could run them once, store them as a map on your function if you don't want to use up these 2 every time your sales team push a CRM Sales Order to Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  13. Zoho Creator / eBay: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-all-active-products.html

    to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve a list of all the listed active products in a fixed price item listing. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  14. Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-calculating-with-timezone-offset.html

    in real-time making it really difficult to extract and use. The key trick I used was to actually use a single-line text to store the customer's requested time. Let's use the appointment example mentioned above for a customer in UTC+1 @ 4pm their time....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  15. Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

    Note(s): This has not been tested extensively. Do not use if you are unsure it is calculating correctly. I use these to store the values in a table that can be double-checked at a later date. Source(s): Joel Lipman: Zoho Deluge: Generate List of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  16. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/else/e-commerce/ebay/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    + v_BooksOrgID + ""; r_File = invokeurl [ url :v_Url type :GET connection:"joel_zoho" ]; r_File.setParamName("file"); // // store this file in the field "Creator File" input.Creator_File = r_File; // // use publish key of the report v_PublishKey =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Ebay
    • Language: *
  17. Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-all-orders-from-ebay.html

    in l_AddPages { l_Pages.add(v_Increment + 1); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonOrders = List(); // // start preparing CSV file to email...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  18. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    scopes to do everything under the sun Setup a function that generates an access token of the Trading API for the eBay store /* Function: fn_eBay_GetOrderInfoCreateUpdateZohoSO(string p_eBayOrderRef) Purpose: Queries eBay for information about an order...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  19. Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

    info dateValue.toString("YYYY"); // returns 2020 You should also pad single digit week numbers if we're going to store a year week value: v_ThisCurrentWeekNumber = if(zoho.currentdate.toString("u").toLong() ==...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  20. Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-generate-bank-text-file-for-download.html

    it to the staff member's workstation. Why? Why is this a challenge? The file contains bank details and should not be stored anywhere. Generating a text or CSV file and then having it emailed to anyone is an easy task but here we cannot have that file...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
Results 21 - 40 of 58