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

08 July 2020 (eg. 01_23) ; and then add an increment to the file name if a file with the same name exists. ; ; Date (v1.0): 8 July 2020 ; - Initial Release ; Date (v1.1): 10 August 2020 ; - Checks for duplicates done by searching its own column. ; - Also checks for...

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

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

08 November 2018 (eg. "Mon"). My_Date = today; Day_Name = My_Date.toString("E"); // returns "Mon" How? Well a few methods. Method #0: Update 2020 Tested in CRM and Creator and this is working: My_Date = today; Day_Name = My_Date.toString("EEEE"); // returns "Monday"...

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

Zoho Deluge - Get distance between two coordinateshttps://www.joellipman.com/articles/crm/zoho/get-distance-between-two-points-in-zoho.html

11 June 2019 has only been tested in Zoho Creator rather than Zoho CRM. How? This function returns the distance as the crow flies. Update 2020 Not sure exactly when but Zoho have made available this function in Creator: = zoho.map.distanceBetween(, , ); // where...

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

Zoho Deluge - InvokeConnector and useful snippetshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-invokeconnector-and-useful-snippets.html

23 January 2020 for each v_User in l_Users { info v_User.get("full_name") + " :: " + v_User.get("id"); } } } Update 2020: Note this can also be achieved with the following shortcode: l_Users = zoho.crm.getRecords("users"); or a specific user: r_ZohoResponse =...

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

Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 after reading the official documentation and going through the online discussion forums to build this solution. As of May 2020, this is how I do it. How? So the trick is, go over the official documentation, but don't take it as gospel. You only really...

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

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 to what the documentation that says "This task can be used in the following events", effective as of today October 19, 2020, I have not found a place you cannot use this deluge script. The ZC_SUBFORM_250 error is because I am trying to assign the...

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

Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 info dateValue.toString("yyyy"); // returns 2019 dateValue = '29-Dec-2019'; info dateValue.toString("YYYY"); // returns 2020 You should also pad single digit week numbers if we're going to store a year week value: v_ThisCurrentWeekNumber =...

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

ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 A follow on from my article Zoho Creator: Create a Widget which uses JavaScript back from 2020 with a few adjustments now in 2024. This widget will only work within Zoho Creator. If you want a solution which sits on an external website and which talks...

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

COVID-19: Working from Homehttps://www.joellipman.com/covid-19-work-from-home.html

05 July 2020 it's pretty important not to be slouching over the coffee table for hours or days on end. I was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months...

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