Skip to main content
Question

Multi-select text field

  • January 31, 2024
  • 0 replies
  • 201 views
Forum|alt.badge.img+8

I have a multiselect text field that has 20 options in the field currently - If the user selects one of the options marked no, is it possible to make it to where the other 19 options can't be selected?



------------------------------
LB
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Registered
    • January 31, 2024

    Kind of - but not the way you're thinking with hiding or disabling the options. You'd need form rules to control or limit the entry. You could use form rules to: 

    1. If they select No make the field read only so they can't pick anymore. Then have a checkbox or something next to it for 'Clear' that will remove No and unlock the entry with another field
    2. Make a form rule that when the Multi Select includes No that it always resets the Value to just no. So if they try and select another option they can, but the form rule just clears it back out and you could display a message. 


    ------------------------------
    Chayce Duncan
    ------------------------------
    FWIW, for situations like this, I've gradually come to the conclusion that (a) multi-select text fields are great for viewing a record and for reports, but (b) an array of checkboxes is a lot easier for data-input for most users, so (c) I create check-boxes plus a formula-multiselect field like this example:

    Split(List(";",
    If([Box1],"Box1",""),
    If([Box2],"Box2",""),
    If([Box3],"Box3",""),,
    If([Other],"Other",""),
    ""
    ))

    Then you would not need a checkbox for "No" or a form-rule. You just modify the formula-field by making the List() portion above (without the Split) into a var ... like this

    var text mylist=List( ...)

    Split(
        If($mylist="","No",$mylist)
    )

    Alex Wilkinson


    Terms & ConditionsAccessibility statement