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

How to have all the column names from the report data inside the conditional formatting drop down of values without changing the table in viewer

Answered
sai asked on April 2, 2024

I want the value dropdown in the conditional formatting to show all the column names from the report configured but this should not add extra columns in the table in viewer. How can I do this ?
 
i.e, what I understood is ∑values is used in two places 1.to configure the table columns in the viewer and 2. The values dropdown in the conditional formatting. But I want these both to be different. I want to add all the column names from the report data into the dropdown in the 2nd case, so I can apply conditional formatting to the table using the columns which are not configured in the table but present in the report data.

3 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster April 2, 2024

Hello, Sai!
 
Thank you for contacting us.
 
Kindly note that from the UI, it is only possible to apply conditional formatting to the values present in the current slice. However, it is possible to create more complicated conditions from the code using our addCondition() API call: https://www.flexmonster.com/api/addcondition/.
 
For the described case, our team recommends creating your own UI controls and using our API calls to create formulas with values not present in the current slice.
We have prepared a JSFiddle sample to illustrate the idea: https://jsfiddle.net/flexmonster/sp2nw6m4/.
Please note that you can apply only count and distinct count aggregations to string fields.
 
You can find more details about conditions in our docs: https://www.flexmonster.com/api/conditional-format-object/.
 
Hope you will find our answer helpful.
Please let us know if the suggested approach works for your case.
 
Kind regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster April 9, 2024

Hello, Sai!

Hope you are doing well.

Our team is wondering if the suggested approach of using addCondition() API call along with custom UI controls works for your case.

Looking forward to hearing from you.

Kind regards,
Solomiia

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 4 days ago

Hello, Sai!

Hope you are having a great week.

Just checking in to ask if the suggested approach of using addCondition() API call along with custom UI controls works well for you.

Looking forward to hearing from you.

Kind regards,
Solimiia

Please login or Register to Submit Answer