Help

Nesting and organization for formulas

Topic Labels: Formulas
Solved
Jump to Solution
1590 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Steve_Hazeltine
4 - Data Explorer
4 - Data Explorer

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?

nestingcode

1 Solution

Accepted Solutions
momentsgoneby80
7 - App Architect
7 - App Architect

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.

See Solution in Thread

4 Replies 4
momentsgoneby80
7 - App Architect
7 - App Architect

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.

Welcome to the Airtable community!

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

Steve_Hazeltine
4 - Data Explorer
4 - Data Explorer

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!

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.