Autopopulating Data With the Lookup Field
The lookup field is used to access data from your datasets in order to autopopulate information into your form.
As an example, let’s say you are filling out a purchase order for a regular vendor. Rather than typing in all the fields, it would be great to autopopulate the vendor information.
Creating the dataset
In this example, the dataset has these fields: Name of the company, Nature of business, Contact person, and Phone number.
Configuring the Lookup field
Now, go into your form. Choose the field that will be the one that triggers the others to autopopulate and create is as a lookup field. In this case, it is Name of the company.
Under Choose a flow to look up, select the dataset that has your vendor information.
Then under Select the fields to use, you need to select all the fields you plan to use at any time in your form.
The next section says Hide some of the above fields from displaying during selection. Here, you can limit the fields that show when making the initial lookup. If you don’t select this one, then in the live form, all the fields will display like this:
If you hide all the other fields except for the name of the company, then only the name and the Key field will show.
Adding autopopulating fields
Now add the other fields you want to autopopulate as text fields.
Where it says Is this a computed field?, move it to Yes.
The formula you will use is:
[name of the lookup field ID].[name of the field in the dataset]
For this field, the formula is:
Do the same for all the other fields.
The live form
Back in the live form, when you choose the company name, all the other fields will automatically show up.
Here are other articles that will help you: