Is there a way around the 20 choice limit for the Multi Select drop down (tip or trick) ? In short, I have a contractor database with approx. 150 Contractors, I then have a drop down multi-select ...
> don�t have a hack to allow more than 20 choices,
I have a hack to allow you to put any data you want into your fields and to implement an appropriate graphical interface for manipulating that data. Consider this demo where I create a Chessboard field using a text multi-line field:
The same technique can be used to create any field type you want:
Chromosome Fields
Molecule Fields
Building Drawing Fields
Family Tree Fields
Satellite Orbit Fields
Wedding Planning Fields
You just store some type of JSON representation of you custom Field type in a multi-line text field and through script slap in an appropriate graphical display and editor widget to visually view and manipulate your custom field. Here is a screenshot of my Molecule Field Editor
Similar to the Chessboard Field demo, the [Molecule] field is not directly edited by the user and is just used to store the state of the Molecule being viewed or edited. It turns out that there is a simple format for representing molecules using SMILES (Simplified Molecular-Input Line-Entry System),.
So to get around the 20 choices limitation of the Multi-select options you just store your selected choices in a field in some type of format (CSV would suffice) and use an appropriate graphical editor to display and select the "Pills" (the selected choices are often called pills).
