Exact matches only
Search in title
Search in content
Search in posts
Search in pages

How to connect web forms with a CSV database file

Connect web forms with a database by using our Virtual database and dynamic prefill app integration. Starting with our Corporate plans you can benefit from this feature to empower your business and productivity.

Once the form(s) are linked with your CSV file, the information gathered will populate your database. Prefill forms fields from your CSV table to save time and improve consistency.

Let’s look at an example:

First, you will need your database in a CSV format. Below are listed the CSV file’s requirements:

  • Cells are formatted with text
  • Field delimiter is set to comma
  • Text delimiter is set to quotation marks
  • UTF-8 characters supported

Once you have the CSV file ready, go to your form’s Settings – Applications section.

connect web forms with a database

Search for CSV the Virtual database green icon, listed with DAT, and click on Add.

Note that the application is displayed only when the account is upgraded to one of our Corporate plans.

The tables can be uploaded as a CSV file, through the Create New Table button. Here you can name the table and the given name will be used in the SQL rules, to return values.

Tables can be managed in the Explore Database section.

connect web forms with a database

Tables will be displayed in the left-side panel. Clicking on a table will open its content in the main view.

connect web forms with a database

Create SQL rules to specify the acceptable values that can be inserted into a column or to prefill form fields. Create queries to search for certain customers that meet specific criteria.

connect web forms with a database

By prefiling your forms fields based on a keyword you can avoid mistypes. The information is automatically pulled from your database and form users don’t need to re-enter their details over and over again.

Even if you are not familiar with SQL queries, our corporate plans have an advantage. Once you sign up, a dedicated Account Manager will help you develop your forms based on your needs.

Related articles:

Leave a Reply

Your email address will not be published. Required fields are marked *

Frequently Asked Questions

Here is a list of the most frequently asked questions. For more FAQs, please browse through the  FAQs page.

Is this service free?
Yes, we offer a free form builder service. Just sign up to the Basic plan and you are all set. This plan is forever free, but you are limited with a few features only, such as 5 forms per account, 100 submissions per month and you have to keep the backlink to 123FormBuilder on your forms. Check out our features matrix for more information.
How many forms can I create?
It depends on the service plan you are on. Higher service plans enable more features, including more web forms for your account. If you need more forms, go to the My Account section of your account and click the upgrade button. To create an unlimited number of forms, either upgrade to the Platinum service plan or higher. Consult our features matrix for more information.
How can I publish my forms?
You can publish your forms in many ways, by using their direct URL or HTML link, embedding them with a JavaScript code, Inline HTML or iFrame, using the Facebook app or the WordPress plugin, using popups, the Blogger code snippet and many more. Once you have created and customized your form, go to the Publish section to complete your work. Read more in our documentation.
How do I change my form design?
You can change the design of your form in the Themes section, which is located in your form settings. We offer a set of more than 30 predefined form themes for your forms, but you can also create your own from scratch. You can customize the submit button, the logo and more. To apply your own stylesheets, all forms come with a custom CSS editor.

Can't find what you're looking for?