Automatically substituting values ​​from a data source

Hi!

Now you have the ability to automatically pull values from the data source into the required fields based on the specified values.

How it works?

Let's say you have a drop-down list where a data source, for example, a Google spreadsheet, is connected as answer options. All values from column 1 are loaded into this drop-down list.

In addition to column 1, there are several more columns with some data. Now you can configure it so that when you select a value in the drop-down list, values from other table columns in the row containing the value selected in the drop-down list will be pulled into other specified form fields.

To better understand how it works, watch the video below:

How to set this up?

  1. For a dropdown list, radio button, or autocomplete, connect a data source for the answer options.
  2. Add a text field into which you want to pass values from other columns of the data source. In the settings of this field, in the “Data Source” section, enable the “Enable substitution of values from data source” switch:
  3. Next, a list will appear in which you need to select the form element to which the data source is connected: Automatically substituting values from a data source 1
  4. Select a column in the data source from which the value will be transferred to this field. Automatically substituting values from a data source 2

This is how easy it is to set up automatic data transfer from a data source based on a given value.

That's all for today. Have a good day.

Comments
Ready-made templates of web forms
Gold

Find out the cost of accommodation in the hostel

Calculate the approximate cost of accommodation in the hostel and get a discount. 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
Platinum

Selection of auto parts

Template in the form of a request, where the user can select a car brand, year of manufacture, specify data from the technical data sheet, contact details. You can edit the template to suit your needs. Details
Basic

Online tire service record

Specify the dates of your tire fitting in the template, add the lockout time and receive requests from customers Details

Order turnkey form development

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