GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 Please read them carefully. Privacy Please review our Privacy Notice, which also governs your visit to our website, to understand our practices. Electronic Communications When you visit JoelLipman.com or send e-mails to us, you are communicating with us...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 ChatGPT 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...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Privacy Policyhttps://joellipman.com/static-items/privacy-policy.html

30 May 2009 relevant to customer surveys and/or offers What we do with the information we gather We require this information to understand your needs and provide you with a better service, and in particular for the following reasons: Internal record keeping. We may...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: en-GB

Community Builder in Joomla Vulnerabilityhttps://joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 detailed information about the problems with this site, visit the Google Safe Browsing diagnostic page for this address I understand that visiting this site may harm my computer. Continue? Even if you use the latest versions of Community Builder (v1.2)...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 a link to its source. You can use this script as long as you don't hold me responsible for the results. If you don't understand what this script is doing, you shouldn't be running it. Please ask someone who does. -- IMPORTANT NOTES (to be included in...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 that do this for me? Yay! for free as well, as long as my page isn't loaded more than 100,000 times a month. I don't understand, one website visitor can generate 1000 hits, so thereafter I have to pay every time someone sees that picture through my...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Basic Webpage Controls with JavaScript / COMhttps://joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 and executing AHK scripts. We will be covering the following three topics: The HTML DOM - (Document Object Model) A basic understanding of the HTML DOM is essential for controlling webpages. This is because it's a "map" or "heirarchy" for accessing...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Sort order a dropdown list in MS InfoPath without programminghttps://joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 was already configured to read off the sharepoint list, and it had re-ordered to what I set in the view!!! I don't really understand how it works only that it does. I think this could get complicated if you had two dropdowns reading off the same list...

• Type: Article
• Author: Joel Lipman
• Category: Infopath
• Language: *

SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 @ for SQL Server and not the colon (:) we expected for Oracle. Passing in Variables I've been told that SSRS does not understand OUT variables. For a success message to be returned based on the status of the stored procedure, please view my article SSRS...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

07 June 2012 I do not work for either Joomla or JoomlaTune (Jcomments) This script is provided as is without warranty If you do not understand what this script is doing, let someone who does run it instead INSTALL INSTRUCTIONS Install JComments on your upgraded...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Inline Labels in Form Fields using Javascripthttps://joellipman.com/articles/web-development/js/inline-labels-in-form-fields-using-javascript.html

21 August 2012 value equals "Name:" I've added some code to trim the values. If the user types two spaces, then we want the field to understand this as "no one entered anything", treat it as empty. this.value.split(' ').join('') -- split this value into an array...

• Type: Article
• Author: Joel Lipman
• Category: JavaScript
• Language: en-GB

Sync Outlook 2007 Shared Calendar with SharePoint 2007https://joellipman.com/articles/microsoft/sharepoint/sync-outlook-2007-shared-calendar-with-sharepoint-2007.html

09 November 2012 all-day event. Recurring Events Granted this is a bit of manual process considering when I did this, it didn't properly understand recurring events. My workaround for this was to copy the recurring event to the SharePoint calendar, then from within...

• Type: Article
• Author: Joel Lipman
• Category: SharePoint
• Language: *

Setup a copy of your Joomla websitehttps://joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

19 December 2012 to quickly point to LIVE or TEST. Confirm with each person aware of this setup and involved in the development, that they understand the risk of "accidental" changes and the concept of working on TEST before applying changes to LIVE (-> Schedule a daily...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Include a carriage return in a column headinghttps://joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 as one word (ie. there has to be a space in between the two words "Academic" and "Week" otherwise the system will only understand the carriage return and often return it as "AcademicWeek"). Other Search(es) Format a column alias with new line Using...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Android: Replace return key with done, go, send...https://joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 where a user can enter any text value but if they typed a return character, the app would crash because it didn't understand the data. I tried replacing the new lines but just stopping the return key or trying to catch it is an obsolete method. How? The...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Excel - Check a column for values found in another columnhttps://joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 this (I have added some conditional formatting which colors the cells red or green for demonstration purposes): If you understand this article, you may have noticed that the range of words to find from Sheet2 in this screenshot are from the cells...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Convert Past Date to Time Ago in PHPhttps://joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 ago but less than 2 weeks ago How? I know there are so many examples out there that do this perhaps better but this one I understand and can customize to fit my needs. This PHP function accepts as parameter a SQL date (or date format that strtotime()...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 in ZohoCreator. I'd preview it in Zoho Creator rather than the site that had embedded it. Source(s): Zoho Creator - Understand Widgets Bootstrap - Getting Started jQuery - Latest Stable Versions OpenJS Foundation - NodeJS Zoho - Widgets in Zoho CRM

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 type :POST parameters:m_NestedRequest ]; The receiving PHP script did however understand this hack as: $v_Key = "aaabbbbccccddddeeeeffff11112222"; $v_Secret = "can_you_keep_a_secret"; $v_PostedKey = "-"; $v_PostedSecret = "-"; if(isset($_POST['auth']))...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)https://joellipman.com/articles/crm/zoho/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

01 September 2021 If we are getting a date from a CSV or other external source as "dd/MM/yyyy", how do we guarantee that the system will understand the date correctly? How? It may be that when obtaining a date string and applying the method .toString("dd/MM/yyyy") is...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *