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

07 December 2021 = input.Customers_Requested_Time.toTime(); v_CustomerTimeZoneName = "(+01:00) Europe/Luxembourg"; v_CustomerOffset = "+01:00"; // // calculate GMT v_CustomerPlusMinus = v_CustomerOffset.subString(0,1); v_CustomerHours =...

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

Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 date but more like the today's date minus 7 or plus 7 days depending on which way they navigate. We then need the offset so that when a user clicks on the #9 entry, the system will know this is March 9th 2022 and not June 9th 2021... To do this, we have...

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

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 where can contain up to 25 criteria. Use parenthesis for precedence. Pagination: LIMIT offset, limit: v_CoqlQuery = "select id, Deal_Name from Deals where ((Amount=0) and (Stage != 'Cancelled')) limit 400,2"; // returns 2 deals after the first 400...

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

Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

07 March 2025 through pages to fetch as many as possible for each v_Page in {1,2} { info "Page #" + v_Page; v_PageFactor = v_Page - 1; v_Offset = v_PageFactor * v_PerPage; // // get unique product names (v2 up to 200, v6 up to 10k, v7 up to 100k) m_Params =...

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

Cheat Sheet for mySQL vs t-SQLhttps://www.joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [, offset]) PATINDEX(%needle%, haystack) CHARINDEX(needle, haystack [, offset]) String Concatenation CONCAT(string1,string2[,stringN]) string1 + string2...

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

Joes Quicklist Weblinks (JQW) Downloadshttps://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

07 September 2015 only) - Parameter: Popup Text Color - Parameter: Popup Border Color - Parameter: Popup Background Color - Parameter: Popup Offset X (relative to link) - Parameter: Popup Offset Y (relative to link) - Modify Parameter: Added Ordering: Random - Modify...

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

MS Excel - Split Workbook into separate files per sheethttps://www.joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 Application.ActiveSheet.Range("A1").PasteSpecial Set xRow = xRow.Offset(SplitRow) Next Application.CutCopyMode = False Application.ScreenUpdating = True End Sub Press F5 to run the code. This will prompt you twice: It is prompting you for the range of...

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

Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 // NB: range is an integer and the number of records to return (default=100; max=200) // NB: index is an integer and is the offset or starting index (not the ID of the record) m_Params = Map(); m_Params.put("range",50); m_Params.put("status","closed");...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 ParseDisplayName Or path ;#end region ;#region STRRETFlags Const STRRET_WSTR = $0000 ;// Use STRRET.pOleStr Const STRRET_OFFSET = $0001 ;// Use STRRET.uOffset To Ansi Const STRRET_CSTR = $0002 ;// Use STRRET.cStr ;#end region ;#region...

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

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 position of the extract, and a third string (2a) to specify the closing position of the extract. NeedleMarker is the offset and means when this function is used for several tables, the Needlemarker tells the function to start from where it last found a...

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

Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 set to EST (America/New_York) v_SystemCallTime = '2021-11-19 11:12:34'; // // manual setting to specify system/application offset v_ApplicationTimeOffset = "-05:00"; // // customer is in (America/Los_Angeles) v_CustomerCallTime = '2021-11-19 08:12:34';...

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

Zoho CRM: Manage a subform using Client Scripthttps://www.joellipman.com/articles/crm/zoho/zoho-crm-manage-a-subform-using-client-script.html

09 December 2022 var v_LocalStartDate = new Date(v_StartDateValue); // accommodate for timezone offset v_LocalStartDate.setMinutes(v_LocalStartDate.getMinutes() - v_LocalStartDate.getTimezoneOffset()); // return in yyyy-mm-dd format (on save this will display as per the...

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

Excel: Extract hyperlink from linkhttps://www.joellipman.com/articles/microsoft/excel/excel-extract-hyperlink-from-link.html

06 November 2014 the Excel user defined function below Sub ExtractHL() Dim HL As Hyperlink For Each HL In ActiveSheet.Hyperlinks HL.Range.Offset(0, 1).Value = HL.Address Next End Sub Press F5 and click “Run” Get out of VBA (Press Alt+Q)

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