Hi there,
I would like to create a simple address column that shows a combined address from other columns like “street”, “city”, “zip code”, “country” and so on.
This is no problem with CONCAT({street}, {city}, {zip code}…). But I would like to create line breaks in the output, so that I can easily work with a nicely formatted address instead of a long string. I tried adding “\n” without success…
That may sound trivial or unnecessary, but this is what I would like to do. Can anyone help me?
Thanks in advance!