Multi-select text field and form rules

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I have a multi-select text field and would like to have more fields display on a form only when a condition is met in the multi-select field. This may be one or multiple fields. Currently, as long as one field is checked, my field will display. If I check an additional field, not only does my initial filed "hide" but the next field does not display. 
Photo of Anne

Anne

  • 100 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
I willing to guess that your form rule is using the expression "equal to",  change those rules to use the expression "includes".  

Then it should work with multiple items checked.

Let me know if you get stuck.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
Form rules do not allow "includes". There would need to be a calculated field using the includes formula, and the have the firm rule key off that calculated field. Be sure to have he calculated field on the form, even if in a hidden section
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
Dynamic form rules do allow "includes" for multi-select fields, and has for the last 6 months. It was updated back in October (or before)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
OK, thx for that info.