null

  • 1
  • 1
  • Question
  • Updated 2 weeks ago
  • Answered
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
Photo of yaniv yaniv

yaniv yaniv

  • 72 Points

Posted 2 years ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
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)
Photo of Lee Gilmore

Lee Gilmore

  • 774 Points 500 badge 2x thumb
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!