Skip to main content
Question

If/then with blank field and checkbox

  • November 20, 2023
  • 0 replies
  • 522 views

Hello friends, question about a field that used to work for me but no longer does. 

In one form, one field will either be blank or have a number in it, we'll call it "tag number". If "tag number" is blank, I set up a checkbox to check. If "tag number" is filled out, then the checkbox will not check. 

the formula I used that used to work was

Checkbox-formula

if([tag number]=null, true, false

Am I doing something wrong? The box is not showing checked when I leave the Name field blank. 

When I use 

If(IsNull([tag number]), false, true)

It checks whether it is blank or not

Help



------------------------------
Nicole Cordeiro
------------------------------

    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    The correct formula is this. 

    if(Trim([tag number])="", true, false)

    in order to test a text field for blank you check if it's equal to empty quotes.  


    I'd like to wrap it in the trim function just in case someone enters some invisible spaces into the text field. 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
      Terms & ConditionsAccessibility statement