Forum Discussion

yanivyaniv's avatar
yanivyaniv
Qrew Member
8 years ago

null

hello

my question is if i have numeric field named "num"
and checkbox (formula)
in need formula thet if field "num" empty checkbox uncheck, and if it have value checkbox need to be check

2 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    No problem.  First set the field properties for the numeric field [num] to uncheck "treat blank as zero".

    then use the formula

    IF(IsNull([num]), false,true)
  • Lee_SGilmore's avatar
    Lee_SGilmore
    Qrew Cadet
    6 years ago
    This always bites me! I asked this question months ago and still haven't learned my lesson. I appreciate finding this post to lead me back to that lousy check box!