DJI Phantom FC40 - Fun at the raceshttps://joellipman.com/articles/_other-misc/quadcopters/dji-phantom-fc40-fun-at-the-races.html

17 September 2014 good on this camera so it was no use here, so several challenges: No FPV: Keep the quadcopter pointed at the car. I treat it like a First-Person-Shooter game where I strafe right moving forwards in an arc to go round corners. Then I learnt there were so...

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

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

10 October 2014 prompted to import the 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...

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

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

24 October 2014 is understood by the api.openweathermap.org website. There are plans to shift this to using Google Services as they are more likely to find locations that openweathermap.org cannot. Add a comma and the two letter country code (preferably "iso-3166-1...

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

Joes Search Module (JSM)https://joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 and then a list of components. Find the value of the checkbox by viewing the HTML source and you should see something like the following: // take the value of the checkbox (eg. doc_indexer) I have set the module by default to only search one area, but...

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

Warning: Save failed. Another menu item has the same aliashttps://joellipman.com/articles/cms/joomla/warning-save-failed-another-menu-item-has-the-same-alias.html

13 March 2015 table Search for any values in the `alias` column that match the term (eg. for "about" do SELECT * FROM #__menu WHERE alias LIKE '%about%' where #_ is the table prefix) Instead of deleting, I change the existing menu item alias from "about-us" to...

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

Joes Revolver Map (JRM) Downloadshttps://joellipman.com/component/content/article/joes-revolver-map-jrm-downloads.html?catid=92

07 September 2015 created (English GB only) - Date Uploaded: Fri, 9th Jul 2010 1.0- Added GNU/GPL License information to xml/php - Behaves like custom module and inserts RevolverMaps script. - Date Uploaded: Fri, 2nd Jul 2010

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

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

23 October 2015 403 http://www.joellipman.com/error/403.html # change this to your 403 - forbidden page. These are two methods I like and will work in tandem. They will not affect the standard visitors to your Joomla website (specifically those not interested in...

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

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

30 October 2018 + minutes).slice(-2); str3 = ("0" + seconds).slice(-2); return str1 + ':' + str2 + ':' + str3; } The HTML would be something like: Time Remaining: Time Elapsed:

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 It is taken from Google's documentation as well as other forums and websites that try to explain it. Do not waste your time like I did on the public key, verifying a JWT signature, or including any third-party libraries. You can do it in pure PHP and...

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

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

14 February 2019 will apply to each row and increment based on how you copy the formula to other cells. You should end up with something like this (I have added some conditional formatting which colors the cells red or green for demonstration purposes): If you...

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

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

06 May 2019 with a value that already exists in the table, you will get an error in which case you could probably add another trigger like above but with BEFORE UPDATE ON my_table_name. Source(s): Online regex tester and debugger: PHP, PCRE, Python, Golang and...

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

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 random, it involves getting the milliseconds from a time object. v_Uid = zoho.currenttime.toLong(); // returns something like 1557400230165 Method #1: 5 Randomly Selected Letters Using a snippet from the community forums on how someone shuffled a pack...

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

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

07 January 2020 program will be redundant if Google ever update their 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...

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

Zoho Deluge: Get Image Uploaded in Creator Formhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-image-uploaded-in-creator-form.html

14 July 2020 + "/MyImage/image-download/" + v_PublishKey; v_ImageSrc = v_ImageSrc + "?filepath=/" + v_Filename; // yields something like...

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

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

12 August 2020 you need and click on the plus icon to add each one. Keep "Use credentials of login user" ticked. You should have something like the following: Click on "Create and Connect" You will get a popup confirming what this app will access and you should click...

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

Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

06 November 2020 the same popup link in the parent window. The solution however is to remove the base URL and only keep the URL as something like #Page:Notify. Do NOT add the base URL such as https://creatorapp.zoho.com/myowner/myapp/#Page:Notify. CSS styling affects...

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

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

06 December 2020 Name the workflow Execute the action for Collection of record (this step is very important!) And you should have something like the following: Click through on "Add New Action": Select "Deluge Script" Select an event: Run a function: And the next screen...

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

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

10 December 2020 We asked Zoho for a solution that might work and were given the following snippet of code (not tested yet!). It looks like we have to fill in the blanks and it's on the same path as we were. The main revelation was the function getEmployeesOnLeave and...

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

Zoho Deluge: Convert Map to HTML Table without a FOR loophttps://joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-html-table-without-a-for-loop.html

11 January 2021 2 How? This is a bit of a dirty solution and as long as "id" is not your first column (because "id" can be found in names like "David") it will work. Assume a Map specified in deluge: l_Data = List(); m_Data = Map(); m_Data.put("First_Name","Joel");...

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

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

03 February 2021 the odd thing is that Zoho's request adds double-quotes to the request and escapes the other double-quotes sending something like this: { "auth": "{\"secret\": \"can_you_keep_a_secret\",\"key\":\"aaabbbbccccddddeeeeffff11112222\"}", "data":...

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