I have created an SQL custom field for my joomla contacts called
location, this allows me to assign a location to my contacts.
The SQL simply selects
location_name from a custom db table called
locations. The custom field works as expected, and I am presented with a pre-populated list of locations when adding or editing a contact.
The trouble is, some of my contacts have two locations. Using this default custom field only allows me to assign one location.
I'm thinking I probably need a tag style custom field so that when I click the input, I am presented with a list of locations and I can select one or more.
Something like the
User Groups field in this image. However instead of being able to select user groups, I need to be able to select locations from my db table.
It's not necessary to be able to add to this list of tags from the input, just select them.
Is this possible, if so, how?
Any other suggestions are also welcome.