Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

Dynamic Dropdown or Typeahead fields on Custom Forms

Avatar

Level 6

11/4/21

Custom Forms: Custom fields populated from lookup of (internal/external) data source


It would greatly enhance usability for both admins and general users if it were possible to create a Typeahead or Dropdown lists that reference internal-to-Workront sources (i.e. csv file uploaded as a Document? an admin-controlled table?) or external data source like gSheet or database. When the user chooses a value from a custom field from multi-choice options presented, the selected value should be used to start a query that looks up related values and returns them in either read-only fields or to another field presenting a subset of list of options (e.g. dropdown or typeahead)

Example 1 - Read Only fields returned:

If you have a Typeahead field on a form called "State". User types in string "CA" and the field looks up the external datasource column for State to populate typeahead suggestions

User Gets typeahead suggestions of "California", "N. Carolina", "S. Carolina"... & selects "California".

This executes a query to a "geo" database using California as search parameter to return the related values for Country and Continent.

The following 3 fields are populated on the form:

State: California

Country: USA

Continent: N. America



Example 2: Custom Dropdown list gets narrowed down by a selection in a previous custom field


User chooses from one dropdown list called "Color Family" the value Blue

In a subsequent dropdown list that contains a super-set of all colors, only the following values are presented as options:

  • Sky
  • Azure
  • Teal
  • Navy
  • Cerulean
  • Cobalt
  • Turquoise
    • etc...

In other words, when presenting dropdown list values, the list would dynamically suppress any values in the big list that aren't associated with the Color Family, Blue.


The relationships between color families and colors would be defined in some table internal or external to Workfront.

2 Comments

Avatar

Employee

9/26/23

Hi Mylah,

 

I'm happy to let you know that we have added the External Lookup field type to custom forms that might cover your needs. It is already in preview and will be released with the upcoming release.

 

Here you can find more details on that.

 

Thanks

Gagik