Hi guys

I'd like to set up my form to save the results to a database. I've entered the correct credentials within Web Form Builder. I've made a new database with 9 fields, my form has 9 fields.

Do I need to match the field names in my database, so they are the same as what they are on Web Form Builder? Currently, when you complete the form you receive the error message:

Your form could not be submitted for the following reason(s):
Failed to store the data.

Thanks for your help in advance.

Kind regards
Adam

Take a deap breath, this is an easy one

Delete anything you entered into your database on the server. Don't put in any fields or data. Start with a blank database. When you create your form, and you put in the fields on your form, then enter the database credentials the web form builder will create the needed fields in your database for you! How's that for cool?

Create the database but don't make any tables.

Awesome! Cheers guys - will give it a go now! :-)

Guys I really need to not have it create new fields. I want to connect it to my exisiting database. I made careful sure that the field names were exactly the same on mysql database as they were in the "Name" section of WFB. I know it captures the ip and all that and I was able to put that in just as it shows in the build file of wfb. getting that same error message. I checked the sql log in details are correct. I have existing data in the table so I don't want to delete it and rebuild if I can avoid that. But I may have to back up and then let it build them and just reload the data.. not sure. Any ideas here how to connect the data to drop into an existing database? This is critical as I have many forms to do like this. Thanks, Tina O'Connell - so far very happy customer!

Form Builder is not designed to work that way Tina, but if that is something you need, you would have to make custom adjustments to the script files. For that, I do not have any instructions I can offer you. There maybe some others here that can offer some pointers though or possible solutions to make it work the way you need.

I am all ears.. please.. anyone.. Thanks. That kinda stinks that it is not designed to do that.

Well I am a very smart girl.. figured it out all by myself. Just have to add these fields to make sure they map up..
_transactid_ , (VARCHAR, 40)
_fromaddress_, (VARCHAR, 255)
_flags_, (VARCHAR, 255)
_submitted_, (VARCHAR, 255)
_rowid_, (INTEGER, 40)

Once I added those fields in mysql.. it mapped up and dropped the data in just fine!
Just be sure the field names in the Name section in WFB and in your database and the field types are all EXACTLY the same. So you won't have any issues.

Thanks, Tina

BTW.. no adjustments to the script files were made.. only to the database fields.. just added those and wa la

I just now read the thread. I had the same issue and reached the same conclusion you did, Tina. However, I just created a table and let it form the fields to see what they are.