When concatenating text into a Long Text colu...

(Simon Robinson) #1

When concatenating text into a Long Text column, is it possible to add carriage returns?

(Aleksi Alkio) #2

Would you please show an example, thanks.

(Simon Robinson) #3

So the long text would display something like " Option 1 = £1000 Option 2 = £2000 Option 3 = £3000 "

So… I’m assuming something like this exists:

Concatenate( "Option 1 = ",[ColumnA],, "Option 1 = ",[ColumnB],, "Option 3 = ",[ColumnC], )

I can do the concatenate bit easily, but I’ve not seen anywhere you can force a .

Whereas you can do this if typing it in.

The idea behind it is that its a way to display data in a kind of table.

Where each option might have 3 different prices and I don’t want the user to have to scroll up and down.

(Aleksi Alkio) #4

Concatenate( "Option 1 = “,[ColumnA],”

","Option 1 = “,[ColumnB],”

","Option 3 = ",[ColumnC])

1 Like