Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 I create a field called "Audit_Change" and then I add to it our workflow with the main bit of code. For any other field that needs to update this preview, I tell it to update the "Audit_Change" field with something like: input.Audit_Change = "Title: " +...

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

Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match the colors or style the next client wants. Why? The scenario is that my client has quite a long Creator...

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

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

10 January 2022 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
• Language: *

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

13 February 2023 // // 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
• Language: *

ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

06 March 2023 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
• Language: *

Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/zoho-books-generate-bank-text-file-for-download.html

02 October 2023 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
• Language: *

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 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
• Language: *

ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-function-to-pull-most-recent-invoices.html

09 October 2025 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
• Language: *

Setting up your store to use SSLhttps://www.joellipman.com/articles/ecommerce/setting-up-your-store-to-use-ssl.html

11 September 2009 To setup your store to use SSL (Secure Socket Layer) you will first need an SSL certificate. Many hosting companies will either provide (or can offer) "Shared SSL" or the option to buy a "Dedicated SSL" certificate. Shared SSL means that your store...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Change default order of weblinkshttps://www.joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

15 November 2009 comment and text. As always, I would recommend you make a copy of the file before making the change just in case you need to revert the change: // We need to get a list of all weblinks in the given category $query = 'SELECT *' . ' FROM #__weblinks' . '...

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

Remove write-protect from USB pen in Windowshttps://www.joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 safely" rubbish as my old pen never did and it was fine for over a year. The default setup in windows XP is that it doesn't need it. Bulletproof, waterproof, fireproof, shockproof BUT NOT joe-proof!... I'm using windows 7 and my day-job machines tend...

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

Is it a scam? Gumtree.com's warning signshttps://www.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 This list used to be on Gumtree's website but I can't find it anymore. This is quite a thorough list though it still needs some work. Requests to use money transfer services like Western Union or MoneyGram. These services are not meant for transactions...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 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: *

SSRS Querying on either of 2 Parametershttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 parameter expressions" either. I'm using an Oracle/PLSQL database for this so whether you're using T-SQL or MySQL you'll need to use the appropriate variable references (eg. T-SQL is @localvariable, Oracle is :localvariable). I need to change it to a...

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

Returning Oracle Stored Procedure Resultset in SSRShttps://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 this sounds, this is not a five-minute job. Even with all your SQL scripts with backups of your datasets, each of these will need tweaking. Create your stored procedure in Oracle (and grant execute for your SSRS user) Add a data source to your SSRS...

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

Basic Joomla 2.5 Mootools Formhttps://www.joellipman.com/articles/cms/joomla/basic-joomla-25-mootools-form.html

20 August 2012 in the background without loading a new page). How? This form is more AJ than AJAX as I don't even use an XML file. You'll need to create a receiving file that sends back the data, in my case, I've called it ajax.form.php and the contents of which are:...

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

Slideshow div layer through a windowhttps://www.joellipman.com/articles/web-development/mootools/slideshow-div-layer-through-a-window.html

11 September 2012 The brief was pretty much just "...fast and works with cms articles...". If we have 100 slides then 100 slides of data will need to load at the same time per page. Terrible. Using AJAX (which will have to be Asynchronous JavaScript and xHTML. I'm not...

• Type: Article
• Author: Joel Lipman
• Category: MooTools Framework
• Language: *

Fix Oracle Tnsping 3511 without Windows Registryhttps://www.joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 file for product=NETWORK, facility=TNSMessage 3509 not foun d; No message file for product=NETWORK, facility=TNS Why? We NEED several instances of Oracle installed as we have different products/services and these run off various instances of Oracle 9i,...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Generate a Timesheet in MySQL https://www.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 I also worked on creating a template for the site I just made; I started at 9:45 and finished at 12:00") The final system needs to specify every day of the week and divide all the days activities into the morning and afternoon slots. All days and time...

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

SSRS: Performance Improvements: SELECT TOPhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 clause returns zero rows if dob, reference, -- forename and surname parameters are not populated. In addition, we also need a second dataset in our report which gets the total count of all the rows matching the selection criteria (the parameters). The...

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