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.
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.
|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.
(Please 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.|
|Data Type||Domain of Values||Example JSON|