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

24 October 2014 employees are to be held harmless from any and all claims, liabilities, damages, and expenses (including attorneys’ fees actually incurred) on account of death or injury to any person or damage to any property or product arising from or in connection...

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

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

07 September 2015 Added alignment parameter ("float") relative to its container. - Added div and parameter "module class" so that class name actually works... - Trimmed any spaces from posted data and html code. - Used revolvermaps.com selection of "width x height"...

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

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

22 February 2019 with ID = container and have an image which covers them both... Which is an unintended but desired effect. Class .page: I actually like using this class because it's pretty descriptive. Unfortunately setting the width/height in cm was causing havoc to...

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

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

16 May 2019 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3 weeks 5 hours 7 seconds // where shown values are not zero Actually we just want the first two words of those strings: 3 days ago // where event is 3 days ago or just over but less than 4 days...

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

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

24 October 2020 Deluge for a few years now, even I thought of Zoho Widgets as a daunting task. But after doing some, I realize this is actually very quick to do and much easier than first thought. The article below documents how to create your first widget in a MacOS...

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

Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://joellipman.com/articles/crm/zoho/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

02 February 2021 from the customer portal in a ZohoCreator app to be able to download this file. How? The trick to doing this is that actually you have to treat it as an attachment. As you may already know, when you queried CRM for that field, you received a JSON...

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

Zoho CRM REST API: Stop Workflow from Triggeringhttps://joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

16 June 2021 record). There was also a workflow that ran when the Creator record was updated to update its changes to CRM. It was actually causing a loop which used up all the API calls. How? You might already be familiar with some of the trigger options below but...

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

ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

22 September 2021 v_AddressIndex = v_AddressIndex + 1; } // check that there was something to actually update rather than wasting an API call if(m_ShippingAddress.size() > 0) { // endpoint TLD is EU for Europe DC and COM for US DC v_Endpoint =...

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

Zoho Creator / Shopify: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

12 October 2021 search Shopify using a Product SKU. Community forums could only suggest looping through all the products. I then felt that actually I just need the Product IDs. This method could do with some refinement and perhaps if I find a better way to do this,...

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

Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

17 October 2021 URLs, give it the Image as attachment a base64 encoded string. Note the above says that 10 photos produced 10 webhooks but actually I'd overlooked the webhook used to invokeUrl download a Creator file so it was using 20 webhooks; the following reduces...

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

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 several calculations happen in real-time making it really difficult to extract and use. The key trick I used was to actually use a single-line text to store the customer's requested time. Let's use the appointment example mentioned above for a customer...

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

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 local to the customer and we want to remind our customer that they have an appointment in 1 hour with us. How? The code is actually pretty straightforward but you will need to follow these steps to get the credentials: Login to your Twilio console On...

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

Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

11 March 2022 form rather than a bidirectional form as in this example, the parent record doesn't yet exist... The cheat here is that we actually want the user to be able to click and download/open the attachments on the CRM record from within the Creator app. As for...

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

Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 all within the Zoho Creator app using Zoho Deluge and avoiding the use of any third-party APIs. How? My team of developers actually helped me solve this one as I was slowly dispairing... The Plan Get a list of all unique/distinct Customers Get a list of...

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

Zoho Deluge: Proper Case for Nameshttps://joellipman.com/articles/crm/zoho/zoho-deluge-proper-case-for-names.html

13 July 2023 of the Zoho Apps are incredibly case-sensitive and consider some records containing people's names as duplicates, when actually they are the same entity but may have uppercased a letter in their name while the other entry does not... This article is a...

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

Zoho Deluge: Determine your Statement Execution Limithttps://joellipman.com/articles/crm/zoho/zoho-deluge-determine-your-statement-execution-limit.html

31 July 2024 Setting a loop with leftpad limited to 100,000: Our trick of using the leftpad() method to build a list of any number is actually limited to 100000 as you will get an error saying: "Unable to execute function because the whitespaces to be padded cannot...

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

Windows 7 and Google Chrome incognito mode by defaulthttps://joellipman.com/articles/google/windows-7-and-google-chrome-incognito-mode-by-default.html

24 March 2010 to your start button). All the articles I googled were windows vista so I thought I'd share one for windows 7 here. I'm actually only saving you a click as you can just right-click on the google chrome icon and select "New Incognito Window". This is...

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

Change Regional Settings for your Reporthttps://joellipman.com/articles/microsoft/ssrs/change-regional-settings-for-your-report.html

17 May 2010 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter fields to UK format...

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

The Sandpithttps://joellipman.com/graphic-design/the-sandpit.html

26 September 2010 impressed. It's an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks like the same effect for the intro credits...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Oracle SQL - Convert given list (CSV) into Rowshttps://joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 || '' ) AS xmlval FROM DUAL) x, TABLE (XMLSEQUENCE (EXTRACT (x.xmlval, '/rows/row'))) d Yields: 1 2 3 4 5 6 Note that I actually used text in the example above and this worked. Obviously don't get the commas mixed up.

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB