Conditional formatting on dynamic column table

App Building
1

Hello everyone !

  • Goal: I'm trying to set up conditional formatting on a table which has "dynamic columns" enable

  • Steps: In the advanced section of the dynamic column, I have put some format snippet to define the type of the column. Now I would like to know where I could add something about background color

  • Details: I have built kind of a pivot table and would like to underline every cell where the number before and after the "/" are not matching. (it's a planning where you want the assignation to match the workload).
    -- Where can I add something about background color since I can't select one column in particular (since this is a dynamic table) ?

  • Screenshots:

    image
    image1103×521 68.7 KB

1 Like
2

Hi @Labuche! Welcome to the community. :slightly_smiling_face:

I've done a fair bit of experimentation and come to the unfortunate conclusion that it isn't currently possible to define styles for a single dynamic column. If it makes sense for your particular use case, you can switch to using defined columns, instead.

I do think it may be feasible to add styling options for a particular type of column in this menu:

image
image1276×1054 107 KB

I'll pass this feedback on to the team and let you know what they think!

3

I thanks for your reply !
I've tried also on my side by using pre-looaded JS and CSS in the app settings, or running a script after the dataquery has run, something like if cell contains XX then background = red, but no success.

I can't really switch back to fixed column has each column is a date that changes with a date selector in the filters.

Workaround : I added emojis in the cell which kind of help but make it heavier to read.

1 Like