Matt_Kivlin
5 - Automation Enthusiast
Comment Post Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
โSep 30, 2019
07:49 AM
Airtable today supports the linking of one table to another via a field, but that field must be populated either by:
- Having the user key/select the appropriate value in the linked field
- Using a manual process to occasionally populate data (i.e. copy/paste)
- Using a 3rd party service like Zapier or Integromat to listen for record changes and populate the value
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.
16 Comments