Change background colour of a cell based on a control field in the same row

App Building
, ,
1

I was wondering who could help me with this. I have a column called project_amount in a table called projects and another column in the same table called project_amount_control. The second one is a control checkbox only used for the purpose of specifying the background colour of project_amount and it will not be visible.

I need that for any given row in the table:

  • if project_amount_control = 0 then the background colour of project_amount for that specific row is left unchanged
  • if project_amount_control = 1 then the background colour of project_amount for that row is #F6E5C4

Screen Shot 2022-08-06 at 6.38.33 am
Screen Shot 2022-08-06 at 6.38.33 am1376×996 133 KB

My guess is that I need to enter some if statement in JS in between {{ }} in Background but I have no idea what to enter, so I was wondering who could help me with this.

Thank you so much. :slightly_smiling_face:

2

Use a ternary operator
{{currentRow.project_amount_control == 1?'#F6E5C4':''}}
https://docs.retool.com/docs/javascript-in-retool#ternaries

1 Like
3

Thanks @ScottR for teaching me about ternary operators.

4