Forum Discussion

KarenHenke's avatar
KarenHenke
Qrew Cadet
3 years ago

Set max number of responses to a multiselect text field

Hello!  I have a field called Marketing Products which is a multiselect text field. I need to limit the number of responses the user can choose to 5. Is this possible? Thank you! ------------...
Formulas and functions
Tables and fields
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
Try this as a new Formula Numeric field.  I would put it beside the multi-select field on the form.  If you wanted to limit to 5, 


var text Multi = ToText([My Multi Select Field]);

Count(
Part($Multi,1,";"),
Part($Multi,2,";"),
Part($Multi,3,";"),
Part($Multi,4,";"),
Part($Multi,5,";"))

Then make a form rule to abort the save when the record is saved and there are More than 5 selected.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
KarenHenke's avatar
KarenHenke
Qrew Cadet
3 years ago

Thank you Mark!

I had to extent the count field to past 5 so it could count to greater than 5. Then I set up the rule as you suggested and it works great.



------------------------------
Karen Henke
------------------------------