Reference (or List Collector) show 2 field

Nguyen Quang Tu · ‎05-24-2023

Hi experts,

When a reference (or list collector) field reference to Group Member(sys_user_grmember) table, it will display as User[Group] format. So is there anyway that I can make other table display as the same as Group Memebr table? the Variable attributes only allow me to display two or more field in the drop down list, but only show display field when chosen.

Thanks in advance.

OlaN · ‎05-24-2023

Hi,

That is correct. When using a list collector you can show one or more fields when browsing the list of options, but when a option is selected only the display-field will show up in the selected items.

A workaround would be to create a new field that is set to display, and have that new field contain all the values of the different fields as needed.

You would need to populate it using a business rule, or perhaps create it as a calculated field.

View solution in original post

Arun_S1 · ‎05-25-2023

Hello,

Group Member table by out of the box has only 2 fields

1. Group - Reference to the Assignment Group (sys_user_group)

2. User - Reference to the User Table (sys_user)

I believe you have a custom field in the Group Member table which is a calculated field and concatenating the user name and the group name for a better visibility. Looks like this custom field is set to Display True in the dictionary.

Similarly, you can also create a new field in any table and make that as a calculated field and have the required value populated.