- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 08, 2023 09:04 AM - edited ‎Aug 06, 2023 01:25 PM
Hello, I am looking for a way to combine five fields (address, second address line, zip code and city) to a new multiline text field when another field "second zip code" has a value.
So here is an example of the five fields:
- Address: 220 Miller Avenue
- Second Address line: Apartement 50
- Zip Code: 22033
- City: Paris
- Country: France
This values should be combined to the multiline text field "complete address" (with a line break "\n" after each line, except between the zip code and city):
220 Miller Avenue
Apartement 50
22033 Paris
France
But the six fields should only be combined if the field "second zip code" has a value (i.e. 22033).
Is this possible somehow with a formula field?
Thanks for help,
Michael
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 08, 2023 10:08 AM
Yes this is possible. There are many possible ways. Here is one.
IF(
{second zip code},
CONCATENATE(
{Address} & "\n",
IF({Second Address line}, {Second Address line} & "\n"),
{Zip Code} & " " & {City} & "\n",
{Country}
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 08, 2023 10:08 AM
Yes this is possible. There are many possible ways. Here is one.
IF(
{second zip code},
CONCATENATE(
{Address} & "\n",
IF({Second Address line}, {Second Address line} & "\n"),
{Zip Code} & " " & {City} & "\n",
{Country}
)
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 09, 2023 01:13 AM
Thanks @kuovonne , works perfectly 😀
