topic Re: Background Color Expression in TABLE in App Development

Background Color Expression in TABLE

datapitipa — Fri, 16 Dec 2022 11:29:31 GMT

Hi all,

I have a column in TABLE with this formula ==> =Interval(Now()-Last_Update_Date,'h')

and I would like show the column green (#93c47d) when this value is >= 48. I tried this, but the background is always white

=if(Interval(Now()- Last_Update_Date,'h') >= 48, '#93c47d', white())

Thanks in advance

Peca — Fri, 16 Dec 2022 12:29:46 GMT

Hi,

You can try this:

=if(Interval(Now()- Last_Update_Date,'h') >= 48, RGB(147,196,125), white())

tresB — Fri, 16 Dec 2022 12:36:21 GMT

Interval is a formatting function, i.e. - it doesn't change the underlaying number. Try like:

if(Floor((Now()- Last_Update_Date)*24) >= 48, '#93c47d', white())

Note: you might not need floor() based on your requirement.