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

8 Replies

Related Content

Create Linked Assignments from Multi-Select Field

Multi select field from another table

Report formula - multi-select text field

Multi-Select Field in Reports

Multi Select Date & Text

Recent Discussions

Bug with Advanced Query in Pipelines Designer?

Date value changes when copied to new table with pipeline.

Share your feedback on the new Qrew Discussions

'Is Set' in Pipelines

Time of Day field values are not in 24-hour format in Pipelines