The Adaptavist Group LogoDocumentation

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.

  1. First, add the spreadsheet as a connection in setting up an external database connection.
  2. Create a scripted field.
  3. Give the field an appropriate name and description then enter the following into Retrieval/Validation SQL:
    select id, "First Name" || ' - ' || "Experience Level" from devs
 where id = ?
  4. Enter the following into Search SQL:
    select id, "First Name" from devs
 where "First Name" like ? || '%'

When applied to an issue context, the results display as a drop-down:

Search documentation

Start typing to search the docs.