Zoho CRM & Zoho Books: Custom Related Lists Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists. Why? Because I keep forgetting how to do this and it takes about an hour to go through the documentation and get a working...

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

Fun with DllCall in AutoHotkeyhttp://mail.joellipman.com/articles/automation/autohotkey/fun-with-dllcall-in-autohotkey.html

27 September 2011 from the end-user. The one to rule them all: This is a function I pulled from the Autohotkey forums submitted by SKAN which lists all the functions for a specified Dynamic Link Library (DLL) along with an inputbox for convenience: InputBox,...

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

Compare two databases using T-SQLhttp://mail.joellipman.com/articles/database/t-sql/compare-two-databases-using-t-sql.html

24 September 2013 t1.COLUMN_NAME=t2.COLUMN_NAME WHERE t1.COLUMN_NAME IS NULL ORDER BY t2.COLUMN_NAME Method #3 And a further enhancement which lists the different datatypes, is_nullable, maxlength and collations side-by-side: -- all columns side by side SELECT...

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

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

07 January 2020 (Official Build) (64-bit) AutoHotkey v1.1.30.01 What? This is an article to create a standalone application which lists all the Google Chrome Profiles on your Windows 10 workstation in alphabetical order. Why? This program will be redundant if Google...

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

Amazon Kindle: Send PDFs to your Kindlehttp://mail.joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 your region. Sign in with your Amazon username and password. After you have logged in, look for the menu option Account and Lists which should show somewhere along the top right of the home screen. Under Account and Lists, look for Your devices and...

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

Zoho Deluge - Get Full Day Namehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

08 November 2018 My_Date = today; Day_Name = My_Date.toString("EEEE"); // returns "Monday" Method #1: We're going to populate two arrays / lists; retrieve the index value; and use this in the second array as follows: // lists Day_Names =...

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

Joe's Unduplicater (JUD)http://mail.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

12 July 2010 to ignore prefixes and suffixes to the filename. - Colored the folder to keep in Green and the one to delete in Red. - Lists failed deletions if there are any. - Changed browsing code to loop through folder of files to REMOVE. - Changed code to loop...

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

Passwords: Did-you-knowhttp://mail.joellipman.com/hardware/passwords-did-you-know.html

15 November 2010 a speed of 76.1 billion passwords per second! (source: Lockdown.co.uk 01/2007) By default, the Mozilla Firefox browser lists your stored passwords in plain text to anyone with access to your browser through the tools > options > security > Saved...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Sort order a dropdown list in MS InfoPath without programminghttp://mail.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 or list Copy the URL/web address from your browser which has the datasheet open (eg. "http://your_sharepoint_server_name/Lists/your_list_name/Allitemsg.aspx") Select the name of your list (I know I thought we already did this but hey ho) Select the...

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

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

02 September 2011 the report) varchar2 and a JobID (request reference) number. The Report We start off with our detailed report page which lists all the details of a student. There is a textbox linked to an action which will open another report (the confirmation page)...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure...

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

Search a database for a string (MySQL, T-SQL)http://mail.joellipman.com/articles/database/search-a-database-for-a-string-mysql-t-sql.html

08 October 2012 I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an...

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

Improve Default Joomla Search http://mail.joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 the frontend as option in advanced search: FUNCTIONALITY \components\com_search\views\search\view.html.php: // built select lists $orders = array(); $orders[] = JHtml::_('select.option', 'newest', JText::_('COM_SEARCH_NEWEST_FIRST')); $orders[] =...

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

Google Authentication - OAuth 2.0 using PHP/cURLhttp://mail.joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 This is an article which lists the functions necessary to process Google Authentication using OAuth2.0. These functions allow a script to simply be loaded and to either create a token file, or use the existing one as long as it hasn't expired. Update...

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

Zoho Creator: Retrieve record with case-insensitive queryhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

21 November 2019 ... Other Functions of Interest contains case-sensitive search, can be used on strings or lists containsIgnoreCase case-insensitive search endsWith endsWithIgnoreCase equals equalsIgnoreCase matches notContains though I tend to use !myVar.contains()...

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

Zoho Deluge: Duplicate/Clone a Recordhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

17 March 2020 "ZohoCRM.settings.fields.READ" Click on "Create" and then on "Accept" in the popup. You should be redirected to a page which lists the "status" as connected as well as a snippet of Deluge for the usage Source(s): Zoho CRM Developer - getFields Method -...

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

AutoHotkey: App GUI Listview to Rename Fileshttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

08 July 2020 The 3rd button simply reloads the app (used mostly for testing/development). Lastly, a listview that has 2 columns: the 1st lists the files in that directory, the 2nd displays the new filenames of the files. ; ; Language: English ; Platform: Microsoft...

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

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

03 February 2021 on line 86 Rather than assuming Zoho Deluge maps and lists are JSON variables, let's send a strange hack instead: m_NestedRequest = Map(); m_NestedRequest.put("auth[key]",v_AuthKey); m_NestedRequest.put("auth[secret]",v_AuthSecret);...

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

ZohoDeluge: Inserting a new line character in a CSVhttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-inserting-a-new-line-character-in-a-csv.html

01 March 2023 using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file given some lists and strings and although the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a...

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

ZohoCRM: Get All eBay Active Listingshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 m_ActiveList.put("ListingType","FixedPriceItem"); m_ActiveList.put("Sort","ItemID"); // // exclude other lists m_Exclude = Map(); m_Exclude.put("Include", false); m_Params.put("DeletedFromSoldList",m_Exclude);...

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