Data Source "Google Table"

Good afternoon.

After the last announcement of new modifications, where we talked about adding a new tool "Data Sources", which allows you to connect an external source to the form element to load a list of answer choices. So after this announcement, we were very much asked to add a data source, which will load data from the google table. And today we are in a hurry to inform you that such a data source is ready.

How to create a data source "Google Sheets"?

First of all, you need to create and configure the data source itself, which will read data from a given google table. To do this, go to the list of data sources by clicking "Data Sources" in the menu on the left:

List of connected data sources

You will be presented with a list of all data sources you have created. To add a new data source, click the "Add" button and you will see a list of sources that can be configured:

Adding a new data source Google Table

Find the "Google Sheets" data source there, move the mouse cursor over it and click on the "Add" button, after which you will see a page with the main parameters of this source:

Setting up the source of data

Here you need to enter the name of your data source, frequency of data update and specify Google ID of the sheets from which we will receive data. To find out the table ID, open it in your browser and in the address bar copy the characters between "/d/" and "/edit":

Defining the Google Table ID

This is the Google Table ID, which must be inserted into the corresponding field on our website.

Once you have specified the ID, we need to gain access to read the data from this table. To do this, click on "Get access to the table" and you will be redirected to another page where you need to confirm access "FormDesigner" by selecting your Google account:

Choosing an account in Google

Click on your account and click the allow button:

Confirm access to the Google table

If you have done everything correctly, you should load the sheets from the given table and the list of columns:

Selecting a sheet and a column in the Google table

Select the desired table sheet and column to extract data from, and click the "Save" button. This completes the "Google Sheets" data source setting.

How to connect the data source "Google Sheets" to the desired element of the web form?

After the necessary data source is created, you can proceed to connecting it to the form. For this purpose we open the necessary form and go to "Elements" section. Find there a suitable element of the form (drop-down list, checkbox, switch or autofill) and go to its settings:

Connecting the data source to the web form element

A separate checkbox "Use the data source for answer choices" has appeared above the answer choices. Having chosen this checkbox, instead of the answer choices, a drop-down list with connected data sources will appear:

Choose a data source for the answer choices

Where you can select the desired data source for your answer choices. Once you have connected the desired data source, don't forget to click on the "Save" button and then you can check the form operation.

That's all for now. Have a good day!

Comments
Ready-made templates of web forms
Gold

Apartment repair

Calculate the cost of repairing the apartment 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
Basic

Online appointment

Make an appointment with your customers or partners using the online appointment form. Details
Gold

How much does it cost to rebuilt a car

Specify parameters of disks and find out the cost of tire service for your car. Details

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