Hi - I’d like to be able to create a calculated multi-line field. My use case is turning 4 separate (Non-US) address fields into an address block for export. I’d like users to be able to copy and paste a multi-line address block for one-off letters etc (ie without export and merge).
I have created a calculated field with the formula:
((IF({Address 1} = “”, “”,{Address 1} & ", ") & IF({Address 2} = “”, “”,{Address 2} & ", ")) & IF({Address 3} = “”, “”,{Address 3} & ", ")) & Postcode
…but I’d like to be able to replace the comma and space with a New Line or New Paragraph mark.
Any suggestions gratefully received.
... View more