MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 Excel will be forced to treat it as a string: Another alternative to round brackets, square brackets! Additional: I have made this work with the parentheses but only after refreshing ALL DATA in the spreadsheet and reconfiguring which fields go in...

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

SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

04 October 2013 automate this (run as Administrator in Win7 from C:\temp): @ECHO OFF REM This program is for Joel Lipman to run after he's made a change to some REM C# code for a SSIS Custom Script Component task. REM Change the working directory to the GACUtility...

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

Generate a Timesheet in MySQL https://www.joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 site; I started at 9am and finished at 9:45.", "Monday morning, I also worked on creating a template for the site I just made; I started at 9:45 and finished at 12:00") The final system needs to specify every day of the week and divide all the days...

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

JComments 2.3.0 with ReCaptcha in Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/jcomments-2-3-0-with-recaptcha-in-joomla-2-5-x.html

20 March 2014 'KCAPTCHA'); $captcha[] = JCommentsHTML::makeOption('recaptcha', 'RECAPTCHA'); STEP #4: Set in admin setting We've made the option available, now login and set it to our new captcha Login to your Joomla Administration panel Components > JComments >...

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

ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-for-joomla.html

24 March 2014 'KCAPTCHA'); $captcha[] = JCommentsHTML::makeOption('playthru', 'PLAYTHRU'); STEP #4: Set to PlayThru in admin setting We've made the change, now login and set it to PlayThru Login to your Joomla Administration panel Components > JComments > Settings >...

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

ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2https://www.joellipman.com/articles/cms/joomla/recaptcha-alternative-integrate-playthru-in-jcomments-3-0-for-joomla-3-2.html

27 April 2014 (line 398) Replace the line KCAPTCHA With this KCAPTCHA PLAYTHRU STEP #4: Set to PlayThru in admin setting We've made the change, now login and set it to PlayThru Login to your Joomla Administration panel Components > JComments > Settings > Layout >...

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

A quick run through of setting up an export process in SITShttps://www.joellipman.com/articles/web-development/xml/a-quick-run-through-of-setting-up-an-export-process-in-sits.html

21 August 2014 ones existing and all monitors run I would get this issue if I cloned an existing process (released an existing one, made changes, stored it as a new one) Check the DOT for records that will be output. Check that DRE contains the rules for the DOR code...

• Type: Article
• Author: Joel Lipman
• Category: Extensible Markup Language
• Language: *

Protecting your Joomla Administrator Sectionhttps://www.joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 website with a name that is difficult to guess but easy to memorise. Create a file called index.php in the folder you just made with the following contents: Append the following code to the .htaccess file in the root of your joomla website: # Admin...

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

Pure JS - Display Time Elapsed & Remaininghttps://www.joellipman.com/articles/web-development/js/pure-js-display-time-elapsed-remaining.html

30 October 2018 write about the same, but this is an example that I was coding and found to be one of the most reduced cut down formats I've made. I thought I'd make a note of it to not have to search elsewhere... This example specifically displays the time remaining...

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 A separate file will be created for each sheet in the same folder. A combined all-in-one solution The following script is made of 4/5 subroutines. Follow the instructions above on how to execute a vbscript and then paste the below into the developer...

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

Zoho Deluge - Get distance between two coordinateshttps://www.joellipman.com/articles/crm/zoho/get-distance-between-two-points-in-zoho.html

11 June 2019 than Zoho CRM. How? This function returns the distance as the crow flies. Update 2020 Not sure exactly when but Zoho have made available this function in Creator: = zoho.map.distanceBetween(, , ); // where unit can be "MILE", "KILOMETRE" or "NAUTICAL"...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 The same can be done to the desktop versions with open applications instead of just their icons. Why? MS Windows 10 has made a major step but when you close down your PC and log back in, all the applications are grouped into the one desktop. If you have...

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

Autohotkey - Chrome Profiles in Alphabetical Orderhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

07 January 2020 Chrome browser to list the multiple profiles in alphabetical order like it used to be... but to date they have not. So I made a program that lists the profiles in alphabetical order and can be double-clicked to open the Chrome browser with that profile....

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

Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

06 December 2020 test it by going to the report, hover the mouse over each row and a tickbox will appear, tick a few and click on your newly made button (as per the first screenshot on this article).

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 solution is a lot simpler than you might think... Doing the above, I would get a really messy response (I'm targeting an API made with ExpressionEngine) such as: Fatal error: Uncaught Error: Class '\Webservice\Service\Exception' not found in...

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

Zoho Creator: Receive JSON via a Shopify Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-receive-json-via-a-shopify-webhook.html

15 July 2021 up an integration from Zoho Creator to Shopify API. Why? In this example, we want a webhook that whenever an order is made in Shopify, it tells our Zoho Creator app. Note that at the time of this article, API v1 is deprecated (so no authtokens) and API...

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

Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

19 September 2021 of data. If your MD5 value is different, then it means there was a change. If not then it is unlikely that any change was made. Instead, I need to add an additional field called "eTag_Title", check if the new MD5 is different, if it is then I proceed...

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

Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 figure out so I don't spend so long the next time I have to do it. The use-case scenario here is that when an appointment is made for a Lead in a booking system, we want a task or call in CRM to popup and remind us that we need to phone this Lead. How?...

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

Zoho Deluge: a HTML Entity Decoderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-a-html-entity-decoder.html

27 January 2022 namespace such as zoho.encryption.htmldecode(string). But at time of print, it doesn't exist and in the meantime, I've made a function that does this. How? Not sure how else to do this but I simply wrote a function in Zoho Creator for each instance that...

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

Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 was achieved using some CSS and then some Deluge for the functionality. Let's dig into the CSS and then I'll explain how we made this functional. To prepare for this, I created the following Creator form: The fields: Calendar Day Select (link name:...

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