This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
One of our biggest feature requests is that we would love to see gigantic improvements to formulas — in particular, way more flexibility with typing in formulas, and better improvements to error capture.
More specifically, these are our top 3 requests for formulas:
Please allow us to have a much larger typing area for formulas, more like a real programming language would allow. Currently, we can’t press the “return” key within our formulas — nor can we space out the formulas to be more readable.
On that very same note, the formulas should be waaaaay more understanding & waaaaaay more forgiving when it comes to spaces & returns. All other programming languages simply ignore extra spaces or extra carriage returns, but any of this causes Airtable to give us an error message. For example, the first formula below works just fine. But the 2nd & 3rd formulas below don’t work at all. The ONLY difference is one extra space in the 2nd & 3rd formulas. All other programming languages would understand that these are the exact same formula, but not Airtable.
Formula #1 — this one works:
IF(AND(City=BLANK(), {Event Name}=BLANK()),Country,IF({Event Name}=BLANK(),City,{Event Name}))
Formula #2 - this one doesn’t work:
IF (AND(City=BLANK(), {Event Name}=BLANK()),Country,IF({Event Name}=BLANK(),City,{Event Name}))
Formula #3 - this one doesn’t work:
IF(AND (City=BLANK(), {Event Name}=BLANK()),Country,IF({Event Name}=BLANK(),City,{Event Name}))
Thanks,
Scott