I like to bump up this one, sorry to be annoying, I just hope anybody from Airtable staff is reading this enough.
Add error highlighting to formula boxes: Not just saying… “Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.”
So many things are on my wishlist in terms of the formula box but this one is the #1 and it would be amazing to see something implemented soon, it’s so simple:
Add some basic error highligting and (if possible) precisely underline where the error in the formula is. Often, the error in the formula as simple syntax missing like bracket, or instead of “” there is "’ etc.
Having the formula box showing where the error in the formula is would greatly reduce the amount of time fixing the formulas.
Update: I use “CotEditor” app on MacOS so I can fix those missing brackets easier (suggestions from @Bill.French and @Justin_Barrett ), but still other characters like missing " & " causes frequent issues. It it was a complex formula, I wouldn’t expect Airtable formula editor to teach me how to write my formula but simply highlighting missing " & " in my 20 lines long concatenated formula would reduce the amount of time it takes to fix the formulas.