How does one add a newline ( \n ) in the concat formula?

I am using and am attempting to make mailing labels for members. I need to insert a newline after the first address line and before the City.

The concatenation shows the literal ‘\n’. Is there a way to do this?

Hey @random,

I have created an issue to fix the confusion caused by the use of newlines in formulas, as some frontend components are not displaying them properly. You can find it here New lines in formula are not shown in the cell (#2197) · Issues · Baserow / baserow · GitLab

In the meantime, you can add newlines in the formula editor by typing Shift+Enter.
For now, you can see that the newlines are visible in the formula editor and in the row modal (the one that is open if you click the spacebar after selecting one cell or if you click the little icon at the beginning of the row.

Screenshot 2023-12-21 at 15.17.39

Hope this helps,

Thanks. I changed the formula as you described and the mailing label field no longer shows the imbedded ‘\n’.

Old formula: concat(field(‘Address_Line_1’),‘\n’,field(‘City’),', ‘,field(‘State’),’ ',field(‘Zipcode’))

Result: 5422 Sideroad Burson Ca 95123 “5422 Sideroad\nBurson, Ca 95123”

New formula: concat(field(‘Address_Line_1’),’
‘,field(‘City’),’, ‘,field(‘State’),’ ',field(‘Zipcode’))

Result: 5422 Sideroad Burson Ca 95123 “5422 Sideroad
Burson, Ca 95123”

Issue resolved.