Select from Excel Sheet

There are JDBC drivers available for all commonly-used databases and Excel and CSV files. Therefore, you can connect to a spreadsheet containing a list of items you want to be available in a custom field.

First, add the spreadsheet as a connection in setting up an external database connection.
Create a scripted field.
Give the field an appropriate name and description then enter the following into Retrieval/Validation SQL:
```
sql
select id, "First Name" || ' - ' || "Experience Level" from devs
  where id = ?
```
Enter the following into Search SQL:
```
sql
select id, "First Name" from devs
  where "First Name" like ? || '%'
```
When applied to an issue context, the results display as a drop-down: