Note: This feature is coming soon and is not yet generally available.
Data sources can be used to populate a series of fields in a form based on the answer to previous question. This can:
- provide key information to your field users,
- save mobile users time on data entry
- reduce errors in the field by auto-filling important information
This article will discuss ways to auto-fill questions based on a single answer, using dropdown or radio button questions and data sources.
For example, a building inspection form could push address information based on a building selection. It could also populate a repeatable section with information about the floors in the building, so that a user can inspect them.
|This is the blank form, before any Building Name has been selected. Here, you can see the empty Address and City fields, and the empty Repeatable Section.||Here, the mobile user selects a building from the dropdown.||The address and city questions have been filled out, and the Repeatable Section has three entries automatically populated.|
In our example, a user in the field is filling out a building inspection form. They select a single building from a dropdown or radiobutton question using a data source, and a single address and city are filled in.
Sample Data Source:
The Building column is used as the list of options in the dropdown. When a building is selected, the Address and City cells from the same row of the data source will be used to populate additional questions.
Set it up:
- Create the questions you want to populate answers in.
- You can push answers to: Text field, text area, dropdown, radiobutton, multiselect, date, time, date/time selector, duration field.
- When setting up these questions, ensure that the data type being pushed matches the question data type. Do not push text into a date field, and so on.
- Create your radiobutton or dropdown question. The radiobutton/dropdown question must come before the questions you are pushing data to.
- In the Options tab, select Use Data Source for Options. Select the appropriate data source options.
- Under Push Data to Other Questions, select Populate questions on the main form.
- select which questions you wish to populate
- and select the appropriate data source column to populate the answer from
It is also possible to use a data source to populate many entries in a repeatable section, based on a previous selection in the form.
The example used is a building inspection form: when a user selects a building name from the dropdown, it automatically creates repeatable section entries for each of the associated floors, so that the user can now go and inspect each floor.
Sample Data Source:
|The Building column is used in the initial dropdown. When mobile users select a building, the "Floor" question in the Repeatable section will be filled. If there are 4 floors associated with the building (as shown for Building A), 4 repeat entries will be created with the Floor pre-filled.|
Set it up:
- Set up a Dropdown or Radiobutton question as described above. In our example, this is the Building Name question that populates the rest of the desired questions.
- Under Options, select Populate questions in a repeatable section.
- Select which repeatable section to populate. Only repeatable sections that come after the question are shown in the dropdown. In our example, we have a Floors to Inspect repeatable section that follows the Building Name question.
Note: You can only push data one level in, e.g., from the main form to a repeatable section. You cannot push data from the main form to a nested repeatable section.
- Select which questions you wish to populate. Each of these questions will set a line item in the repeatable section.