Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 modules and find the "ID" number for your "pubmenu" item and then input that number in the "Quick Module ID Include" field. 6. Copy metamod_pubmenu, edit and rename it to metamod_regmenu. Then, on right side in "Module Parameters" "Show Quick Modules...

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

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

15 November 2009 and some don't description - not recommended! date - the one I use for most recent created - this is also a date formatted field modified - and this is a date formatted field hits - number of times that weblink has been visited state - this is the J16...

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

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 Debug Method Fallback to debug methods; create a textbox that will be visible on the executed report (obviously replace the field name with the name of your field containing the location of the image - ours is "PhotoURL"): =" The file " &...

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

How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 to do a database level calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime) SELECT field1, field2, TO_CHAR(systimestamp, 'HH24:MI:SS.FF6') AS ReportStartTime FROM... Then add another...

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

DataJumble - Shuffling characters in a data valuehttps://www.joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 2))=1 SET @ColumnTypeIsDate = 1; -- Determine if this is a date/time value IF @ColumnTypeIsDate=1 BEGIN -- DETERMINE IF THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

DataScramble - Randomizing data rowshttps://www.joellipman.com/articles/database/t-sql/datascramble-randomizing-data-rows.html

07 December 2012 2))=1 SET @ColumnTypeIsDate = 1; -- Determine if this is a date/time value IF @ColumnTypeIsDate=1 BEGIN -- DETERMINE IF THIS FIELD CONTAINS A DATE VALUE SET @DateMatch = CASE WHEN CAST(CAST(@OrigVal AS date) AS VARCHAR(10))'1900-01-01' THEN 1 ELSE 0...

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

Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=40

03 January 2014 checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in the input field and let it do the rest. Background Joe's Password Analyzer is a Joomla 2.5.x component which simply displays a...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 Go to Security > Show More > Advanced Settings > Manage API Client Access Enter the Client ID in the field Client Name (eg. 1000389324798977991) Enter the scope URL in the field One or More API Scopes (eg. https://www.googleapis.com/auth/drive) Click...

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

Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 // yields: 123456789012345678 Problem: Inserting a date time string into a date time field in Deluge So annoying but sometimes you want to insert a date/time value into a date/time field and you get the error: v_MyDateTimeString =...

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

Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 to "Header" Grant Type: set this to "Authorization Code" Client ID: Copy & paste from the previous step this value into this field. Client Secret: Copy & paste from the previous step this value into this field. Authorize URL: Enter the Zoho...

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

Zoho Analytics: Setup DataSource via FTP Connectionhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 Click on "Data Sources" in the left sidebar then click on "Add Data Sources" in the top right: Type FTP in the filter field in the top right and there should be a single FTP option displayed to you: Step 1 of 2: Give the datasource the table name it...

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

ZohoBooks: Stripe Terminal Integrationhttps://www.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

16 March 2023 the Stripe terminal will ask for the amount on the invoice. Well almost. We've gone the extra step in that we added a custom field that can override the full balance, to allow partial payments such as a deposit or instalment. How? I won't go in to how...

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 image URL to/from ZohoWriter. Loop through active users in ZohoCRM. Merge the HTML email signature with the fields evaluated. Function: fn_Workdrive_HostImage I add this function to the CRM and use it as a standalone function to upload generic images...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 get the tags of the contact record using an invokeurl because shortcode only gives me name and ID; but I want the color code field as well which I only seem to get with an InvokeURL. I'm then going to create a list map of tags and add these to the deal...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttps://www.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 and respond to eBay with an HTTP 200 OK status, including the hashed result in JSON format within the challengeResponse field. The response's Content-Type header must be set to application/json. The following instructions are on the eBay page but this...

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

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

13 October 2025 copy from Xero to Zoho the Client doesn't use the Items module in Xero and instead puts the product name in the description field How? Because my head is a little fried, I'm putting the two functions I used here and I'll document further if I remember....

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

Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 what I use to convert a given SQL date to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table WHERE my_id='$this_id'"), 0, "my_date_field"); $this_date_array=explode("-", trim(substr($this_date, 0,...

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

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

15 April 2014 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 this: =Format(Fields!MyCompletionTime.Value, "dd/MM/yyyy...

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

Zoho Deluge - MD5 functionhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-md5-function.html

19 November 2018 task. Why? I'm trying to create an ETag for a synchronization process between Zoho Creator and Zoho CRM. Combining all the fields to compare into a single field can't be done via the documented methods (base64, urlencode or AES) as this exceeds 255...

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

Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-prompt-and-popup-mailer.html

06 February 2024 // get the full name of this contact (not sure why this returns both first and last) var v_ContactName = ZDK.Page.getField('Last_Name').getValue(); // get the email of this contact var v_ContactEmail = ZDK.Page.getField('Email').getValue(); // get the...

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