Joes FREE Website Thumbnailer (JWT)http://mail.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 I wrote for an OpenSource CMS. Could also be of some use if your portfolio is a bunch of online websites and you need screenshots of these. Whatever the reason, I needed a FREE option and everything available had a limit to its "FREE" services. There...

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

Zoho Templates - Font size is inexplicably tinyhttp://mail.joellipman.com/articles/crm/zoho/zoho-templates-font-size-is-inexplicably-tiny.html

22 February 2019 is one of those that you wouldn't consider relevant in this case, after all, all styling was removed... Here are two screenshots to demonstrate the issue: Screenshot #1: This screenshot is of the PDF preview of my HTML code where I've had to set the...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttp://mail.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 on the "Leave" form. p_LeaveTill this is the value of "To" on the "Leave" form. Giving you something as per the following screenshot: Click on "Save" to accept this Note: It is important to add these parameters rather than trying to retrieve the details...

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

Quadcopter App with Flight Restrictions (JQA)http://mail.joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 of numbers!). Tap on Quick Reference image to change image. (if you have a different led, you can take a picture or use a screenshot Tap on the "Save" icon to save all changes (this also lets you change the name of the aircraft & configuration)...

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

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 then press Enter (DO NOT START TYPING FOR A MODULE NAME - LET THE SYSTEM POPUP YOUR OPTIONS AS PER THE FOLLOWING SCREENSHOT - USE ARROW KEYS OR MOUSE): As you can see from the screenshot above, there are modules concatenated with one module an "X" and...

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

Zoho CRM: Update a custom field in line items / product details using REST API v2.1http://mail.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 tax, etc. In the example below, we have added a column called "Group Name" in the CRM Quote module as per the following screenshot: How? Again at the time of this article, this is only modifiable when using REST API v2.1. We are going to update the...

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

Docman - Uploaded a document and can't see ithttp://mail.joellipman.com/articles/cms/joomla/docman-uploaded-a-document-and-cant-see-it.html

29 June 2009 showing: Check that they're in the right section and category Check that they have been approved and published This is a screenshot of two uploaded documents:

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

SQL Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 the Dates cte can recurse OPTION (MAXRECURSION 100) I'd appreciate if you bear with me as I add captions to the below screenshots: Design the Query: So copy the above text, click on query builder and "edit as text", then paste it into there. When you ok...

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

SSRS Parameters in Oracle Stored Procedurehttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 the Stored Procedure as "SP". You can specify command type and stored procedure name here or you can do this in the next screenshot. Note how all our variables are hidden and cannot be NULL. If you're unsure, right-click on your dataset and bring up its...

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

Returning Oracle Stored Procedure Resultset in SSRShttp://mail.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 parameters in my example as I didn't end up using them) 4. Add a dataset Follow these steps carefully. I've added some screenshot images to help and highlighted areas which you should ensure are correct (or which applies to your report) 4a. Add a...

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

Export/Import Database using MySQL Workbenchhttp://mail.joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 Take Parameters from Existing Database Connection option (note that I have obscured my personal settings in the following screenshot): In this screen, I've opted for Do not use Remote Management as I only want to export/import my database: Connected!...

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

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

12 April 2013 report would hit a bug where it couldn't work out that 10 (Wednesday) happened after 8 (Monday). How? See the following screenshot and note the dates for Monday, Tuesday, Wednesday, and Thursday: Note how amusingly Microsoft thinks Wednesdays come...

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

Excel: Find values in one column that are not in anotherhttp://mail.joellipman.com/articles/microsoft/excel/excel-find-values-in-one-column-that-are-not-in-another.html

06 March 2014 -- Returns #N/A for a value which is NOT in column A. Drag the formula in B2 down all the list as per the following screenshot. A value equal to "#N/A" means the value was NOT found in column A. Method #2 Be careful with this one because if you copy the...

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

Basic Android App using Google Maps and Current Locationhttp://mail.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 classes then agree by clicking OK: If you are not prompted, you should see some of your code go red like in the following screenshot: Focus the cursor on the word and hold down the key and press Enter, then import each class: Your code will now include...

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

Excel - Check a column for values found in another columnhttp://mail.joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

14 February 2019 purposes): If you understand this article, you may have noticed that the range of words to find from Sheet2 in this screenshot are from the cells B1:B4... This is because I already had values in A1:A4 and wanted to test against a set of different words.

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

Minimal Privileges for MySQL Database Backup Cron Jobhttp://mail.joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 SHOW VIEW ON 'my_live_db'.* TO 'mybackupuser'@'localhost' IDENTIFIED BY 'mybackupuser'; Or via cPanel the following screenshot when adding a user to a database: Method #1: The following command on a cron job: // not recommended: /usr/bin/mysqldump -u...

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

Convert Past Date to Time Ago in PHPhttp://mail.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 used this for password change reminders but on this occasion for a listing of reviews laid out as per the following screenshot:

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

Zoho Deluge: Setup an API Connection for InvokeURLhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 If it says zoho.in, then this is the India datacenter. View the attached if this is still confusing. The following screenshot is of a client's Zoho Books instance opened in a browser. the circled part is the domain of the Zoho app we are accessing: Here...

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

Zoho Creator: Create a Widget which uses JavaScripthttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 and add a parameter, in this case "name": Great! Now access this application and preview your masterpiece! The following screenshot shows what happens when I change the parameter: Additional Note(s): I have found that adapting Widgets created for Zoho...

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

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

06 December 2020 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: *