Discussions

Expand all | Collapse all

Limit to Number of Selections in Multi-Select Text Field

  • 1.  Limit to Number of Selections in Multi-Select Text Field

    Posted 15 days ago
    Hello!

    I have a Multi-select Text field where a user can select multiple options. I'd like to only have the user select up to three options. Is this possible to do through a rule form or something similar? 

    Alternatively, I'd like to put some kind of rule in place where if they select a particular option in the list, it doesn't allow them to select anything else. 

    thanks in advance for any help! 

    Kimberly 


    ------------------------------
    Kimberly Valois
    ------------------------------


  • 2.  RE: Limit to Number of Selections in Multi-Select Text Field

    Posted 15 days ago
    You could make a formula field to count the number of selections and abort the Sav e in a form rule if more that 3. 

    var text value = ToText([Combined Text Floor ID]);

    Count(
    Trim(Part($value,1,";"))<>"",
    Trim(Part($value,2,";"))<>"",
    Trim(Part($value,3,";"))<>"",
    Trim(Part($value,4,";"))<>"",
    Trim(Part($value,5,";"))<>"",
    Trim(Part($value,6,";"))<>"",
    Trim(Part($value,7,";"))<>"",
    Trim(Part($value,8,";"))<>"",
    Trim(Part($value,9,";"))<>"",
    Trim(Part($value,10,";"))<>"",
    Trim(Part($value,11,";"))<>"",
    Trim(Part($value,12,";"))<>"",
    Trim(Part($value,13,";"))<>"",
    Trim(Part($value,14,";"))<>"",
    Trim(Part($value,15,";"))<>"",
    Trim(Part($value,16,";"))<>"",
    Trim(Part($value,17,";"))<>"",
    Trim(Part($value,18,";"))<>"",
    Trim(Part($value,19,";"))<>"",
    Trim(Part($value,20,";"))<>"",
    Trim(Part($value,21,";"))<>"",
    Trim(Part($value,22,";"))<>"",
    Trim(Part($value,23,";"))<>"",
    Trim(Part($value,24,";"))<>"",
    Trim(Part($value,25,";"))<>"")


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------