I need a checkbox formula that will check box if a drop down field is empty OR NOT one of the options from the drop down field.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Marina

Marina

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Eric

Eric

  • 40 Points
The purpose of a dropdown field, meaning a multiple choice field, is that you're limited to select something from just that list of options. How would you get a value in there other than the choices listed?

As far as the checkbox formula goes, the "is empty" part looks like this: [TextFieldName]="". If you've changed your multiple choice selection options and want to see which are no longer valid, place your field into a report. QuickBase is designed to display invalid selections with a red text.
Photo of Matthew Neil

Matthew Neil

  • 31,758 Points 20k badge 2x thumb
The comment was missing the equation, but here is the full formula to evaluate a "blank" answer.

If([Text Multiple-Choice Field]="", true, false)

If you wanted to Have multiple evaluations (or "If" statements) you can use a Case formula;

Case([Text Multiple-Choice Field],

"", true,

"Happy", true,

"Crazy", true,

false)

This basically says, if the answer is "blank", "Happy" or "Crazy", check the box (true), all other responses will leave it un-checked (false).