Skip to main content
Question

Set max number of responses to a multiselect text field

  • July 19, 2021
  • 0 replies
  • 26 views

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!



------------------------------
Karen Henke
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------