PHP: First name and Initial of Surnamehttps://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

CSV Chart Generatorhttps://joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you leave the copyright information. If you want to remove the copyright text that...

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

MySQL Transactions in PHPhttps://joellipman.com/articles/database/mysql/mysql-transactions-in-php.html

14 December 2016 MySQL commands directly like: mysqli->query("START TRANSACTION") mysqli->query("COMMIT") mysqli->query("ROLLBACK") Important note: Our tables must use an engine that supports transactions ie. InnoDB. Don't be silly like me and spend hours wondering why...

• Type: Article
• Author: Ike Francis
• Category: MySQL
• Language: en-GB

Zoho Deluge - Get Full Day Namehttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

08 November 2018 This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name =...

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

Zoho Deluge - Hide Reset Button on Formhttps://joellipman.com/articles/crm/zoho/zoho-deluge-hide-reset-button-on-form.html

15 November 2018 So another quick note as I couldn't find a solution on the forums. This is to hide the reset button on a non-stateless form (state form?). I have posted this on the Zoho forums as well but here goes: Why? Because I can. And because as someone said, a...

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

Zoho Deluge: Check Time Booking Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge-check-time-booking-slots.html

05 December 2018 Just wanted a note to get in my head the logic if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time:...

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

Zoho Deluge - Regex to Strip all non-numeric charactershttps://joellipman.com/articles/crm/zoho/zoho-deluge-regex-to-strip-all-non-numeric-characters.html

25 March 2019 characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above string How? I'm aware of the getAlphaNumeric() function in Zoho and I can remove the...

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

Zoho Deluge - Get User Timezone, Country and Locationhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-user-timezone-country-and-location.html

03 June 2019 A quick article just as a note to get the users country information from a third-party API based on the given IP address. How? Well this is just a list of free 3rd-party APIs and the below code is dependent on these being online and working... The...

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

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 lookup options (not selected items) for each r_EntryID in l_AllowedEntries { input.myLookup:ui.add(r_EntryID); } Additional Note(s): If removing elements, even if you are using Creator v5, use removeElement() and NOT remove() which got me stuck for a...

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

PHP - Remove newlines and spaces from StyleSheethttps://joellipman.com/articles/web-development/php/php-remove-newlines-and-spaces-from-stylesheet.html

03 January 2020 What? This is a quick note on how to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines. Why? What I have: #copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); } What I want:...

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

Joomla CMS: Register to Read Morehttps://joellipman.com/articles/cms/joomla/joomla-cms-register-to-read-more.html

11 April 2020 This article is a quick note on how to change your Joomla CMS "Read More" to "Register to Read More" all without hacking away at the Joomla core. Why? Well a few hacks may be necessary because not only do we want to restrict read more content (full...

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

Zoho Projects: Deluge to Submit Custom Fieldshttps://joellipman.com/articles/crm/zoho/zoho-projects-deluge-to-submit-custom-fields.html

17 June 2021 that my custom fields have as identifiers UDF_CHAR8 (which is a Zoho ID) and UDF_CHAR7 (which is a text/string name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it should be all on one...

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