Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

20 August 2019 What? A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it modified the record, the tax wouldn't apply both visually...

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

Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

08 February 2022 What? A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho Deluge - Some Useful Regular Expressions list but I...

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

Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 ($_GET array), all the submitted data on the front-end of my component is controlled and not customizable. I fixed this by removing the reference to router.php within the installation XML file. (router.php). I even deleted the router.php file from my...

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

Trim in T-SQL and SSIShttps://www.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html

14 May 2013 Some methods of removing trailing spaces, tabs, carriage returns and line feeds (new lines). How? First in Transact-SQL: SELECT RTRIM( REPLACE( REPLACE( REPLACE( @myString, CHAR(9), ''), CHAR(10), ''), CHAR(13), '') ) -- CHAR(9) = Tab -- CHAR(10) = Line...

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

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

22 February 2019 is of the PDF preview of my HTML code where I've selected a quote and applied a template to it: The Solution After removing all styling, taking away classes and ID fields that might have been reserved for Zoho rendering (which did nothing to fix this...

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

AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

18 July 2019 left and centre should with the central screen starting at coordinates 0,0 (might be different on your setup)... Note that removing the width and height parameters should simply load the app without resizing it to the maximum width/height of the screen....

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

Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 then escape the double-quotes, then prepend with a list declaration and append with a end of list suffix; loop through removing HTML tags and while we're at it, storing it in a list for Zoho Deluge: First of all, here's the HTML SELECT dropdown I just...

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

Zoho CRM: Change System Field Lengthhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-change-system-field-length.html

19 June 2023 translations file to change system field labels The fix put simply is a CSS hack. Specifically by inspecting the element, removing some of the CSS attributes on the field we want to change, saving it, then returning the "Lead Conversion Mapping" page,...

• 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 An article on removing duplicate products within ZohoCRM. Why? Product duplicates are a common issue during development, especially when we have products imported via a feed or API or simply by staff and their spreadsheets. There is a deduplication...

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

Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

28 June 2019 (not selected items) for each r_EntryID in l_AllowedEntries { input.myLookup:ui.add(r_EntryID); } Additional Note(s): If removing elements, even if you are using Creator v5, use removeElement() and NOT remove() which got me stuck for a while. This is...

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