How to save ALL form data in DB table

Hi,

I'm having a form where people can subscribe to an event. The first field is a drop-down box, where all future events are shown. These data is fetched from a DB table in Joomla (jos_jevent_vevdetail).
Then comes the next fields such as name, address etc.

I am saving all the data in a new DB table, this table was created from chronoforms 5 "Create table".

Here is what is giving me a headache: All my forms fields are saved correctly, EXCEPT the data selected from the drop-down list.

The name of the field is "dropdown1". When I try to debug the form, I can see that the data is there, but it is NOT saved in the DB table. I have tried to copy the value to a hidden field, without any success.

How can I do this ?

Hello Nielsterp,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How do I save form data to a database table?
How to load record data from a database table into your form
How to load one row from a DB table into your form
P.S: I'm just an automated service😉

Hi Nielsterp,

Please try clicking the Delete Cache icon in the Forms Manager toolbar - that may solve the problem.

If not, please drag a Debugger action into the On Submit event, then submit the form and copy and paste the debug results here.

Bob

Hi GreyHead,

I tried to flush the cache - that didn't help. I then added the debugger to the On Submit. Here is a dump of my results.
The field I'm trying to save is [dropdown1] => Foredrag af Magnus Larusson.

The problem is (I think), that when I create the table for the form, [dropdown1] is not even in the table.

Data Array
Array
(
[option] => com_chronoforms5
[chronoform] => Tilmelding
[event] => submit
[dropdown1] => Foredrag af Magnus Larusson
[navn] => Niels Terp
[addresse] => Tranegatan 3 Lgh 1101
[postnummer] => 26135
[by] => Landskrona
[land] => Sverige
[hjemmetelefon] => 418333073
[mobiltelefon] => +46418333073
[email] => nielsterp@comhem.se
[antal_gaester] => 0
[bemaerkninger] =>
[button] => Send
)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
)
Tak fordi du har tilmeldt dig til arrangementet "Foredrag af Magnus Larusson" !

Du modtager også en mail med bekræftelse på din tilmelding.

Powered by ChronoForms - ChronoEngine.com

And here is a dump of the table created:

# Name Type Collation Attributes Null Default Extra Action
1 id int(11) No None AUTO_INCREMENT Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
2 uniq_id varchar(50) utf8_general_ci No None Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
3 user_id int(11) No None Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
4 created datetime No 0000-00-00 00:00:00 Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
5 modified datetime Yes NULL Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
6 navn varchar(255) utf8_general_ci No None Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
7 addresse varchar(255) utf8_general_ci No None Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
8 postnummer varchar(255) utf8_general_ci No None Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
9 by varchar(255) utf8_general_ci No None Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
10 land varchar(255) utf8_general_ci No None Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
11 hjemmetelefon varchar(255) utf8_general_ci No None Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
12 mobiltelefon varchar(255) utf8_general_ci No None Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
13 email varchar(255) utf8_general_ci No None Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
14 antal_gaester varchar(255) utf8_general_ci No None Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext
15 bemaerkninger varchar(255) utf8_general_ci No None Change Change Drop Drop Browse distinct values Browse distinct values Primary Primary Unique Unique Index Index Spatial Spatial Fulltext Fulltext With selected: Check All / Uncheck All With selected: Browse Browse Change Change Drop Drop Primary Primary Unique Unique Index Index