Lookup list selector

The Lookup List Selector is similar to a Global List Selector except that instead of uploading your data with the required Name, Value, Filter Key and Score fields, your data can contain whatever columns you need. Once uploaded, you can then map the Name, Value, Filter Key and Score fields to the fields in your data.

Additionally, Lookup Lists allow you to map values from the uploaded Excel sheet to other fields in the form based on what you choose in the lookup list. Details on how to perform this can be found in our article on Lookup Mapping.

Lookup List Selector configuration panel in the FastField portal

Note
The Name field is required, you can set this once you select or upload your Lookup List. The Name is the column that will be used to populate the list the user will choose from in the app. In the example below, that means the user would select from the product names when selecting an option from this field.

Lookup List name field mapping showing the column selected from the uploaded list

Configuration

Setting	Description
Field Label	The label displayed for the field. This is usually displayed at the top left corner above the field.
Field Key	A Key used to reference the field in submission data. The key is also used to reference the field in rules and calculations.
Hint Text	The text that is displayed if the field has no value set, e.g. "Please enter a value"
Field Filter Key	A referenced Field Key of another field that will filter the Values based on the Values - Filter Key.
Memory Field	If a previous form containing the same Field Key has a value set, it's value will be pre-populated for this field when the form is first opened.
Allow Multi-Selection	More than one value can be created and submitted in the form submission.
Rules	Rules that perform actions on fields or sections within the form. The actions can include hide, show, enable, disable, showSection and hideSection. Rules are executed on field value changes and when the form is opened. May also include a JavaScript snippet, for example: `if ($lookuplistpicker_1$ > 23) { hide(); } else { show(); }` (See the Introduction to Rules document for more information)
Required	Sets the field to have required input. You will not be able to submit the form until this field has valid input.
Enabled	If not set the field will be visible but cannot be edited or set to accept new input.
Hide Question	Hides the Field Label.
Hidden	If enabled the field and all labels are not visible.
Exclude From Reports	If checked, the field will be excluded from HTML and PDF reports and will also be excluded from Excel and CSV exports.
Geo Location	Capture the current latitude and longitude when the acknowledgment button is clicked.
Time Stamp	Capture the current date and time when the acknowledgment button is clicked.
Alert Type	Choose a theme to change the background and font colors of the field cell as displayed in the apps.
Lookup List	(Required) The selected Lookup List from the available Lookup Lists setup on the Account.
Name	(Required) Map the column from your chosen Lookup List that will be used when the list is displayed.
Value	Map the column from your chosen Lookup List that will be stored as the value when the form is submitted.
Filter Key	Map the column from your chosen Lookup List that will be used when the Field Filter Key is set.
Score	Map the column from your chosen Lookup List that will be used for any calculations requiring numeric data.

Result Data

Data Type	Domain of Values	Example JSON
String Array	N/A	`{ "lookuplistpicker_1": ["abc"] }`