Skip to main content

Auto Update linked columns

  • March 1, 2016
  • 5 replies
  • 25 views

Is there a way to automatically copy values from one column into a linked column? Could I achieve this by having a formula in the linked column that copies data?

5 replies

Forum|alt.badge.img+5
  • Inspiring
  • 332 replies
  • March 8, 2016

There’s no way to automate this as far as I know, but you can take a single-line text column and convert its contents into a linked record field (watch the video under “Linking Existing Tables of Related Records” in this support article). So maybe you could intermittently convert the linked record column into a single-line text field, copy and paste the text values you’d like to convert over that column, and then reconvert the column into a linked record column? I don’t think this would be the convenient solution that you’re looking for, unfortunately. I’ll pass on your feedback to the team.


  • Author
  • New Participant
  • 4 replies
  • March 8, 2016

There’s no way to automate this as far as I know, but you can take a single-line text column and convert its contents into a linked record field (watch the video under “Linking Existing Tables of Related Records” in this support article). So maybe you could intermittently convert the linked record column into a single-line text field, copy and paste the text values you’d like to convert over that column, and then reconvert the column into a linked record column? I don’t think this would be the convenient solution that you’re looking for, unfortunately. I’ll pass on your feedback to the team.


I am able to achieve that with out changing the column type, I just copy the records over every so often. Thanks for the response.


  • New Participant
  • 3 replies
  • October 14, 2017

I am also interested in auto updating information in table, but I’m specifically interested in auto updating one table into a different table in the same base. Has anyone figured out a solution?


  • New Participant
  • 1 reply
  • March 19, 2018

Just bumping this! Really hope Airtable takes notice.

It could be as simple as creating parsing in the function codes.

I was having the same issue because when updating records from my frontend program, you cant update linked fields. So this was a workaround for that original problem for me.


Forum|alt.badge.img+1
  • New Participant
  • 2 replies
  • May 8, 2020

I was really looking forward to using Airtable to manage a whole host of my volunteer organization’s data, but the very first thing I tried to do is blocked by this missing feature… My case is simple: I have a growing list of sign-ins to meetings, and I want to keep a derived Membership table that identifies all unique members who have gone to meetings. I can easily make this table at any given time and do aggregations (like a count of meetings attended), but am I to believe there is no way for new additions to the sign-in sheet to be aggregated into the derived Membership table? I would have thought this was pretty basic.