And empty "yes/no" isnt being recognized as no

ksplinter007 · 2024-08-01T19:42:20.744Z

is anyone else running into an issure where an empty yes/no isnt being read as “no”

i have something that is supposed to show up with the field is “no”, but because the field is empty, its not operating properly. i dont remember this being an issue.

and im not able to go “if yes no is empty” or “if yes/no is not yes”

any suggestions besides never allowing the field to be empty?

emir.ozgun · 2024-08-01T19:59:40.450Z

2 weeks ago I have found about it , same here

ksplinter007 · 2024-08-01T20:01:36.318Z

i tried creating a work around where “arbitrary text (yes/no field) is empty” which returns a yes, but the condition doesn’t care either

hi.luisacosta · 2024-08-01T20:20:29.241Z

I always use Boolean <> Yes when I am looking for “No” because I have seen that in the past.

Just set the default to No perhaps? and then run a backend workflow to update the DB?

ksplinter007 · 2024-08-01T20:29:29.478Z

i did correct the worklow to default to no.

in the conditions for an element i do not see <> for yes/no fields in the blue expression builder. there is only yes, no, and “is not”. and the “is not” wants to reference another item, not “is not yes” or “is not no”

hi.luisacosta · 2024-08-01T20:48:26.057Z

You can do it like this example:
Product’s Discontinued? yes/no :FormattedAsText is not yes

You will need to type the word yes in lowercase

If you can safely assume the field will not be empty anymore, then you don’t need that

ksplinter007 · 2024-08-01T21:02:23.484Z

ok ill try formatted as text next time