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

I am requesting that Airtable add a user-specific, customizable dashboard by user. To my understanding, if you add a block, every user can see that same block. Different departments need to see different information. I haven’t been able to find how to do this. If there is already a way, please point me in the right direction. Do you have a webinar training for this? Thanks! ... View more

Quite surprised to discover today that Airtable doesn’t offer basic image editing tools such as rotate or crop. We took a bunch of photos on an iPhone directly into Airtable iOS and the perspective is sideways with no option to correct. Only solution at the moment according to the below Airtable support article is to download the file, correct, and then reupload which is a hassle. Can I edit images in Airtable? ... View more

Hi Airtable, I have created a new attribute which links from one table1 to table2. In table3, I have added a lookup field and grouped by it. However the ‘+’ option to add new rows is not available. It would be a great feature if there was the ability to add new rows in grid view when grouped by roll up/lookup/expression fields ... View more

The Scripting Block offers a number of asynchronous functions for collecting input from the user. To date, all the example scripts I’ve seen use these APIs one at a time in a sequential fashion, e.g. const name = await input.textAsync('What is your name?'); const birthplace = await input.textAsync('Where were you born?'); This pattern is serviceable, but it produces an unideal user experience: users are led on a forced march through one question at a time. That can be disorienting when folks run a script for the first time, and that’s particularly apparent when more input is required. Given that the APIs all return Promises, I expected to be able to compose them in parallel and prompt the user for all input simultaneously, e.g. const [name, birthplace] = await Promise.all([ input.textAsync('What is your name?'), input.textAsync('Where were you born?') ]); That would show users the full extent of the required input “up-front” and offer them the freedom to provide it in a sequence of their choosing. In the Scripting Block today, the second code example does not function as intended. the UI is initially rendered according to the use case (both input fields are present) entering data into either field causes a “spinner” animation to be appended to the document (somewhat confusing, but not entirely disruptive) entering data into the second field causes an error to be displayed, e.g. ERROR R: userInputStartTime at main on line 30 ... View more

I’m very new to AirTable but I have significant experience with all sorts of IT and coding. I have searched both the help and the community and I am surprised this has not come up. I have seen references to using Zapier, etc. but that seems to be a complicated route versus making it a built-in feature. I would like to be able to create a table that can be used to catch emails sent directly to a specific email address for that table. Obviously, this would require AT to have an email infrastructure that could handle the incoming email, or, as another method, allow the user to create an email box in their own email system (Exchange, O365, Gmail, etc.) which AT would be able to access in order to grab the messages and populate the contents to the table. I would imagine this might be best done using a predefined template that would map to the appropriate email fields (sender/from, subject, body, attachments, cc addresses). This would be very similar to the way Slack, Jira, MS Teams, etc. allow email to be used as an input source for discussions, etc. I think this would be an excellent feature to include in the paid versions and would extend the functionality. For example, I am in the middle of a website rollout and would like to gather testing feedback from our team. Ideally, I would have testers use a form, but an email would also be an excellent “low friction” way for many of our testers to provide that info. Obviously, this would require some thought, but I do think it would improve collaboration capabilities. If this is something the AT community/product team has considered, I would love to know your thoughts. Thanks and thank you for such a great product that is a joy to work with. ... View more

Airtable Automation Action Add an Airtable Automation Action to Filter so to prevent an Airtable Automation from continuing to run if conditions/criteria are not met. Settings AND/OR conditions Multiple condition criteria • Evaluate right side of condition operators with static or dynamic values Example This can be used to evaluate the output of an Run Script step. ... View more

I’m building a time tracking and project reporting base, and I often find myself needing to use conditional rollups to create meaningful reports. This means I need to create a ton of IF formula fields on one table to rollup on another table. It would save substantial amount of time if Airtable had a bulk formula field creation feature. This could be an option in the field dropdown menu: Selecting this option would allow users to upload a .csv file containing each forumla: IF({Person} = "Anne", {Hours}, 0); IF({Person} = "Clyde", {Hours}, 0); IF({Person} = "Daisy", {Hours}, 0); IF({Person} = "Elle", {Hours}, 0); IF({Person} = "Gordon", {Hours}, 0); IF({Person} = "Hilda", {Hours}, 0); IF({Person} = "Ken", {Hours}, 0); IF({Person} = "Julia", {Hours}, 0); ... And a formula field would be created for each value. This would save countless hours and make Airtable even easier to use. ... 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