Nesting and organization for formulas

[Steve_Hazeltine]

Like the example in the screenshot, I’m trying to organize my formulas for easier viewing. How in the bleep do you get formula onto a new line? Or indented? Is using an external editor the only way?!? I was wholly expecting the “Enter” key to do the trick, but not dice. What am I missing?

[momentsgoneby80 · Accepted solution]

Hi @Steve_Hazeltine1!
Airtable handily remembers indentations when you save a formula, but unfortunately you can’t create beautifully indented formulas directly in Airtable. I personally use Notepad++, but other free editors are available.

To get a new line you in your editor, without causing an actual linebreak in the output, you use Shift+Enter. For the actual indentation you use the Tab key. Unfortunately I don’t know the corresponding keys for Mac if you’re a Mac user.

[kuovonne]

Welcome to the Airtable community!

Steve_Hazeltine1:

Is using an external editor the only way?!?

Yes. Any plain text editor will work, but a code editor really helps with indenting and parentheses and quote matching.

[Steve_Hazeltine]

Hmm- Well, at least good to know I’m not losing my marbles. Was starting to feel crazy, trying to figure out how to add in spaces etc.

Thanks for the replies you two!

[ScottWorld]

It seems like Airtable retains some formatting in the formula fields if you’re using Chrome, but it doesn’t retain any formatting at all if you’re using Safari.