Column coloring with SQL conditions in Item List

0

Hi,
in the last "else" you use a condition, try it like this

if
'1' = '0'
select '#90EE90'
else if
'1' > '0' or '1' <= '30'
select '#FFFACD'
else if '1' > ='31'
select '#FF6347'

Hi Andreia,

Did you try with SELECT CASE WHEN ... THEN ... ?

Hi,

Using the else if, it gives an exemption error in the system.
I've switched for case when

(select
case when '{SFD:640}' =0 then '#90EE90'
when '{SFD:640}' <= 30 or '{SFD:640}' > 0 then '#FFFACD'
else '#FF6347'
end)

But it's giving an error of no column specified for nn. I've switched to objects tab and added the From but it's not working as well.

Do you have any thoughts?
THank you for the help!

Can you try adding “as A” at the end of the select?

Hi Martin,

I've tried to use the AS but still not working.

I've switched for a form rule, working as call back because the field is calculated through a change field action.
But it's not working as well.

Did you tried with form rule?
Thank you!

Hi Andreia,

Please see attached picture. Hope that helps.

Cheers,
Martin

Hi Martin,

Thank you, I've added the config you send but also created a SQL query under the layout for the item list.
It worked somehow!
Thanks