Zoho Creator: Input Color Pickerhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 getting our users to learn about hexadecimal color references and Red Green Blue (RGB) values is somewhat difficult. What would be nice-to-have is if they could be presented with a bunch of colors and they click on one to select it. When are colors...

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

Zoho CRM: Remove Duplicate Product Recordshttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 version of the record (sorted by ID ascending) and will attempt to delete the other records which match on product name. I would recommend commenting out the delete commands and leaving the info commands to preview what records it will delete. I also...

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

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 of the line items. Pretty much a function which took me a day to write. Why? As mentioned, it took me a while to write and I would like to use it as a reference for when I forget how to do this. The use-case here is that we have a dropdown/picklist on a...

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

PHP Script: Make your own Thumbnail Generator via APIhttp://mail.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 through the first few pages of Google, all the online tools that did the same had a pricing page. I can understand why you would need to limit users so I don't blame them. But if you can, why not make your own? How? So you will need a webserver of your...

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

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

18 August 2025 is the code for the function fn_Accounts_CreditSafe... obviously I can't give you the real Zoho Deluge function here as it would use my credentials but what you need to know is that it is passed the crmAPIRequest (string) variable and that the function...

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

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

09 October 2025 couldn't find it so let's create it m_CrmProduct = Map(); // // some companies don't use the product lookup in Xero so you would need a placeholder product from CRM. if(!isNull(m_XeroLineItem.get("Item"))) { v_CrmProductName =...

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

Hide Menu Item from Registered and Special http://mail.joellipman.com/articles/cms/joomla/hide-menu-item-from-registered-and-special.html

06 September 2009 course the menu could have been created with just one item with no title and positioned at the bottom of another menu; this would look like it was all part of one menu). toubkal wrote: This cannot be done by joomla administration but can be done by...

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

How to make a HTML form post its variables to itselfhttp://mail.joellipman.com/articles/web-development/html/how-to-make-a-html-form-post-its-variables-to-itself.html

17 September 2009 to process the data. Solution I've seen a lot of people write CGI requests but if you left the action attribute blank, this would do the same thing:...

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

Can't play music after Firmware Update Version 3.0http://mail.joellipman.com/hardware/cant-play-music-after-firmware-update-version-30.html

21 September 2009 else anymore. I can still play some games and select my own music... but they're dumbass PSN games that iPhone users would have got for a pound or what have you...

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

Splatter Logohttp://mail.joellipman.com/graphic-design/splatter-logo.html

30 September 2009 when web-developers need to be able to run several programs at the same time and simplicity is king. In PaintShop Pro you would simply: How? Insert text as floating, leave the selection on Create a new layer beneath Go to Selection > Modify > Expand >...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

On Gui Resize Eventhttp://mail.joellipman.com/articles/automation/autohotkey/on-gui-resize-event.html

09 November 2009 GuiControl, MoveDraw, MainRedBackground, w%A_GuiWidth% h%A_GuiHeight% Return If I just used GuiControl, Move,... then this would be as above but if you are using images, then you will get problems with the image repeating... so use moveDraw which...

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

Add default to a picture buttonhttp://mail.joellipman.com/articles/automation/autohotkey/add-default-to-a-picture-button.html

10 November 2009 respond to the ENTER key after you typed something (this is for a search feature) in addition to having a button if the user would rather click then press the ENTER key. Then create the mouseover and mouseout effects afterwards. Add the image for your...

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

After installing rokstories, get invalid argument 106http://mail.joellipman.com/articles/cms/joomla/after-installing-rokstories-get-invalid-argument-106.html

14 January 2010 After I installed the rokstories module from www.rockettheme.com, if I clicked on one of the articles (rokstory), I would get a page with the article on it but with the following error (3x) above it: Warning: Invalid argument supplied for foreach() in...

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

AutoHotkey Ternary Operatorhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-ternary-operator.html

27 April 2010 languages. For Example, the statement: If (ThisCondition = true) ThisVar:=1 Else ThisVar:=2 Converted to Ternary this would look like: ThisVar:=(ThisCondition = true) ? 1 : 2 I'll add as there are a whole bunch of methods using the Ternary Operator in...

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

MySQL Commands to display all columnshttp://mail.joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 DATA_TYPE='text' AND TABLE_SCHEMA='sample_db' ORDER BY TABLE_NAME, COLUMN_NAME Note that the user launching this SQL query would need the SELECT privilege as a minimum on "information_schema" (arguable).

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

Border settings not saving in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a grid would show for empty spaces. I wasn't getting very far because I'd even ask the border to be grey and save the project but when I...

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

Mouseover Links in AutoHotkeyhttp://mail.joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 as blue despite the mouse cursor not being anywhere near it. Proper HTML mouseovers: When I have a more stable solution. I would however recommend cwebpage.dll at as a minimum for internal HTML pages for use in an AutoHotkey GUI.

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

First and Last Entry on a Page using Modulus Remainderhttp://mail.joellipman.com/articles/web-development/php/first-and-last-entry-on-a-page-using-modulus-remainder.html

26 September 2011 it's quite a long title but I'm not sure what I'll be searching next time. It has taken me a lot longer than I thought it would mostly out of frustration and the inability to know exactly what I'm looking for... always difficult. After a cup of tea the...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *

The greatest invention in IThttp://mail.joellipman.com/hardware/the-greatest-invention-in-it.html

13 September 2012 has to be the following notion from IBM: a 1976 research report by Lance A. Miller and John C. Thomas of IBM, noted that "It would be quite useful to permit users to 'take back' at least the immediately preceding command (by issuing some special 'undo'...

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

Link to a Joomla article from within another articlehttp://mail.joellipman.com/articles/cms/joomla/link-to-a-joomla-article-from-within-another-article.html

04 December 2012 enabled. How? Basically you have to include &view=article as opposed to Joomla v1.5.x when the option and id parameters would suffice: - SEF URL http://www.joellipman.com/support/documentation/449-module-joes-word-cloud-jwc.html - Direct Link...

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