SQL queries / Multiselect / Textselect

I've got a item type called "Event" that has several fields associated.

One of the fields is "Speakers".

I'd like to be able to select more than one speaker to each event, and if the name doesn't exist than create it on the fly. If it was only this it was easy, a simple textselect field was enough.

The issue is that this field repeats several times in the form and besides that I'd like to be able to manage this speakers so that I could create a biography for each one of them.

Is there any way to achieve this? Some kind of workaround?!

Thanks

I even remembered of creating an item type of name "speakers" to which I would associate several fields and where would manage these speakers.

Then, in the item type "events" I would populate the multiselect lists needed with the names I would fetch using a SQL query. But what should be that SQL query?

And this way it's not possible to add in the events form a new name that doesn't exist, is it?

Hello


why don't you use the relation (related items) field ?

Because I don't know exactly how does it work!

Hello

it is the most appropriate / natural way to achieve what you need
- you can create relate items of type "Speaker" to the items of type "Event"

Just look at the available configuration options in the Editting TAB of the field


1. Create the new field and "assign" it only to type "Events"
(so that it appear only to item form of "Events")

2. Select it to shown only items of type "Speakers"

3. Optionally enable options like drag and drop sorting of its values (aka of speakers) in item form

4. In viewing TAB (when field appears in frontend inside an event) you can select not only to display the name of the speakers
-- but anything about, them, e.g. their image, or anything

5. In category view it can display differently than in item view, e.g. in category view you can configure it to show only a total number of speakers or only their names etc

test it, its usage is documented inside the popup descrtiptions of every parameter

Thanks.
Sorry for my late reply. I've been out.
I'll try your suggestion.

Yes, it's almost that.

It was perfect if it was possible to add a button to add a new article if it wasn't listed.

For example, I want to use it in the speakers. So if a certain speaker wasn't already inserted I could add him clicking in "Add item". When clicking "Add item" it could open a window with the form to add that item.

Thanks

Hello

it is possible to implement

add a button to open new article form in a modal ,
and auto-close modal when doing save+close or cancel and auto-add the new item (or easier auto-update the 'selectable' items list)

but this would be rarely used,

Could you please be more detailed?
How can I add a button/modal window with that config?
Thanks

Hello

i said it is possible to implement into the field
meaning it does not exist

and then also commented it would be rarely useful (to rather small number of web-sites)