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!

Ready-made templates of web forms

Calculation of MTPL

You can get the calculation of MTPL using the online calculator by entering the vehicle data. Details

Conference room rental

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

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

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

Order turnkey form development

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