Zoho Deluge: Proper Case for Nameshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 is intended to work using Zoho Deluge. How? There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some European names: // // set first and last name v_FirstName = "BILLIE-JO";...

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

Zoho Creator: Sendmail a list of attachmentshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-send-mail-a-list-of-attachments.html

20 July 2023 isn't clearly documented. But there are tips found across the web just not specifically addressing this. How? Here is the code for a test function which downloads 2 files from a public domain, no user wall. The key here which the official documentation...

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

ZohoCRM: Using Criteria with Module Record Counthttp://mail.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 An example of code using the new API call "Module Record Count" with some criteria. Why? At time of print, I couldn't find an example of how to use this API call with search filters or criteria. Not sure about the rest of you, but I've been using this...

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

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttp://mail.joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 Instead the below script will show you how to use this API having a few email addresses as the recipients: A sample code snippet: For the below, I have a connection to ZohoBooks from ZohoCreator called "zbooks". It has fullaccess as a scope but I'm sure...

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

ZohoCRM: Make either Mobile or Email mandatoryhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-make-either-mobile-or-email-mandatory.html

03 October 2024 so a contact email OR phone number is required. Both aren't required but at least one should be. How? We can do this without code and only using ZohoCRM layout rules. Let's take a contact record for demo purposes: If I enter a phone number: If I enter...

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

Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 is only so much fun one can have in a day. The next day: Add to a workflow when objective / goal is submitted Here's the code that I added to the workflow for when a performance goal is created or modified (this will upsert it based on the Goal Record...

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

Restoring your WYSIWYG editor after upgrading Joomlahttp://mail.joellipman.com/articles/cms/joomla/restoring-your-wysiwyg-editor-after-upgrading-joomla.html

15 September 2009 upgrading Joomla, my TinyMCE WYSIWYG (What-you-see-is-what-you-get) editor halved its number of buttons and I couldn't add code snippets... The Fix Just installed JoomlaFCK WYSIWYG Editor, an editor I use with my day job's MediaWiki software and it's...

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

Search and Replace in a MySQL Databasehttp://mail.joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 editing each field so that it displays correctly... well that's usually me. Found it a bit boring but here's a short bit of code to speed it up which I now use: update table_name set field_name=REPLACE(field_name,'string_to_find','string_to_replace');...

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

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

27 April 2010 A ternary operator for those who are unfamiliar with this is an "If...Then...Else..." statement written in a small amount of code, usually on one line, and exists in most programming languages. For Example, the statement: If (ThisCondition = true)...

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

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

08 July 2011 Destroy ExitApp Now this results in a tiny GUI that displays the link in black and works (somewhat). If you copy the above code into an AutoHotkey file, you'll find this is remarkably temperamental. If the user is too quick with their mouseovers and...

• 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 was last. This is incredibly useful for pagination. The Situation I want the script to start writing a DIV layer in the code at the start of the loop (and at every first entry of a page). I want the script to close the DIV layer at the last entry of...

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

Functions to convert Hex 2 RGB and vice-versahttp://mail.joellipman.com/articles/automation/autohotkey/functions-to-convert-hex-2-rgb-and-vice-versa.html

27 September 2011 are for autohotkey and in AHK code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal to RGB: HEX2RGB(HEXString,Delimiter="") { If Delimiter= Delimiter=,...

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

MySQL day of week ending on Fridayhttp://mail.joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 These didn't get me very far until I decided to write this article: DAYOFWEEK(myDate, 1) or WEEKDAY(mydate, 1) MySQL code for first and last day of week. Day of Week starting on Monday.

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

Joomla field types clear my htmlhttp://mail.joellipman.com/articles/cms/joomla/joomla-field-types-clear-my-html.html

09 August 2012 Trying to make a component and can't remember how to store HTML code when the save command is clicked (ie. submitted from a PHP form). This is for the Opensource Content Management System (CMS - phew what a mouthful) Joomla! version 1.6.x to 2.5.x; no...

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

Warning call_user_func: First argument is expected to be a valid callbackhttp://mail.joellipman.com/articles/cms/joomla/warning-call-user-func-first-argument-is-expected-to-be-a-valid-callback.html

22 November 2012 line 311 How? Copy & backup the file /public_html/.../templates/rt_affinity/rt_sectionrows.php Find the following piece of code around line 311: foreach($this->horizontalCookie[$row] as $block) { $block = str_replace('-', '', $block); $this->module_row1...

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

A for loop within a for loop in MS-DOShttp://mail.joellipman.com/articles/automation/ms-dos/a-for-loop-within-a-for-loop-in-ms-dos.html

03 October 2013 programs is a lot easier and colleagues trust these more than my all-in-one GUI applications. How? Note: we're using the code in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one: -- the following...

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

PHP: First name and Initial of Surnamehttp://mail.joellipman.com/articles/web-development/php/php-first-name-and-initial-of-surname.html

27 March 2014 A note for myself on some code to convert a string of two names into a string made up of the first name and then using the initial of the second name. -- What I have John Smith Fred.Bloggs -- What I want John S. Fred B. How? So different ways, the first...

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

MySQL Updating a database table from another tablehttp://mail.joellipman.com/articles/database/mysql/mysql-updating-a-database-table-from-another-table.html

22 October 2014 Why? I have several database tables which replicate country names and I would rather they all use the ccTLD two letter code. This article was written because it took me so long to work it out. How? UPDATE `table_to_update` a INNER JOIN `table_to_read` b...

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

Make bootstrap carousel responsive to swipehttp://mail.joellipman.com/articles/web-development/bootstrap/make-bootstrap-carousel-responsive-to-swipe.html

14 December 2016 layouts for me. I really like the solution (and think it should be voted best answer) put forward by Mark Shiraldi: The code is minimal but does what it needs to do (tested on iOS) and doesn't appear to effect other javascripts. Put this in a JS: /*!...

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

Zoho Deluge - Get Current User IDhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-current-user-id.html

08 April 2019 This is a quick article on different ways to get the current user ID in Zoho through code. How? I'm not a fan of method #1 but I only started developing in Zoho recently when API v1 was already being deprecated (end of life at the end of this year). So...

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