Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.
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!!!