Database Column creation problem

I created a form and followed the tutorial like I did last time to connect it to a database. However, the interface has changed with the new version and their is no longer the Create Column checkboxes referred to on page 2 of the tutorial. Thus
I am only getting the internal tracking information such as the id, recordtime, etc. How do I resolve this? I can't see a way to create the columns.

Ok, I figured it out. I unhooked the form from the database and deleted the database. For good measure I renamed my form and then created the table again. Apparently you have to select the green checkmark to say that you want that column created and then it turns to a red x...then save it to generate the columns. Not very intuitive...I would have thought the green checkmark said it was ok. Anyway, all is well.

Can someone tell me why select list columns are automatically moved to the last column in the database? This is rather annoying because the data is out of sequence. It makes no difference for storage of course, but it does for viewing online or exporting the data.

Hi johkar1,

I agree that the new interface (here and for Plugins) is counter-intuitive. Hopefully Max will change it in a future release.

The selects are at the end because ChronoForms looks for inputs first, then selects, nothing more complicated than that.

But if you don't like the order you can drag and drop the bars in the Create Table interface (use the first rotating arrows icon if you can't drag the whole bar in your browser).

Bob

I guess I am good at answering my own questions. You can reorder the columns, but you HAVE to do it before you save all the columns during the table creation process. There is an icon that lets you drag the columns to any order.

Hi johkar1,

That's it, after the table is created you can change the order of columns by using PHPMyAdmin - it's a bit fiddly but possible. The code was posted here a week or two ago.

Bob