Last week, we added a colorization option to Numeric- and Duration-type columns. This option provides a simple way to colorize column values.
Just activate the Colorization checkbox and specify conditions and colors. If a numeric value (or duration value) is less than an indicated number, a field keeping such a value will become highlighted by selected color. Also, a color of an alternative value can be specified in the “otherwise” field.
Let’s consider two examples:
Colorization of Numeric (or Formula-Numeric) column values
Say, there is a “Statistics” column where you register an increase or decrease of a number of customers per month and you would like to highlight negative values in red.
So, you need to edit column settings and configure the following colorization rule:
Colorization of Duration (or Formula-Duration) column values
Assume that there is a “Delivery Days” column in your database and you need to highlight column values depending on a number of days. If a value is less than five days, it should be colored in yellow, if less than two – in orange. The other values should be highlighted by green color.
To configure colorization rule, you should edit column settings and add the following colorization criteria:
In both examples, the foreground color (black/white) is detected automatically and based on background’s luminance, so, you can use dark and light colors themes as you prefer.
Choices in a Single Line
We received multiple requests from our customers regarding choices listed in a single line. Now the “Display choices in a single line” option is available in the Text column settings and it can be rendered either as Radio Buttons choices
or as Check Boxes multi-selects.
Read more details about the Choices option in this Text Column article.