Help

Re: Multiple Record Select Field as a List format desired

Solved
Jump to Solution
716 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Steve_McCaw
4 - Data Explorer
4 - Data Explorer

My PDB report includes a Multiple Select field and the report requires a LIST format instead of the defaulted line of selected items…

Q> Is there a way to have the print changed to a LIST format?
image

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

This is what I would do — create a formula field that creates carriage returns in between each value.

The multiple select field returns an array with commas in between the values, so you can substitute the commas for the carriage return symbol, which is \n.

So your formula field would look like this:

SUBSTITUTE({RENEWAL / NEW MARKETING},",","\n")

Then, use that formula field on your Page Designer document.

See Solution in Thread

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

This is what I would do — create a formula field that creates carriage returns in between each value.

The multiple select field returns an array with commas in between the values, so you can substitute the commas for the carriage return symbol, which is \n.

So your formula field would look like this:

SUBSTITUTE({RENEWAL / NEW MARKETING},",","\n")

Then, use that formula field on your Page Designer document.