I am trying to find a way in Airtable to have specific record fields sync between tables, where the records across the tables are the same but have different fields with some being similar.
This would mean that if you had two tables, with two duplicate record titles, that specific fields would update across both records if only one was updated.
For example, let’s say you have Investors and Companies as table titles. There is a column in Companies that links to Investors. Some of those companies will also be investors, so they would have a record in both tables. How can I have it so that both records will update when I update one of them?