Save a check list box separately in the database

[wviel]

Hello,

I want to save them separately checked boxes in the database, do you have idea?

Example : if I have 3 checkboxes, I want 3 diferent records in the database.

Thx

 

[cheesegrits]

If you use a join element in checkbox mode, we automatically create a many-to-many mapping table, which creates a separate row for each checked option.

But no, if you want to add a separate row in the main table, there's nothing baked in, you'd have to write your own code in a PHP form submission plugin.

-- hugh

 

[wviel]

Thank you, for your response !

 

[wviel]

Sorry but I can not see where to start.

My checkboxes are generated via my database,

This is a list of names with a job list to choose

I want, when I check two names(checkboxes) I have 2 records in my database.

Please help

 

[cheesegrits]

As I said, you'd have to write your own plugin code to do that, and it wouldn't be simple.

As I said, if you use a join element, to a table which contains your "personells", this will create a many-to-many database relationship between your form's main row, and the personel. Which can optionally be represented as two rows in the list view.

-- hugh

 

[wviel]

ok, this is high above my skills,

Thank you for your help

 

[cheesegrits]

Create a new list, "personels", and give it a new table name "personels". Add a new element to that list, "name".

View the list on the back end, and add new rows to it for your names.

On your form, change the checkbox element to a 'database join' element. Select 'id' as the value, 'name' as the label, and set it to be a 'checkbox' instead of 'dropdown' type.

-- hugh