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.
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
This worked! Thank you!!!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies