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 answer 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

    but it would only understand the questions I have programmed it to and respond with the responses I programmed it to answer with. Any variations of the questions it did not understand, it would return a response similar to Siri or Ask Google where it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  2. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    my support team consists of me, myself and I. Saying this I'm in discussion with commercial solutions that still haven't answered some of my questions or even raised as issues. I'm not them; add as a comment to this article or email me and that will be...

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

    will have the specific OrgID in the URL). Click on "Add Action" Give it the Action Name "Ask ChatGPT" This action should "Answer a Question" It should be answered by "Construct Answer by Fetching Data" The question can be asked by clicking the button...

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

    AS "Description", to_integer(substring_before(q."Text", '.')) AS "Question Number", q."Text" AS "Question", r."Text" AS "Answer", r2."Status" AS "Status", r3."Variable Value" AS "Respondent Email" FROM "Responses (Zoho Survey)" r LEFT JOIN "Surveys...

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

    is all very well 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...

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

    this as a CSV and asking Deluge to parse the data in the appropriate columns was not working as expected. How? The quick answer is a regex that will replace any commas between two quotes with a custom string, to be exact: v_FormattedData =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    and want all the data to stay aligned. Using only DIV layers can cause a few unexpected layouts in ZohoCreator. The Quick Answer: the page margins Tackling the page margin on render, I wrap the whole lot inside a DIV layer with the key attribute...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  8. ZohoCRM: zoho.crm.searchRecords only returns certain recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-search-records-only-returns-certain-records.html

    on a Zoho Finance > Sales Orders module but it wasn't finding all the Quotes related to this Sales Order. How? The quick answer is buried in Zoho documentation and due to the searchRecords function requiring it's 5th parameter which defaults to "not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Zoho Finance Suite Schedule: PATTERN NOT MATCHEDhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-finance-suite-schedule-pattern-not-matched.html

    type of schedules are failing, you won't see this error until you go in and try to save it again. How? The super quick answer is remove any spaces from the name of the schedule. The longer answer is demonstrated in the following screenshots: Error:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  10. Batch Process to rename multiple files using Windows DOShttps://www.joellipman.com/component/content/article/batch-process-to-rename-multiple-files-using-windows-dos.html?catid=51&Itemid=165

    extensions. So you can do this quickly on a friend's PC and it's a bit geeky. Type the following NOTEPAD rename.bat and answer Yes to if you want to create it. Copy & Paste the following (the string to replace here is " (Copy)" without the quotes) -...

    • Type: Article
    • Author: Joel Lipman
    • Category: MS-DOS
    • Language: en-GB
  11. Zoho CRM & Zoho Creator: Query returns some fields missing other data on the recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-crm-zoho-creator-query-returns-some-fields-missing-other-data-on-the-record.html

    reason" turned out to be because my detail view on the report was displaying a report/document template. How? The quick answer is: Add the fields you want to the detail view of the report you are accessing. The detailed resolution is: Create a duplicate...

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

    multiple fields Additionally, you might ask if you need an eTag field for each field that you want to monitor changes. The answer is no, you only need one. You can have 1 eTag which combines all input fields into 1 MD5 or hash. Do you need to add a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  13. Zoho Inventory: Enable Tracking using the APIhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-enable-tracking-using-the-api.html

    create an item in Zoho Inventory: Why? Who uses ZohoInventory for anything else than tracking stock...? How? So the quick answer is one missing parameter to send through which is "item_type=inventory"... A little longer, is do ensure you have Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  14. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    error: { "code": 15, "message": "Please ensure that the billing_address has less than 100 characters." } How? So the quick answer is 2 separate API calls after you have sent the code to either create or update the estimate in ZohoBooks. You will need...

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

    field but I was getting the following error: { "code": 2945, "description": "EXTRA_KEY_FOUND_IN_JSON" } How? So the quick answer is to build a nested map in your request instead of using the Creator/JavaScript period/dot character... Some might suggest...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  16. Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

    will not process it all and respond to Shopify within 1 second. How? So let's begin with the code snippets as these might answer your question to begin with and then we'll do the easy bit on how you set this up in the CRM. I'm using ZohoCRM here despite...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  17. ZohoBooks: Broken UK Banking Feedhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-broken-uk-banking-feed.html

    a new Open Banking token) would have any impact on existing balances or manually imported transactions. The short answer is that reconnecting or refreshing a feed does not affect historical transactions, but deleting the account altogether can affect...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  18. Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

    how I fixed it. Basically because firstly I don't want to have to create an account on someone else's forum just to post my answer and secondly because my solution is a "cowboy fix" rather than the other intelligent solutions on the web. The issue was...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  19. RokDownloads Manager does not list fileshttps://www.joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

    you can get to this file manager to work without changing your Joomla! setup. Watch this space for when I find a definitive answer!

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  20. Adding a selectable background to a Yootheme templatehttps://www.joellipman.com/articles/cms/joomla/adding-a-selectable-background-to-a-yootheme-template.html

    and I tend to piggyback on my client's subscriptions. This information does not come from Yootheme forums. I am too lazy to answer/update my solutions in 3rd-party forums.

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