Jean-Christophe GALLAND
asked on
FileMaker - Dropdown menu with checkboxes and multiple choices
Hello
I have a FM database and for one field, I use a value list with data from another table, but only one single choice is possible.
I would like to offer the user the possibility to do multiple choices, ideally through a drop down menu that has checkboxes. The checkbox option exists, but will display all the checkboxes on the layout, not within a dropdown menu. Is there any solution?
Thanks
I have a FM database and for one field, I use a value list with data from another table, but only one single choice is possible.
I would like to offer the user the possibility to do multiple choices, ideally through a drop down menu that has checkboxes. The checkbox option exists, but will display all the checkboxes on the layout, not within a dropdown menu. Is there any solution?
Thanks
ASKER
Thanks
Would you be ok to attach a small example so that I can see how it looks like and how it works?
Would you be ok to attach a small example so that I can see how it looks like and how it works?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great solution! Thanks!
However, a good option in this circumstance is to use a "Popover" window that contains the values in Checkbox form. This allows the user to make multiple selections without taking up the as much room on the main layout. If you wish you can display the selections on the main screen as a text string using a calculation field and then putting it on the layout as a Merge field <<SelectedOptionsString>>
Note that when a user selects multiple options from a checkbox value list, the options appear in the list in alphabetical order, but the selections are entered into the field a carriage-return separated values in the order that they were selected. (Which has many interesting uses). For example, if the checkbox value list contains:
Apple
Banana
Blueberry
Orange
Pear
Peach
and the user selects Pear, Apple and Peach in that order, if you look at the contents of the field without the checkbox value list formatting you will see a list in the order it was selected:
Pear
Apple
Peach
There are ways to sort the values after selection if that is important. I normally use a Custom Function to accomplish this.