Multi-select text field
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 selecte...
Forum Discussion
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",""),
""
))
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
Alex - that is an interesting solution that I will surely look at maybe implementing in another app - thank you!
------------------------------
LB
------------------------------
