topic Re: Color cue when value is greater in text field in App Development

Color cue when value is greater in text field

New_Bee77 — Fri, 01 Apr 2022 14:42:03 GMT

Below is the sample field value. I wanted to show text in Red when I find numeric value in the filed greater or equal to 50%. I have two filesystem in one field.

"/var 18%, /var/hsc/log 50%" (Red)

"/var 35%, /var/hsc/log 24%"

"/var 77%, /var/hsc/log 65%" (Red)

Re: Color cue when value is greater in text field

brunobertels — Fri, 01 Apr 2022 16:06:05 GMT

hi may be this

if(right('"/var 18%, /var/hsc/log 50%"',3)<=0.5,lightred())

Re: Color cue when value is greater in text field

New_Bee77 — Mon, 04 Apr 2022 05:42:42 GMT

I should be able to use field name instead of data

Var (Field name)

"/var 18%, /var/hsc/log 50%"

"/var 35%, /var/hsc/log 24%"

"/var 77%, /var/hsc/log 65%"

Re: Color cue when value is greater in text field

brunobertels — Mon, 04 Apr 2022 10:03:16 GMT

Yes

if(right([YourFieldName],3)<=0.5,lightred())