Searchable lookup fields use lookup tables to provide consistent, reusable values. Instead of free-typing, these fields let you type to search and select an existing value, which helps reduce errors and keeps data organized.
You’ll know a field is searchable when it says “Type here”, or "Search for...", and includes a magnifying glass icon at the end of the field.
Example:
In the Report a Concern Module, when entering Violation Details, the Ordinance # and Ordinance Description fields say “Type here.” This means when you search and select from the existing list of ordinances, it will automatically populate both fields.
If the value you need isn’t listed, you can add it in two ways.
1. Adding a value directly from a searchable lookup field
This is the quickest option when you’re already entering a record.
-
Click the magnifying glass at the end of the field.
-
Click Add New.
-
Enter the required information for the new value, and click Submit.
The new value is added to the lookup table for that field and selected in your record.
2. Adding values from the Lookup Tables
You can also add values directly from the lookup table itself. Use this option if you want to add values outside of a specific record, if you need to add several values at once, or manage the list more intentionally.
-
From the Home Page, click Modules.
-
Scroll down to the Lookup Tables section and click to open the lookup table you need.
-
The table will open in the Data Viewer, just like any other module.
-
Click Create New for every new value you need to add.
-
Enter the required information.
-
Click Save or Save and Close.
Once saved, the new value is immediately available to anyone searching that lookup field in the module.
Related terms: searchable lookup field, add lookup values, type here field, magnifying glass icon, lookup tables, ordinance lookup, auto-populate fields, shared lists, reference data