Conditional Formatting

App Building
, , ,
1

I'm trying to create a conditional formatting color for a column. Imposible to do it

I'm doing this but retool isn't recognizing the "Active" or "Inactive" words.

{{ self === 'Active' ? '#08a977' : self === 'Inactive' ? '#fea424' : 'defaultColor' }}

Help please!

image
image1102×1108 98.9 KB

2

Hi Paula,

You might be looking to use the item keyword instead of self. item refers to the value of each cell in the table, while self refers to the entire table component. Hope this helps!

eg:
{{ item === 'Active' ? '#08a977' : item === 'Inactive' ? '#fea424' : 'defaultColor' }}

1 Like
4

Is not the Text color field for that?

5

Another gothca - I'd also double check that the value of those items are capitalised. I know that the table does some nice automatic formatting to uppercase the first letter on some column types - so if your data is actually active it may display as Active on screen but your === operator won't match it.

6

Thank you, Anna! I'm encountering an issue as the text color appears in the preview, but it doesn't show up when using the app.

image
image328×968 21.4 KB

image
image488×1108 30.2 KB

7

Hi @PaulaG Thanks for flagging this bug! Any chance you're using releases on the app? I'm wondering if this change needs to be published as a new release in order to see it in Preview

1 Like
8

Hi, there is a related post with issues with Text color field in Table columns

9

Hi @Tess, thanks for following up! I am currently working with only one environment, so all changes are released immediately. However, this does not seem to apply to the text color change.
image

1 Like
10

Same issue

11

Okay the behavior has been pretty inconsistent for me :thinking: But I think I have enough to report this as a bug to our team. I'll post here with any follow up questions or updates!

2 Likes
12

This should be fixed now :crossed_fingers: Please let us know if you're still seeing issues here