MySQL data source

Good afternoon.

Recently we announced a new module of integration with the MySQL database, and today you have the opportunity to use the MySQL database as a data source. Recall that you can still use google sheets and FormDesigner form as data sources.

How do I create a MySQL data source?

To create a new MySQL data source, go to the "Data Sources" menu and click on the "Add" button:

Page with the list of data sources

You will see a page with a list of all available data sources. Find the MySQL data source, point the cursor over it and click the "Add" button:

Adding the MySQL data source

Then a page with the basic MySQL data source settings will open:

MySQL Data Source Connection Parameters

Here you should enter the database connection parameters:

  • Host (domain name or IP address)
  • MySQL user name, under which all queries will be executed
  • MySQL user password
  • Port
  • Name of the database to connect to
  • Encoding

Please note that your database must have remote access enabled, and the user has the right to access from the ip address of our server - 188.124.47.199

After all the data is filled in, you should click on the button "Get access to the database":

If everything is entered correctly, you will see two lists "Database Table" and "Table Column":

Setting up a table and a column of MySQL database

Select, respectively, a table and a column of the table, which will be used as data in the form, and press the "Save" button:

Table and column of MySQL database

Go to the desired form, where you need to connect as options for switches, checkboxes or drop-down list, the source MySQL data. In the edit mode of the desired item, it is necessary to enable the option:

Activate MySQL data source

And select the data source from the drop-down list:

Choose MySQL data source

Save your changes and in the form view, the answer options will be the data from your MySQL database table.

That's all for today. Have a nice day!

Comments
Ready-made templates of web forms
Basic

Make an appointment to see a dentist

Make an online appointment with the dentist Details
Basic

Conference room rental

Get a selection of optimal offers for renting a conference room Details
Platinum

The story of your career

Play-based testing template will help your users find out what kind of career he is developing: drama, comedy or action Details
Gold

Rent a car

Find out the cost of renting a car and get a discount for passing the survey. You can edit the template and add/remove fields. Details

We use cookies to make it easier for you to use the website. By using this page, you agree to our cookie policy.