How to expand the entire field of a list collector

SusanSchwar
Tera Contributor

I have a variable called "Additional contacts." It pulls from the sys_user table to display the names of users within the organization to select from. The problem is, there are Mutiple users with the same name and no way to distinguish them. Is there a way to use the reference qualified to expand the field display drop-down to include the email addresses tied to the accounts?

1 REPLY 1

Rafael Batistot
Tera Sage

Hi @SusanSchwar 

You can customize the display of items in a List Collector variable so that users are easier to identify such as showing both name and email address from the sys_user table.

However, the List Collector dropdown only shows the display value (usually name), and does not natively support multiple fields in the UI. But you can work around this using one of the following options:

Use a Display Field with Name + Email

  1. Create a new field on the sys_user table:

    • Name: name_with_email (or something similar)

    • Type: String

    • Default value: Scripted via Business Rule or Background Script

  2. Populate it with something like:

    current.name + ' (' + current.email + ')';
  3. Make this field the Display Value (not ideal if sys_user.name is used widely this affects other places)