Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

17 November 2021 following code which loops through some Creator records, then loops through one of the subforms in each record: // select a bunch of creator records (ok all of them) l_AllRecords = myForm[ ID != 0 ]; // // loop through these for each r_Record in...

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

AutoHotkey Ternary Operatorhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ternary-operator.html

27 April 2010 ThisVar:=2 Converted to Ternary this would look like: ThisVar:=(ThisCondition = true) ? 1 : 2 I'll add as there are a whole bunch of methods using the Ternary Operator in AutoHotkey (discussed on http://www.autohotkey.com/forum/topic29752.html) which...

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

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

28 June 2011 153) for an extension (Quicklist Weblinks) 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...

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

Alternative method of displaying Unicode in Autohotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/alternative-method-of-displaying-unicode-in-autohotkey-gui.html

29 September 2011 list of those that work for you: loop 255 fileappend,% a_index . A_Tab . A_Space . Chr(a_index) . "`n",ascii-chartable.txt A bunch of others that may work: Some others that may work: Dec Hex Unicode Char Description ------- ------- ------- -------...

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

Android Java: Remove first two entries from Google News feed in SimpleRssReaderhttps://www.joellipman.com/articles/google/androidos/android-java-remove-first-two-entries-from-google-news-feed-in-simplerssreader.html

24 October 2014 A quick article on how to remove the first two entries from a RSS feed produced by a bunch of java files collectively known as "SimpleRssReader. Why? The original file reads of a feed from PCWorld.com. I adapted this to read a google news rss feed and...

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

Windows Live Mail Error ID: 0x8DE00005https://www.joellipman.com/articles/microsoft/windows-os/windows-live-mail-error-id-0x8de00005.html

14 December 2016 remember the time when the Microsoft website became helpful but as they already have an article on this, I'm going to do a bunch of screenshots: The error is that I can't receive/send messages on this account. The problem has something to do with...

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

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 which is a hash or MD5 of all the fields of the record that I want to monitor. An eTag for me is simply an MD5 or hash of a bunch 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...

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

Zoho Analytics: Setup DataSource via FTP Connectionhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 So this is going to be an article with a bunch of pictures showing step-by-step of how I setup a recurring data source in Zoho Analytics via FTP. Why? The use-case here is that I have a client who wants to import data via FTP (SFTP - to be precise) and...

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

Zoho Analytics: Set Up a Widget Displaying Sales Personhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-set-up-widget-displaying-sales-person.html

24 October 2022 has clearly defined values based on the filters I select on a dashboard. First you will need a table or query that has a bunch of columns and rows with one of the columns containing the sale person name. Something like the following: With these kind of...

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

ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 really as I couldn't find much online to address the errors I encountered below but also to document the import process of a bunch of files into a ZohoCRM system. Why? Our use-case here is a data migration for a client from a legacy CRM to ZohoCRM. They...

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

Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 and Red Green Blue (RGB) values is somewhat difficult. What would be nice-to-have is if they could be presented with a bunch of colors and they click on one to select it. When are colors used? Well in this use-case, we are using it to color events in a...

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

PHP - Remove newlines and spaces from StyleSheethttps://www.joellipman.com/articles/web-development/php/php-remove-newlines-and-spaces-from-stylesheet.html

03 January 2020 What? This is a quick note on how to reduce a whole bunch of CSS into a single line without unnecessary spaces and new lines. Why? What I have: #copyright a{ margin: 10px 0 0 85px; box-shadow: 5px 5px 5px 0px rgba(51, 51, 51, 0.3); } What I want:...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: *