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 app: Adding third-party frameworks: I’m going to use my favorite third-party extensions (Bootstrap & jQuery) which I’m referring to over the web (Content Delivery Network – CDN) Recap So as a recap, this is how it looks so far: The HTML: The CSS: The...

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

Invalid arguments passed in router.php on line 325https://joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 XML file. (router.php). I even deleted the router.php file from my installation zip file (I checked that nothing was referring to it). The reason I've fixed it the way I did is because I don't need a router.php. The router.php file supposedly holds the...

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

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

19 January 2012 found this is just how I was calling the parameter. I declared these in the stored procedure but the fix in the end was referring to the Query Parameter Value properly. IMPORTANT! Make sure you have prefixed the parameter name with an at sign and...

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

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 work released this way by its authors. You can apply it to your programs, too. When we speak of free software, we are referring to freedom, not price. Our General Public Licenses are designed to make sure that you have the freedom to distribute copies...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 ever changed the words to but for more stability, there are a few more tweaks to do. How? For demo purposes we will be referring to a Joomla module called "mod_moduletoupgrade" in British English (en-GB). I don't think it actually exists in reality but...

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

Call to a member function mark() on a non-object in Joomla CMShttps://joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

17 November 2013 to return it to as it was. The error refers to a function used by the core framework. Comment it out and you get an error referring to the includes/framework.php file. Comment that out and you will get errors regarding other elements of the CMS. This...

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

Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 1 as read-only (permission only to higher level) and 1 picklist as selectable means that the first-line agent would be referring to 2 status fields and not really knowing which one defines the stage the lead is at. How? Well this can be done through a...

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

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 Workflow: - Trigger: Standalone function triggered on execute Purpose: Loops through all candidates and creates records referring to the Candidate Ref and Job Opening Date Created: 2023-02-02 (JoelLipman.com - Joel Lipman) - Initial release Date...

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

Zoho Creator: Disable/Hide the add and delete subform row buttonshttps://joellipman.com/articles/crm/zoho/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

28 February 2023 don't want to apply this to the every subform on that form, you will need to brush up a little on your CSS with regard to referring to elements by ID, so for example, if my subform is called "Item Details", then I would adjust the code to something like...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 script is what I use to pass the record ID to a CRM function called fn_Accounts_CreditSafe. It was partly written by referring to documentation and using CoPilot or OpenAI ChatGPT for parsing the return value of the function (note that I have SCRIPT...

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

SSRS Subscriptions cannot be createdhttps://joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 is describing the exact problem. If you include linked images in the report (as in images not in the report itself but referring to other systems holding the images), then please refer to my article on SSRS External Images don't display. The answer to...

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

SSRS Display question mark when date is blankhttps://joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 the problem? The problem Putting the date in an IIF (if-then-else) statement displays "#Error". You should get errors referring to converting strings to dates and incorrect data types. How? The fix is to simply get the field and both results to be of...

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

Zoho Deluge - Pad with leading Zeroshttps://joellipman.com/articles/crm/zoho/zoho-deluge-pad-with-leading-zeros.html

07 February 2020 There may be other articles out there documenting this but I can't keep trying to find these in Google so referring to my own website, this is a doddle for me to find each time. Why? I have to do this so often that it deserves an article. Though writing...

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