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 question is required, the following 26 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

    with ZohoZIA. Why? Previously, I would edit the message handlers of a Cliq Bot I created 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  2. 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 "Page Number", p."Title" AS "Page", p."Description" 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"...

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

    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 the support ticket....

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

    There are several steps, so first we will set up the ZIA action "Ask ChatGPT" using the GUI, then we will capture the question using Deluge code and query the OpenAI ChatGPT API to return a response. Getting to the development-side Login to ZohoCRM as a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. SSRS Display question mark when date is blankhttps://www.joellipman.com/component/content/article/ssrs-display-question-mark-when-date-is-blank.html?catid=75&Itemid=165

    7 Enterprise What? So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if there is no date to populate the field. Why? At the moment, the expression in there is something like...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  6. 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

    OpenAI ChatGPT 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....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  7. Parameters not being used in report processinghttps://www.joellipman.com/component/content/article/parameters-not-being-used-in-report-processing.html?catid=75&Itemid=165

    = (SELECT TOP 1 SiteId FROM SITES WHERE SiteName=@specifiedCampus AND SetId=@setId) -- Get the start date for the week in question SET @baseDate = (SELECT TOP 1 StartDate FROM WEEKSTRUCTURE WHERE StartDate BETWEEN DATEADD(day, -6, @specifiedDate) AND...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  8. Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/component/content/article/windows-os-alt-codes-symbols-special-characters.html?catid=80&Itemid=165

    files in unicode or utf-8 encoding will help but there will be times when you have lost the formatting and get weird question mark characters instead such as: . How? Ensure you are using the numbers on your numeric keypad and NOT the numbers at the top...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  9. Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

    a+ This expression matches all of the following: a aa aaa The expression does not match: bbb Zero or One — Question Mark The question mark matches zero or one--and only one--occurrence of the preceding character or subexpression. You can think of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  10. Foreign Characters create symbols in PHP and MySQLhttps://www.joellipman.com/articles/cms/website-development/php/foreign-characters-create-symbols-in-php-and-mysql.html

    What Another article trying to help people display foreign characters on their website without the funny question marks in diamond symbols and how I solved it in my case. Why? My company has started using international country and region names which...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  11. GDPR Privacy Policyhttps://www.joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  12. Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/component/content/article/basic-webpage-controls-with-javascript-com.html?catid=48&Itemid=165

    ways to access the HTML DOM. You may be wondering, "How do I find information about the element so I can access it?" Good question! The following tools can help you with that. Helpful Tools iWebBrowser2 Learner - This program will give you information...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  13. Alternative method of displaying Unicode in Autohotkey GUIhttps://www.joellipman.com/component/content/article/alternative-method-of-displaying-unicode-in-autohotkey-gui.html?catid=48&Itemid=165

    with tilde 166 A6 U+00AA ª feminine ordinal indicator 167 A7 U+00BA º masculine ordinal indicator 168 A8 U+00BF ¿ inverted question mark 169 A9 U+2310 ⌐ reversed not sign 170 AA U+00AC ¬ not sign 171 AB U+00BD ½ vulgar fraction one half 172 AC U+00BC ¼...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  14. Privacy Policyhttps://www.joellipman.com/component/content/article/privacy-policy.html?catid=50&Itemid=165

    by this privacy statement. You should exercise caution and look at the privacy statement applicable to the website in question. Controlling your personal information You may choose to restrict the collection or use of your personal information in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB
  15. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    text to display to their users. A preset form/page with openUrl could do the same thing but it's a fixed width/height and question of preference. There are cases however when the openUrl method might be better, for example, for confirmation dialogs...

    • 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

    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 storing the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  17. Zoho Analytics & Zoho People: Monitor DataSource Sync https://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-zoho-people-monitor-datasource-sync.html

    m_DataSourceInfo = m_DataSource; break; } } } //info m_DataSourceInfo; // // to email or not to email, that is the question, whether 'tis nobler in the mind to suffer... if(!v_LastSyncStatus.equalsIgnoreCase("Data Sync Successful")) { v_To = "Client ";...

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

    super admin? Most likely yes and the client would have already checked this. Did this ever work before? Kinda pointless question but needs to be asked just in case this was never meant to work in the first place. When did the connection last work?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  19. Connect to Joomla database in standalone scripthttps://www.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

    mysqli_free_result( $db_connect ); Clear as mud? Feel free to use the comment fields at the bottom of this page to ask a question. Additional I'm pretty sure you don't need all the require files and my solution may be crude, but this script works...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  20. Things to Check if Joomla Password Reminder email not being senthttps://www.joellipman.com/articles/cms/joomla/things-to-check-if-joomla-password-reminder-email-not-being-sent.html

    A quick article on a frequent question I get asked. This refers to an issue within the Joomla CMS (version 2.5.x) where it fails to email users who reset their password. How? A few things to check: Check the email message even exists: Login to your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
Results 1 - 20 of 26