Discussions

 View Only
  • 1.  Set max number of responses to a multiselect text field

    Posted 07-19-2021 13:21

    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
    ------------------------------


  • 2.  RE: Set max number of responses to a multiselect text field

    Posted 07-19-2021 17:22
    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
    ------------------------------



  • 3.  RE: Set max number of responses to a multiselect text field

    Posted 07-19-2021 20:16

    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
    ------------------------------