A lookup list is a fully customizable multi-column data set that you can query from inside of a form from the list field. Lookup lists can have as many values and columns as you need. This custom column data can also be mapped to other fields in the form based on the selections you make.
Note that your created list can only be in .csv or .xlsx formats
Here is a sample excel file of a vehicle tire inventory list that will be used as a lookup list:
Here we have the tires sorted in multiple columns: brand, type, price and item number.
To upload a lookup list:
Go to the FastField Portal and click on the List section.
In this section, sort and manage your lists in this window. Create a new lookup list by uploading your file or editing one of the templates provided.
Next, click the green button in the top right corner that says “New List” and click lookup list in the dropdown.
Then, give the list a unique name that you can easily sort by later and upload the excel file.
If the upload was successful, you will be shown a message confirming all of the rows and columns have been processed.
If you have missing column information you will be given this error :
If you have duplicate column information (ex A.) you will be given this error :