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 - 85.10.210.202

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
Gold

House construction calculator

This online calculator calculates the cost of a box house in various configurations and shows the price of erecting a house Details
Gold

Calculating the cost of building a house

With this quiz, the user is prompted to answer several questions that can be used to calculate the approximate cost of building a house Details
Platinum

Concrete works "Turnkey" using professional formwork

With the help of this quiz, the user is encouraged to answer a few questions that can be used to calculate the approximate cost of concrete work Details
Platinum

Order a kitchen with a unique design

Order a kitchen with a unique design. The template in the form of a quiz helps to find out the user's wishes, make an order and get a gift in the form of a discount Details

Order turnkey form development

No time to figure out all the settings yourself? No problem!
Order web form development from us