Is there a way to concatenate an address with multiple lines? Meaning, can I enter a command to insert a line break? Would like to have Name, next line Company, next line city state zip. Then when I merge this can be brought in as one address block. or, is there another way to do this?
Thanks
Lee
Lee Waronker shared this idea · Jan 1, 2017
Comments
1 comment
Hi Lee,
Thank you for your question.
Yes, there is a new line function, and it is written as "\n" in your formula.
For example, if you want to pull in a date from all of your child records, with each date on its own line, on to your parent record, you would use "\n" as your separator in your childconcatenate formula.
Thanks again,
Justin
Please sign in to leave a comment.