Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Auto-populate linked field using formula

cancel
Showing results for 
Search instead for 
Did you mean: 
Matt_Kivlin
5 - Automation Enthusiast
5 - Automation Enthusiast

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
Matt_Kivlin
5 - Automation Enthusiast
5 - Automation Enthusiast

One more update to my original post for those interested. I leveraged the recommendations from the linked post below to use an Automation. I created a couple of fields in my base table. One field that calculates the value I want to populate into the linked field. Another field that compares that value against the current linked field value, which is what’s used to flag records where the linked field value needs to be updated.

I then created an Automation with a Trigger of “When a record matches a condition” (set to key off my calculated field) and a Scripting action. I don’t Javascript but used the code snippet from the linked post and muddled my way through it.

Clubhouse_X-Pri
4 - Data Explorer
4 - Data Explorer

Any further updates?

Todd_Grier
5 - Automation Enthusiast
5 - Automation Enthusiast

After significant frustration and attempts to learn to write scripts (and many failures), I finally happened upon this solution in the Apps Marketplace called ‘Link Records by Field’: Link records by fields - Apps - Airtable Marketplace

It worked on my issue. Hope it works for you all too.

Kate_Price
6 - Interface Innovator
6 - Interface Innovator

I was able to do this using Airtable Automations.

For some background, data in my base is populated by a Zap that pulls in survey responses from another application. The responses include the title of a webinar (WebinarTitle) attended by the respondent. I wanted to autofill a linked record field (WT) with the webinar title, so that I could have a separate table for information about the webinar.
image

I set up an update automation with the following steps:

  1. Trigger: When a record is created (in my ProdData table)
    Screenshot 2021-05-06 173711

  2. Action: Update record (in the same ProdData table). I selected the Airtable record ID from step1 (so that it would select the same record that was just created). Then I told it to update my linked record field (WT) with the text from my WebinarTitle field.
    image

First attempt result:
This worked, however any webinar titles that had commas in them split and created multiple records in the linked table, which is not what I wanted. (Note: This only happens if you’re using a field with commas in it. If there are no commas in your data, this error should not occur and the steps up to this point should be enough.)
image
image

To fix this error, I followed the instructions in the “Using a formula to add quotes in bulk” section of this article - I created a new formula field (WTx) to treat the title as one chunk of text, rather than a list of items.

This is the formula I used:

‘"’ & {WebinarTitle} & ‘"’

This added quotation marks to the beginning and end of the webinar titles in my WTx field.
image

Then I went back to the action step of my automation and replaced the WebinarTitle field with my new formula field (WTx).
image

Second attempt result:
Yay! This did exactly what I wanted it to.
image
image

Anbarasu
4 - Data Explorer
4 - Data Explorer

This app worked for me !

JoaoGalvao
4 - Data Explorer
4 - Data Explorer

Is this still not updated 4 years after this thread?