This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
I’m using Airtable to plan some PPC campaigns. I have a formula concatenating a bunch of different keyword sets, which reference the product name from an earlier field in the record.
Google AdWords prefers to have each keyword set on a new line.
Is there any way I can produce a line break in the formula output so that each can be pasted straight in?
Any news about this?
Matt, if you put “\n” in the formula it will work. Since the Formula field is just a one line field, you have to copy the whole cell (without clicking on it).
Bruno, can you show an example of the \n in use please?
\n works. Add it to a formula, and when you copy/paste the results outside of airtable, the line break will be apparent.
“first line \n second line \n\n fourth line”
Please note - the line breaks are invisible in airtable, unless used in the primary cell.
Here’s an example of the “\n” line break technique.
In this example, the table is being used to store contact info (name, address, etc). A “full address” formula column might be configured with this formula:
Full_Name & "\n" & Street & "\n" & City & ", " & State & " " & Zip
Copying and pasting a cell from that column would result in something like this:
657 Airtable Avenue
Jacksonville, FL 55555
Just as Zac and Tim showed. By the way, I think it would be a great implement if we could show the formula field as a multi-line field.
I have tried the “\n” trick, and it does work to create a line break if I copy the field and paste it into Word. However, the result also contains quotation marks at the beginning and end of the field. How can I get rid of those?
In playing about with “new lines” tonight, \n also doesn’t reflect within Grid Views. I am curious if it’s possible to reflect a new line within the grid view of a formula return?
Anyone got an idea on how to avoid the start and end quotations on the pasted multi-line field? It pastes like this:
“12 Appleby Road
That’s the expected behaviour for copying out of a multiline cell, unfortunately. (You’ll also run into the same problem with Google Sheets)
The last time I had this problem I wrote a small browser extension to modify the clipboard contents, but you might have better luck just removing the quotation marks once you’ve pasted it.