
Gareth_Chapman

6 - Interface Innovator
Comment Post Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Oct 23, 2016
04:04 AM
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.