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

  1. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-real-time-invoices-receive-webhook.html

    in Xero. [Optional for Method #2] Setup a PHP script on a server that will validate the Xero webhook. You're going to need to respond to Xero with valid and invalid HTTP statuses as their webhook validation process is a little stricter than Zoho's....

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

    // // if the message contains a question mark, send it to OpenAI if(v_Message.contains("?")) { v_Question = v_Message; // // Need to add your own OpenAI token here v_Token = "sk-abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"; // //...

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

    message is not blank nor the trigger, send to OpenAI ChatGPT API if(!isBlank(v_Message) && v_Message!="Ask ChatGPT") { // // Need to add your own OpenAI token here v_Token = "sk-XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"; // // build header of...

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

    hopes that your browser will just begin downloading it (failing this it will open up in the browser and staff member will need to be instructed on how to 'File > Save As...'): // // if successful if(r_Attachment.get("code") == 0) { l_DocumentResponse =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  5. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zcrm-client-script-correct-decimal-fields-onload.html

    overhead, especially if it can be auto-corrected with a client script. Pre-amble For both of the methods below, you will need to setup a client script which runs when the product page is being modified: Login to ZohoCRM as a system administrator Give it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    it's the right tool for the job is a different issue), let us synchronize Zoho Surveys into Zoho Analytics. I found I need to edit the setup of the sync every time a new survey is added... but at least it lets me synchronize every hour. Then I'll write...

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

    v_TenantID = ifnull(r_TokenDetails.get("Tenant_ID"),""); // // get access token (does not need REST API url as we're calling it from within CRM) v_AccessToken = standalone.fn_API_GetXeroAccessToken(); // // do Xero stuff if(v_AccessToken != "" &&...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. Basic Oracle Function Structurehttps://www.joellipman.com/articles/else/database/oracle-pl-sql/basic-oracle-function-structure.html

    I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function in it's simplest form and if I want to torture my successors,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Oracle PL/SQL
    • Language: en-GB
  9. 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

    and good, but this forgets what you were talking about after each chat. So it's good for 1 question and 1 answer. What we need is to train it a little a bit like the standard OpenAI Chat website does in terms of context. How? Just a few changes to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  10. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    Not Used Case Fans 2 fans from the 3rd pack of the CoolMoon 120mm Crystal - - The Result: Monitor cable connections I need to practice what I preach: "it's a poor workman who blames his tools". Let's make do with what we have. The 2 Acer monitors only...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  11. Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=53&Itemid=165

    will NOT generate thumbnails if you select "Public" as the authorized service group. I know it's the default option but you need to select an user group with higher privileges like "Super User". Installation: Install this module ZIP using your Joomla!...

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

    Console Create a Zoho Client ID Either use self-client for a code or use the below to generate one. Code Here you will need your own client ID and client secret generated from the developer console in the following snippet: v_ClientID =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  13. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    this is how I do it. How? So the trick is, go over the official documentation, but don't take it as gospel. You only really need the syntax for attaching a document to a Sales Order in Books and the documentation leaves certain bits out. Just getting...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  14. Zoho Deluge: Zoho Bookings Get Available Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-zoho-bookings-get-available-slots.html

    v_CountNight = v_CountNight + 1; v_CountTotal = v_CountTotal + 1; } } } } Done. Notes: You need the workspaces to get the services. You need the services to get the staff. You need the staff and service to get the available slots. Source(s): Get...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    how to import files associated to CRM Contact records. There's first the preparation of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  16. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    Inventory Level, and Barcode all match. Our problem is that sometimes more than 100 products are modified in a day... We need to be able to do more than 100 or at least resume from a record... We need pagination. How? To resolve this, I'm building on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

    without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this function too often either for debugging/monitoring purposes but it's easier to use an access token then getting the OAuth...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  18. Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

    from ZohoCreator called "zbooks". It has fullaccess as a scope but I'm sure you can lock it down to just the scopes you need. void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) { v_OrderID = ifnull(input.p_OrderID,0).toLong(); /*...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  19. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    tab in their web-browser displaying a plain output message. How? So there are 2 caveats to this solution: 1 is that you will need ZohoCRM. I've tried using the "Incoming Webhooks" feature of ZohoBooks but realised the word "Incoming" is the operative...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  20. PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/cms/website-development/php/php-script-make-your-own-thumbnail-generator-via-api.html

    down the dropdown, more are loaded. This still gets buggy on certain mobile devices as some images are over 1Mb. So I needed a tool that every time a new product is added, a thumbnail gets generated and stored in the same application. Trawling through...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
Results 21 - 40 of 277