I have found a few posts about this already, but none more recent than two years ago. I find this feature gap baffling, and I can’t imagine being able to use Airtable without it.
My use-case is simple. I have an ever-growing list of sign-in for meetings. I want to have a separate membership table that has one row per unique person - a given person will sign in to many meetings - and, for example, a count of the number of meetings that person has attended. This is trivial to do with linked records and Rollup columns. However, as best as I can tell, for each new record in the source sign-in sheet, I have to manually add those linked records to the derived membership table. That is a nonstarter for me, and I have several other use-cases I was hoping to make after this prototype, but they all require this very simple feature.
I don’t understand why a column can’t be set to automatically link to all records in a corresponding table. This is the most basic feature of any relational system. What am I missing?
People have been asking for this feature for a long time, too: Auto Update linked columns
Automatically linking a record from a different table