Multi-select text field

Question

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

chayceduncan · Answer

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:&nbsp;

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
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&nbsp;they can, but the form rule just clears it back out and you could display a message.&nbsp;
------------------------------Chayce Duncan------------------------------

lb · Answer

Ok, I think I also should have pointed out that the form I'm working in is the old version not the current form build version------------------------------LB------------------------------

chayceduncan · Answer

It should work on both versions of the form with minimal issues------------------------------Chayce Duncan------------------------------

lb · Answer

Ok, I tried your option 2 and then tested the field to select the No option in addition to the other options and added an action to also display a message, but it didn't work. I've noticed the box is checked for "Fire "change" actions only when a condition&nbsp;changes&nbsp;from false to true" not sure if that makes a difference or if that could create issues unchecking that box?------------------------------LB------------------------------

alexwilkinson · Answer

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

Forum Discussion

Multi-select text field