conditional format

posted on July 23rd, 2024

Closed

Ingenieria Especializada asked on July 23, 2024

Hello, I hope you are well. I have a question about conditional formatting.

Is it possible to do conditionals with text formatting?

5 answers

Public

Maksym Diachenko ⋅ Flexmonster ⋅ July 24, 2024

Hello,

Thank you for writing to us.
Could you please elaborate on what you mean by conditionals with text formatting? Knowing more details would help us to provide a more accurate response. Any additional textual or visual input is highly appreciated.
Looking forward to your response.

Best Regards,
Maksym

Public

Ingenieria Especializada ⋅ July 24, 2024

Hello!

I have this report where ‘SEVERIDAD’ is an input text, and I want that when ‘ID_TIPO_ESTRATEGIA’ is for example 2 and SEVERIDAD is ALTO, that row is painted in a colour.

I see that in conditionals this is not possible, but I don't know if it is possible from the json?

Attachments:
Captura de pantalla 2024-07-24 074448.png

Public

Maksym Diachenko ⋅ Flexmonster ⋅ July 25, 2024

Hello,

Thank you for sharing more details with us.

As you have mentioned, conditional formatting only allows for the highlighting of numeric values. However, you can format string member cells or entire rows by combining conditional formatting with the customizeCell API call. This method allows setting a custom JavaScript function to customize each cell based on cell data. Each cell object contains the conditions array with identifiers of conditions applied to the cell. Using these, it is possible to add a CSS style to the whole row based on the presence of a certain condition in a cell. You are welcome to check the code example: https://jsfiddle.net/flexmonster/nonte3qv/

Please let us know if this solution works for you.

Best Regards,
Maksym

Public

Maksym Diachenko ⋅ Flexmonster ⋅ August 13, 2024

Hello,

Hope you are doing well.
Our team would like to know if you tried using the suggested workaround with customizeCell to implement text-based conditional formatting.
Please let us know if this works for you.

Best Regards,
Maksym

Public

Ingenieria Especializada ⋅ August 13, 2024

Hello,

Thank you very much for your attention and for asking if the solution was helpful to us.

Our team has several alternatives for the solution we need to implement, and one of them is the one provided by the Flexmonster team. Our end client will decide which path to take.

Again, thank you very much for your help.

This question is now closed