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.
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?
It's easy to overlook something you're not looking for.
Here's my S-Drive site with
examples of what can be accomplished in VSD.
Here's my CoffeeCup SCCP Shop with examples of what can be done.
This is a site I built for my work.(RSD)
This is a site I built for use in my job.(HTML Editor)
This is my personnel site used for testing and as an easy way to share photos.(RLM imported to RSD)
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.
_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.
Want personal and specialized help with RLM, RSD or with converting your VSD (or other) site to RLM/RSD? Email me at email@example.com or call 865-687-7698.
Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.