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

08 February 2022 10% discount, it would display as 10.00%. And they need the decimal because sometimes they might offer 12.5%. But when it displays in a template, it isn't that pretty to look at: Instead, could they have 10% to display instead of 10.00%, and display...

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

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

09 March 2022 Another article on styling a radio group to become a weekly calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous week. This is a follow on from my other articles on restyling...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 then I found you need to do an extra step in your Windows OS... Now for the BIOS: Restart your PC While it is booting up (displays NZXT logo), bash the "DEL" key every second or so. Go to "Advanced" > "Chipset Configuration" > Scroll down to "iGPU...

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

Zoho Inventory: Mark a package slip as delivered and shippedhttps://joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

14 July 2022 How? Here's a code snippet that works for me. It is triggered when a user ticks a decision box in Zoho Creator (on iPad displays as an on/off switch). My connection here called "jl_inventory" has the minimum required scopes:...

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

Zoho Books: Get Invoice Payment Terms via APIhttps://joellipman.com/articles/crm/zoho/zoho-books-get-invoice-payment-terms-via-api.html

06 July 2023 m_InvoiceDetails.put("payment_terms",-3); // adding label because -3 often displays "Net 56" instead. m_InvoiceDetails.put("payment_terms_label","Due end of next month"); // // loop through line items and populate for each m_SOLineItem in...

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

ZohoAnalytics & ZohoBooks: Custom Related List from Analyticshttps://joellipman.com/articles/crm/zoho/zohoanalytics-zohobooks-custom-related-list-from-analytics.html

09 July 2024 Map salesorder , Map organization , Map user , Map page_context ) Label: Related Purchase Orders Trigger: Displays on Sales Order record Purpose: To display related POs linked by a custom Sales Order lookup field on the Purchase Order line item. Inputs:...

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

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

14 October 2024 Picker To do this, we add one more option on the radio options which includes a button. When this input is clicked it displays the color palette and hides itself; when the color palette is clicked, it hides itself and shows the button. Code for Onload...

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

Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

18 August 2025 sales person; but all on one line and not that readable. Using a JS Widget, we can popup a window over the Zoho CRM which displays a more clear HTML & CSS styled message box. How? There are links to how to create a widget in detail which I'll link to at...

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

Search and Replace in a MySQL Databasehttps://joellipman.com/articles/database/mysql/search-and-replace-in-a-mysql-database.html

17 March 2010 phpMyAdmin or a MySQL Administration Tool (like Navicat or SQLYog), and still there at night editing each field so that it displays correctly... well that's usually me. Found it a bit boring but here's a short bit of code to speed it up which I now use:...

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

MySQL Commands to display all columnshttps://joellipman.com/articles/database/mysql/mysql-commands-to-display-all-columns.html

28 October 2010 the tables of the local database which had valid content to extract keywords from. The following is a MYSQL query that displays the structure of all the columns in all the databases of the localhost: SELECT * FROM information_schema.COLUMNS ORDER BY...

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

Mouseover Links in AutoHotkeyhttps://joellipman.com/articles/automation/autohotkey/mouseover-links-in-autohotkey.html

08 July 2011 GuiClose: close: Gui, Destroy ExitApp Now this results in a tiny GUI that displays the link in black and works (somewhat). If you copy the above code into an AutoHotkey file, you'll find this is remarkably temperamental. If the user is too quick with...

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

SSRS Repeat Headers in PDF Reporthttps://joellipman.com/articles/microsoft/ssrs/ssrs-repeat-headers-in-pdf-report.html

26 October 2011 request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header (which does not include the tablix header... obviously). I right-clicked on the header row of the...

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

SSRS Change Background Color of Imagehttps://joellipman.com/articles/microsoft/ssrs/ssrs-change-background-color-of-image.html

08 April 2014 the report would use the background color of the report. How? The issue exists if your image has transparent areas but displays the report background color instead: Right-click on the cell you want to put the image in. Insert > Rectangle Set the...

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

CSV Chart Generatorhttps://joellipman.com/component/content/article/csv-chart-generator.html?catid=40

04 September 2015 that AMCharts.com is free as long as you leave the copyright information. If you want to remove the copyright text that displays on the charts, you need to buy the products of AMCharts.com. I have no afiliation with these and I myself don't put any...

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