🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Problem & Questions with conditional Formatting

Chris Anderson asked on July 18, 2019

Please see attached screenshot and export. We have embedded FlexMonster into our application and providing it with data using CSV.
When I add conditional formatting to a column, it works some but not others. I tried to attach a video to this ticket but was not permitted to do so. Instead, I’ve added screenshots. I can successfully get the conditional formatting to work for one column but not another. You will see in the screenshots for “Patient PulseScore” any value equal to 3 should be highlighted red. However, other values are instead highlighted red.
The CSV Export attached is from FlexMonster (not the CSV we’re providing to it).
Please could you answer the following:

  1. Advise if I have done something wrong to cause what is described above or it’s a bug? Or whether we need to format the data in such a way when providing it to FlexMonster so that it will work.
  2. Is there a hierarchy to the Conditional Formatting, if there are lots of rules I want to add, which rules take precedence? Those entered first or last?
  3. Is there a way through the FM GUI to conditionally format a text field? I.e. Highlight if equal to “Oxygen”. I seem to only be able to enter a numeric value.
  4. Is there a limit on the number of conditional formats I can set?

Thank you,

2 answers

Vera Didenko Vera Didenko Flexmonster July 19, 2019

Hello, Chris,
Thank you for writing to us.
1) We have noticed that certain values which the conditional formatting rules are applied to are of type string instead of number.
Our team kindly suggests specifying the data type for the CSV columns.
For example, by adding the - prefix to the “Patient PulseScore” column you can ensure that Flexmonster will interpret “Patient PulseScore” as a numeric measure:

"-Patient PulseScore", "Patient Consciousness"

Afterward, the conditional formatting rules should work as expected.
2) We would like to explain that it is possible to apply several conditional formatting rules to the same measure. However, if conditional formatting rules are specified which override each other, then the rule entered last will take precedence.
3) It is not possible to highlight a text field via conditional formatting rules. However, you can highlight text fields with the customizeCell() API call.
Here is a JSFiddle example for illustration.
4) We would like to point out that Flexmonster allows setting as many conditional formats as you like, there is no limit.
Please let us know if this helps.
You are welcome to contact us in case of questions.
Best Regards,

Chris Anderson July 19, 2019

Thanks Vera, we’ll implement and report back. Much appreciated.

Please login or Register to Submit Answer