Get Free Trial
Get Free Trial

How to customize a cell of one column based on another cell of another column

Juciley de Lima Costa asked on August 30, 2019

Example: If the cell value of one column is 5, the color of another cell in another column changes.

5 answers

Public
Vera Didenko Flexmonster September 2, 2019

Hello, 
 

Thank you for writing to us. 
 
 

At the moment applying conditional formatting to a cell based on another field’s value is not supported.
Could you please let us know how critical this feature is for you?

Best Regards,
Vera

Public
James November 12, 2019

Hello Vera,
This feature is a must for us. Do you think it will be developed in the near future?
 
We have a list of values confronted to a “target” value and i want to higlight them in red when the % between value and target is less than 100 (this percentage is in another column). Unfortunately we can’t calculate it during execution as percentage is calculated based on different algorithms for each value.
 
Best regards,
James

Public
Vera Didenko Flexmonster November 13, 2019

Hello, James,
 
Thank you for writing to us.
 
We are glad to inform you that the ability to format the value field based on the condition made on the different value has been added recently. 
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/ .
 
For now, you can specify the measure to what you need to apply a condition through the formula property. The measure property defines the field you want to format.
Here is the JSFiddle example: http://jsfiddle.net/flexmonster/rqnkbpet/ .
 
Currently, you can use it only through the API. The UI requires some extensions on your side. The toolbar code is open-source and you can re-use it to support your custom use case. The conditional formatting code is located on the line 1556 (showConditionalFormattingDialog). We recommend applying your custom view using the customize toolbar approach: https://www.flexmonster.com/doc/customizing-toolbar/ .
 
Please let us know if you have any questions.
 
Best Regards,
Vera

Public
James November 14, 2019

Hi Vera,
Thank you for your quick response. We tried adding this feature to our development following your jsfiddle example and it took as while to realise that it doesn’t work in case of “Flat form” grid layout option. Can you please fix it in this grid form?
 
Best regards,
James

Public
Vera Didenko Flexmonster 7 days ago

Hello, James,
 
Thank you for your feedback.
 
You are right, having this feature also available for flat table sounds reasonable.
Our team will research this further and we will notify you about the results with the ETA 16th of December.
 
Please let us know if you have any questions.
 
Best Regards,
Vera

Please login or Register to Submit Answer