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.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 07-19-2021 13:21
From: Karen Henke
Subject: 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!
------------------------------
Karen Henke
------------------------------