This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
Airtable today supports the linking of one table to another via a field, but that field must be populated either by:
Option 1 works, but can be annoyingly inefficient from a data entry perspective.
Option 2 is too kludgy and isnโt practical for anything beyond a 1 time data population.
Option 3 adds complexity and the need to learn/bring in another system.
Ideally, thereโd be a way to auto-populate the Linked Field using a formula. The linking would either find a correlated record in the linked table, or if none found, then create a new record.