Conditional formatting - Check box

Hi, 
May I ask what view this is in and what tab you are applying this conditional formatting in? 
I may be able to help if I’m able to do some tests in our environment. :)

Hi ELJO

It's within the Shop Floor Workbench and utilized in a tab that we have created as a modification (QMS Control Results). However, I believe the issue is linked to the fact that the field is a modification. I've tested the same logic on a different checkbox column, and it works perfectly fine.

 Dear @David1992 ,

I tried to apply a conditional format to an check-box but I failed too before.

If you guys cant find a way to do it you can try to add a new custom field  like below:

SELECT

(CASE

WHEN QMS_RESULT_COMPLETED = ‘TRUE’ THEN ‘TRUE’

WHEN QMS_RESULT_COMPLETED = ‘FALSE’ THEN ‘FALSE’

END) YOUR_NEW_CUSTOM_FIELD

FROM YOUR_TABLE

Then you can apply your conditional format to YOUR_NEW_CUSTOM_FIELD.

Hope it helps

Özgün Bal

Hi,

Have you tried to set the value to True, Yes or Y without quotes? This might be down to the checkbox using alternative values for the condition. One way to check this is to RMB on the column header and select “Conditional Fields...”, then locate the field in the list, select it and press the plus button next to the “Add Value Set Action” label.

This should then show the valid values in the “Selected Values” section. Then use the delete button at the top right of this dialog to remove the new value action. 

Regards

Telha