Skip to main content

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

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}
)
)

  

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}
)
)

  


Thanks @kuovonne , works perfectly  😀

Reply


Terms & Conditions