Forums

Hi again,

I made a form created with the content of an existing MySql table (DB Read) with products. Now I wish to create the mysql table which contains the orders made by the form users. Unfortunately the CF routine "Create Table" lists only those fields which are not made by dynamic data. I don't know whether this is a bug or normal behaviour. Anyway, I can complete/edit the mysql table with phpmyadmin. I just wanted to let you know this.

Kind regards, Herbert

Hi Herkle,

I'm not sure that I understand this :-( What do you mean by "made by dynamic data"??

Bob

When creating radio/dropdown/checkbox groups, there is the lovely choice of using "dynamic data" in the element's setting. Those I am talking about.

Hi Herbert,

True, but that doesn't affect the name of the CheckBox group so I'm still not clear what the problem is :-(

Bob

Hi Bob,
I wasn't talking about names?! I tried creating a mysql table using my form (which contains both fields with static resp. options based on dynamic data) with "Create table"-button on CF start page - in the mysql table proposal which pops up those checkbox/radio button/dropdown fields (depending on dynamic data input) were not listed. I added them via phpmyadmin manually. Sorry, I can't explain otherwise.

But btw: My tabbed form submit button problem I posted earlier is far more urgent. There I would really appreciate any help. :-(

Kind regards,
Herbert

Hi Herbert,

I was referring to names because the way the Create Table works is to check the Form HTML to extract a list of names and use those to populate the proposed table.

I tried with the demo-dynamic-dropdown form but the Create Table includes the 'dynamic' drop-down correctly.

Bob

Hi Bob,

now I start understanding what you miss. Your example is "pseudo-dynamic" since its options basically are described statically:
[attachment=0]element-static.png[/attachment]

In my example the options aren't in that statical option box:
[attachment=1]element-dynamic1.png[/attachment]

They are described in the "dynamic data" tab by using an array of data, whose source – a 2nd connected table – is read out with "DB Read":
[attachment=2]element-dynamic2.png[/attachment]

And when trying to create the mysql table, the radio button name "DoMe" didn't show up as mysql row. Hope this helps.

Regards,
Herbert