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

06 February 2020 A quick article on how to debug some errors in Zoho. Why? I wanted a general note to list certain errors that we get when we do certain things in Zoho but didn't want to write a separate page for each minor issue. How? So I'm going to try and list...

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

Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

29 January 2021 me on sorting a map variable in Zoho Deluge, specifically Zoho Creator. Why? I do this a lot but in the following example, I want to sort a list of records by their date in descending order. Yes this functionality exists in reports but I want to do it...

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

Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

24 September 2021 A quick note for when I want to quickly generate maps of a currency or a tax from a client's Zoho Books. Why? The use-case here is that we are creating a Sales Order in Zoho Books from Zoho CRM and want to map the correct currency and tax by their ID...

• 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 is required in the form of a left arrow and right arrow to see previous or next weeks respectively. What I have: What I want: How? This was achieved using some CSS and then some Deluge for the functionality. Let's dig into the CSS and then I'll explain...

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

Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=40

26 May 2010 off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a donation :c) BACKGROUND: Originally dubbed EventViewer Chart Generator. As...

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

Migrate Joomla! 1.5.x to 2.5.x+https://www.joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 spend without it. This is not an upgrade; it is likely that your client may reconsider the template they are using or may want to add new 3rd-party components. If asked: "how long will it take", do not say 5 minutes. This script runs on average in 15...

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

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 NULL Size of rendered reports in bytes. RowCount bigint NOT NULL Number of rows returned from queries. Conversions Needed: I want to convert a start and end date to a single time value (hours minutes seconds mseconds) I want to total 3 of the columns...

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

MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 ...resources in row (along the side)......staff in columns (along the top)......persondays in values (the number my bosses want - 7h 24m or 26640s is 1 person day)... With date range as parameters...ouch......and it was so easy up to here... Tables...

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

Search a database for a value and count matching rowshttps://www.joellipman.com/articles/database/search-a-database-for-a-value-and-count-matching-rows.html

05 November 2012 We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called "WarehouseLoadKey" and the value we want to search on is...

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

Joes Revolver Map (JRM)https://www.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=40

07 December 2012 Visit the website http://revolvermaps.com/?target=setup Configure the map to the settings you want. Copy the ID reference as per the "Important Note" below. Login to your Joomla website admin panel Install this module as per usual (will auto-install) Go...

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

Split a row into multiple rows based on a column valuehttps://www.joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 which employee, on what date, and for how many days they were off sick. When migrating to a new system, the destination wanted 1 row per day. This meant that if in the old system, there was 1 row with an employee who took 2 days off, we would want 2...

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

htaccess Rewrites SEF URL and submits to PHPhttps://www.joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 do apply the above to your site, bear in mind the following is also true: http://www.mysite.com/blog/pretty_much_anything_i_want_to_type_here.html --yields...

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

Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 does not match: def Non-Matching Character List Use the non-matching character list to specify characters that you do not want to match. Characters that are not in the non-matching character list are returned as a match. For example, to exclude the...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Hide a Drive per User in Windows 7https://www.joellipman.com/articles/microsoft/windows-os/hide-a-drive-per-user-in-windows-7.html

28 March 2014 on the DWORD you just created and click on Modify. Type in the drive option hex or decimal number from the list below you want to set as restricted, and click on OK. -- Restrict multiple drives by adding the values together -- For Example: To Restrict B...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 Excel report which dynamically gets its content from a data source located on a database on the other side of the world. I want the header in the column "Academic Week" to break across two lines so that the column doesn't expand to the width of...

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

SITS: Export field code and namehttps://www.joellipman.com/articles/web-development/xml/sits-export-field-code-and-name.html

12 August 2014 SITS:Vision Students (v8.7.0) What? You might be able to work it out from the online manuals but it took me a while, we wanted to bring back both the code and the lookup value in our XML to our Staging environment. Why? Let's take the country of birth...

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

List of Font Awesomehttps://www.joellipman.com/articles/web-development/list-of-font-awesome.html

04 September 2015 I needed to use these in a template I was working on. Font awesome is a brilliant tool for webdevelopers who want icons that can be any size of any color without compromising on image quality or overhead maintenance. It's basically a font set that has...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

URL Alias uniqueness with PHP & MySQLhttps://www.joellipman.com/articles/web-development/php/url-alias-uniqueness-with-php-mysql.html

06 May 2019 long sentence; let me try this: When I save a record in JoomlaCMS or WordpressCMS It creates a unique name to use in URLs I want that Why? These are used as inputs to server-side scripts for the sake of search-engine friendliness. There are no silver...

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

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 parameters should simply load the app without resizing it to the maximum width/height of the screen. Windows 10 Mail Lastly: Want to start a built-in app in Windows 10 (not found in your program files etc) like Windows Mail? Open a run command and type:...

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

Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

20 August 2019 A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually and...

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