Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

Multiple Selection Field

Avatar

Level 3

Hi WF Community, how do you make the multiple section field to move to a new row in Workfront reporting? 

A_EN_0-1725346096195.png

 

1 Reply

Avatar

Level 9

In that scenario, you need a bit of text-mode trickery. Workfront understands the selections in a multi-select dropdown as a comma-separated string rather than independent items. So you can use the 'REPLACE' formula to replace all commas in the string with the code for line-break as below.

 

Caution: The moment you hit save, Workfront will automatically remove one of the two slashes in the formula below. When you need to edit again, you have to put that second escape slash back each time. 

 

The only thing I've never figured out is how to make it show the field label, in the case where you have different items in the value vs label for each item in the dropdown. This will only get you the value of the field, which isn't always meant to be human-readable. 

 

displayname=LA Languages
linkedname=direct
textmode=true
valueexpression=REPLACE({DE:LA Languages},",","\\u000A")
valueformat=HTML