Need a special offer?Find out if your project fits.
+

Conditional formatting on text fields

Answered
simple asked on September 11, 2016

 Our customer is looking for ability to use conditional formatting not just on numbers but text fields.  I tried this but it does not seem to work

7 answers

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster September 12, 2016

Hello Kevin,
Thank you for your question. Unfortunately, there is no such feature in the component and there are no plans on adding it in the next version. Please let us know how critical it is for you.
Best regards,
Dmytro.

Public
simple September 12, 2016

It was the first thing our customer asked for as their "other" tools do this.  I would say grouping with totals in flat view would sightly be higher priority

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster September 12, 2016

Hello Kevin,
Thank you for your response. We have added your request about conditional formatting for the text fields to the customer's wish list.
Best regards,
Dmytro.

Public
Sengupta February 23, 2017

Hello Dmytro Zvazhii
Do you have any estimated release date of this feature? I have same issue as "simple"
Also, For a given a row, will it be possible to conditional formatting a column, depending on another column
i.e. For a given row - change background colour of column A depending on value of column B?
 

Public
Tanya Gryshko Tanya Gryshko Flexmonster February 24, 2017

Hello Sengupta,
Thank you for your question. I am afraid I cannot provide you with an estimated timeframe right now. However, we have added the feature "Add conditional formatting of column A depending on a value of column B" to the customer’s wish list, as well as "Conditional formatting on text fields". We will take these features into account when discussing future Flexmonster improvements.
Regards,
Tanya

Public
Scott Oliver April 14, 2020

Hello Tanya,
 
Is there any update on this feature? I'm looking for the same functionality. For example, if the value in column "A" is greater than the value in column "B" than red, otherwise green.

Attachments:
Flex Example.png

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster April 15, 2020

Hi Scott,
 
Thank you for posting your question.
 
It seems like in your data you are using regular numeric values instead of string values. In this case, the desired behavior can be achieved with the already existing conditional format functionality. 
 
To highlight cells with a specific color based on their value's comparison with other numeric values, you will simply need to define the corresponding array of Conditional Format Objects in your report configurations:
 

report: {
dataSource: {
data: getData()
},
conditions: [
{
"formula": "sum('Actual') = sum('Forecast')",
"measure": "Category",
"format": {
"backgroundColor": "#ffd942"
}
},
...
...

 
We've prepared a quick JSFIddle example to illustrate the mentioned approach: https://jsfiddle.net/flexmonster/9hru6dxq/
 
Also, you can find more info on conditional formatting in Flexmonster by the following link: https://www.flexmonster.com/doc/conditional-formatting/
 
Please let us know if this helps.
 
Best regards,
Mykhailo

Please login or Register to Submit Answer