
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 26, 2020 03:35 AM
How to make a line break when I do strings concatenation?
For example, I have 4 fields and I do a concatenation:
"field_1: " & value_1 & ", field_2: " & value_2 & field_with_lots_of_text
I’m trying to do smth like that:
If I do like thins, it works ok:
But I want to add more data and add a line break:
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 26, 2020 08:11 AM
In your grid view, it actually did work, but it’s truncating all of your data onto the same line for you so you can see more of your data. If you expand the cell by clicking on that little blue icon that appears (or by hitting SHIFT-SPACE on your keyboard), the cell will open up and you will see that your line breaks are actually there.
Alternatively, if you increase your row heights by clicking on the “row height” button in your toolbar, you will be able to AUTOMATICALLY see your line breaks without expanding the cell. (Well, you’ll be able to see as much data as will fill the height of the cell.)
I’m actually not sure how to make all the lines of a formula field AUTOMATICALLY visible in gallery view. In gallery view, it seems like your only option is to MANUALLY double-click on each gallery card to see all your line breaks intact. (But perhaps somebody else knows how to view all the lines of the formula without double-clicking on the gallery card.)
It seems like Airtable doesn’t like to automatically increase the height of formula fields which have multiple lines on them. Unless someone else knows how to do this, this seems like a possible oversight in Airtable to me.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 26, 2020 03:47 AM
You can get rid of the <br>
and replace it with
& "\n" &

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 26, 2020 03:50 AM
Works, but not the way expected:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 26, 2020 03:50 AM
Is it possible to make it work at the Gallery view?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 26, 2020 08:11 AM
In your grid view, it actually did work, but it’s truncating all of your data onto the same line for you so you can see more of your data. If you expand the cell by clicking on that little blue icon that appears (or by hitting SHIFT-SPACE on your keyboard), the cell will open up and you will see that your line breaks are actually there.
Alternatively, if you increase your row heights by clicking on the “row height” button in your toolbar, you will be able to AUTOMATICALLY see your line breaks without expanding the cell. (Well, you’ll be able to see as much data as will fill the height of the cell.)
I’m actually not sure how to make all the lines of a formula field AUTOMATICALLY visible in gallery view. In gallery view, it seems like your only option is to MANUALLY double-click on each gallery card to see all your line breaks intact. (But perhaps somebody else knows how to view all the lines of the formula without double-clicking on the gallery card.)
It seems like Airtable doesn’t like to automatically increase the height of formula fields which have multiple lines on them. Unless someone else knows how to do this, this seems like a possible oversight in Airtable to me.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 26, 2020 08:23 AM
Thank you very much!
I decided to split it into to cells.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 31, 2024 03:11 PM
