This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

- Airtable Community
- Product Ideas
- Improvements to formulas

Idea Options

- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content

Improvements to formulas

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

ScottWorld

18 - Pluto

Comment Post Options

- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content

Jun 06, 2019
10:36 AM

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}))

- Because Airtable is so rigid & strict & unforgiving when it comes to formulas, we need better formula errors. Airtable should highlight EXACTLY where the error is, so we don’t spend 2 hours (like I did the other night) troubleshooting a formula, when the only problem was simply an extra space.

Thanks,

Scott

See more ideas labeled with:

7 Comments

Idea Statuses

- New Ideas 541
- Already in product 11
- Considering 0
- In development 0
- Not on the roadmap 1
- Launched 24