Hello Fabrizio, your subject is under consideration at the Airtable team… at least that is what I understood from them. Peter B. from Airtable knows all about it. If I am correct I stumbled upon the same issue (more or the less) like you and like many others as you can tell from the email message I recently sent the Airtable team, and which I posted here down below:
" (…) As I stated, it is all about these two posts in this thread I found on your forum, an issue which I bumped into as well:
In the thread it seems one of your colleques is aware of this possible issue and refers to a better solution in the near future.
Grayfo replies with a quote:
- Unfortunately we don’t currently support the exact behavior you have described. In a linked field you can manually select a record you’d like to link, but after you do so the dialog closes and you must reopen it to select another record. We are considering changing this behavior, though! In the meantime our fill handle may be of use if you are linking multiple records to one record at one time. -
Off course the filling handle is no substitute to this issue because it just copies records without any true hidden conditional or relational functionality: in my opinion this would be too much of a ‘spreadsheet’ solution for a true Airtable user anyway. Plussing up previous given records by hand pop up window after pop up window and record after record is a painstaking process which I like to be seen being automated - or being automated in a better way - in the near future!
Indeed the lookup field is a true automation feature but it will only start after plussing up its related records by hand too.
Turns out, I am not the only one bumping into this issue once dig in deeper to all the search quotations on your forum related to the automation subject. Luckily.
And even Zapier jumped into the lack of the Airtable automation hole, although by linking bases instead of linking tables:
In other words: keep Airtable in the position of being a true advanced RELATIONAL DATABASE with spreadsheet looks, instead of the other way around. (…).
Automation, automation, automation!
I hope that by publishing this message it will help us all to let the Airtable team know that we’re in for ehm… automation!!