Getting the information going into a...

Oct 12th, 2014 at 07:18 AM
User 2623310 Photo

Scott Larson
Ambassador
282 posts

Hi All,

I have made a new form and entered the information for the database before I exported the form. I then went to my database made new table for the form.

Is that all I need to do or something more to do to get the information going to base?

Thanks for your help. :)
Oct 12th, 2014 at 07:46 AM
User 2147626 Photo

SadDuck
Ambassador
2,958 posts

Don't make the table for the form! The first time the form is submitted the program will create the table for you. It actually causes problems if you create it ahead of time. Just use a BLANK database and all will be well.
Graphics for the web, email, blogs and more!
-------------------------------------
https://sadduck.com
Oct 12th, 2014 at 07:50 AM
User 2623310 Photo

Scott Larson
Ambassador
282 posts

Hi Gunsmoke,

I went back into the database and deleted the table that I already created. Want do you mean blank directory?

Thanks
Oct 12th, 2014 at 01:53 PM
User 2147626 Photo

SadDuck
Ambassador
2,958 posts

I didn't say 'blank directory'. I said 'blank database'. Means an empty database. A database with no tables or information.

When the form saves information the first time it should create the tables it needs. I just find using a new database for each form just helps me keep information in order.:cool:
Graphics for the web, email, blogs and more!
-------------------------------------
https://sadduck.com
Oct 12th, 2014 at 04:09 PM
User 187934 Photo

Eric Rohloff
Senior Advisor
20,271 posts

I like keeping the actual database for my forms the same but every form gets a unique table name. Makes it really faster in the form builder so all you have to do is change the table name.:) No logging in to your server to create a database.;) All the info will still be in order.:cool:
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
Jun 10th, 2016 at 04:07 PM
User 2739026 Photo

juricta
Registered User
7 posts

I see a lot about MySQL and Form Builder. What I have not found is How do I connect my form to a database (MySQL).
I want to create a form that will take user input and save it to a database for viewing/editing later.
Jun 10th, 2016 at 08:29 PM
User 187934 Photo

Eric Rohloff
Senior Advisor
20,271 posts

Hi Thomas,
In the form builder click on Settings at the top.
Now select the Storing Results tab.
Tick the Save to a MySQL database.
Now enter the information for access to your mysql database. The form builder will create the table for you so don't create the table ahead of time just the database.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

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.