This might not work, but thought I would ask just in case:
I have a base that has all of my clients & projects broken down in and then I have another base that I have all of my promotion broken down in. In my promotion base I want to come up with an ROI that updates automatically.
So I was wondering if there is a way to somehow relate the table that have my promotional information in and a table that has my client information in so I can link the ad campaign that got me that client and in turn have the money I make overtime with that client show next to the campaign it’s linked to so I can create a formula field to show an ROI that updates on its own next that specific campaign.
You can use Airtable Sync to do a one-way/read-only sync from a source view to a destination table, and you can additional editable fields to the destination table. You can also link to records in that destination table as if they were local records. More details here: