Skip to main content

Is there a way to put parts of a formula (while writing or editing it) on separate lines, like in a visual editor, to better organize? It works when I cut and paste, but I can’t figure out how to do it in the box.

Any suggestions?

In other words, how would I put this in to the editor, without cutting and pasting?:


SUBSTITUTE(

SUBSTITUTE(

SUBSTITUTE(

SUBSTITUTE(

SUBSTITUTE(

  {Article content},

     "Apple","Apple (NASDAQ:AAPL)"),

     "Alphabet","Alphabet (NASDAQ:GOOG)"),

     "Microsoft","Microsoft (NASDAQ:MSFT)"),

     "Amazon","Amazon (NASDAQ:AMZN)"),

     "Facebook","Facebook (NASDAQ:FB)")

In other words, how would I put this in to the editor, without cutting and pasting?:


SUBSTITUTE(

SUBSTITUTE(

SUBSTITUTE(

SUBSTITUTE(

SUBSTITUTE(

  {Article content},

     "Apple","Apple (NASDAQ:AAPL)"),

     "Alphabet","Alphabet (NASDAQ:GOOG)"),

     "Microsoft","Microsoft (NASDAQ:MSFT)"),

     "Amazon","Amazon (NASDAQ:AMZN)"),

     "Facebook","Facebook (NASDAQ:FB)")

You need to hit "Enter" quickly, before AirTable suggests a field or function.

If you miss, either hit enter twice (the first time will put in some AirTable suggestion and the 2nd a new line) and then delete the Airtable suggestion, or save the field and reopen it!

Reply


Terms & Conditions