Expand my Community achievements bar.

Don't miss the Workfront Community Lens, June Edition!
SOLVED

Column that displays selection made in custom field with display logic

Avatar

Level 2

I am trying to create a project view that will display the selections made in two dropdown fields in the custom form. I have no problem with the first column, but the second column is a problem. I'm hoping this is something that can be solved with text mode, but my text mode knowledge is extremely limited. Here's the situation: We have Field 1 with nine possible choices. There is display logic for that field, so depending on which of the nine choices is selected, Field 2 (or 3, or 4, etc.) opens with it's own set of choices. I want to have a column for Field 1 (no problem there), but I would also like a column for the selection in Field 2 (or 3, or 4, etc.). I have spent several hours now searching through the community posts but haven't found anything that solves this particular problem.

1 Accepted Solution

Avatar

Correct answer by
Level 9

Hello @DarcySm1, You can try this text mode which concatenates Field 1 and Field 2/3/4.., seperated by a pipe " | ". Replace Field 1 with your main field having 9 options and Field 2/3/4.. with dependent fields.

displayname=Text Mode
linkedname=direct
valueexpression=CONCAT({DE:Field 1}," | ",IF(ISBLANK({DE:Field 2}),"",{DE:Field 2}),IF(ISBLANK({DE:Field 3}),"",{DE:Field 3}),IF(ISBLANK({DE:Field 4}),"",{DE:Field 4}))
valueformat=HTML

 
You can also use shared column. For more details, please refer to this page: View: Merge Information from Multiple Columns in One Shared Column | Adobe Workfront

View solution in original post

2 Replies

Avatar

Correct answer by
Level 9

Hello @DarcySm1, You can try this text mode which concatenates Field 1 and Field 2/3/4.., seperated by a pipe " | ". Replace Field 1 with your main field having 9 options and Field 2/3/4.. with dependent fields.

displayname=Text Mode
linkedname=direct
valueexpression=CONCAT({DE:Field 1}," | ",IF(ISBLANK({DE:Field 2}),"",{DE:Field 2}),IF(ISBLANK({DE:Field 3}),"",{DE:Field 3}),IF(ISBLANK({DE:Field 4}),"",{DE:Field 4}))
valueformat=HTML

 
You can also use shared column. For more details, please refer to this page: View: Merge Information from Multiple Columns in One Shared Column | Adobe Workfront

Avatar

Level 2

This worked! Thank you!!!