I’d love to have dynamic text in a form. For instance, the subheader can reference a cell, or use formulas like COUNT. ... View more

Sadly, the ARRAY functions don’t work in the way that people are expecting them to work in Airtable. And that leaves us with unresolvable problems in Airtable. The ARRAY functions work under a very limited set of circumstances, but it says right on the formula field reference page that they are supposed to work with lookup fields, rollup fields, and linked fields as an input. This just isn’t true, as you can see from this thread here. ARRAYJOIN, ARRAYFLATTEN, ARRAYCOMPACT, and ARRAYUNIQUE simply do not work under many common scenarios — even when feeding them the “approved inputs” of lookup fields or rollup fields. The ARRAY functions seem to only work when you have one input only, but not multiple inputs — even though the examples on the formula field reference page all show multiple inputs. For example, this problem remains unresolved, because the ARRAY functions don’t work as documented. Airtable Team: Please revisit these ARRAY functions and make them work under all circumstances. (And instead of changing the Airtable documentation to downgrade the functionality of the ARRAY functions, it would be better to FIX THE ARRAY FUNCTIONS so that they work as expected.) Thank you! 🙂 ... View more

Airtable has the useful feature of tracking the field names in formulas. Thus when we change the name of a field it’s automatically changed in formulas. When we create a formula field containing a URL to the pre-filled form we must type the name of a field that we want to pre-fill in a formula: "https://airtable.com/shr123456?prefill_My+field=" & {Another field} If we rename the field but forget to change the formula we will end up with the old field name in the URL and the pre-filling won’t work. The improvement I’d like to request is to add a new formula for getting the field name as a string by its reference. When we have it we can use it in the formula field: "https://airtable.com/shr123456?prefill_" & ENCODE_URL_COMPONENT(FIELD_NAME({My field})) & "=" & {Another field} and the field name in the URL will be updated each time when we rename the field. ... View more

Right now if you have a column you can see the sum, average, median, min, max, range, and few other summaries of every record in that column. One thing I think would be very useful for formula columns is to apply that formula to all columns. So if the formula for column 3 is Column 1 / Column 2… then the summary applies the same formula to the sum of column 1 and the sum of column 2. The closest thing that I can come up with is “average” but that isn’t accurate. ... View more

Hi Airtable. I’d like the ability to override the contents of formulae-text cells with text of my own. I most commonly use this for record titling/naming. We use Airtable as a meeting/diary manager. So if we put in the people who attend, the formulate title could be “Roger meets David”, but we could override that title to become “Financial Planning Meeting 3”, say. You can think of it as “overriding” or as “defaulting” but the point is that there are lots of time when i want formula-based default titles which can be changed to something else later. ... View more

It has come to light that the VALUE() function is broken. The VALUE() function is supposed to extract numbers from a string. It’s designed to be used as a simple filtering tool to remove non-numbers from a field. This is how it is documented on the formula field reference page. Instead, the VALUE() function does at least 2 completely different things: The VALUE() function converts certain letters into numbers, and then multiplies those numbers by the closest numbers that it can find! This issue is documented here:   Value Formula Returning Numbers not Found in Cell Formulas Hi Andrew— I can’t find any documented place that lays out this behavior or why it’s happening, but I did figure out what’s going on. The VALUE() formula seems to be responding to memory units of measurement. It’s actually reading 2020 MAINT TBZ as “2020 times 1TB”, IE 2020 x 1099511627776 (the amount of bytes in one Terabyte) = 2221013488107520. Same thing for INSP 2021 AMB West, which it’s reading as “2021 times 1MB” I discovered it’s reading memory units this way, from kilobytes all the way… The VALUE() function interprets certain symbols as operators to perform math on all the extracted numbers from a string. This issue is documented here:   Interesting discovery: The VALUE() function performs math Formulas This is an interesting little discovery regarding the VALUE() function. On the formula field reference page, it makes it seem like VALUE() will simply extract all the numbers from a text string. But this isn’t true under all circumstances. The VALUE() function will sometimes perform mathematical functions as well, if certain symbols are included within the text string! For example, the formula VALUE("**6hxyzb0**00987**") will extract all the numbers and return 6000987. This is expected. But… We do not know what the complete list of letters & symbols are that cause the VALUE() function to fail, so there is no telling how many different ways this function can fail. In my opinion, everybody should avoid the VALUE() function. Or at the very least, proceed cautiously when using it. ... View more

The challenge: Not being able to combine rows together with clean separation. The solution: The ability to use a formula like this =TEXTJOIN(" | ",TRUE,AQ2:BJ2) This would be a HUGE help for me (and I’m sure many others). ... View more

It would be nice if Airtable added a “click to call” formatting for phone numbers. That way if you use Skype/Teams or another service you can simply click the phone number you want to call. The mobile app allows it, so not sure why we can’t have on web app. ... View more

Is there a way to add a prefix or suffix to a number entry. Really important feature! ... View more