Combining data of two different column in a new table

[jeremy_b]

Hi there ! 👋

First of all english is not my mother langage, sorry if my english is not perfect.

I'm working on a customer networking project.

We have a multitude of tables, but there's no specific naming convention. they're table used by sales people, so not necessarily a tech culture. 😅

For example, in one table to determine which sales rep is the owner of a customer, the name is "owner", in another it's "Account Manager".

To create a dashboard grouping together a multitude of information, I've decided to create join tables, as the information I group together will inevitably be useful elsewhere.

Is it possible to add the "owner" and "Account Manager" information in the same column to this join table?

In SQL, it's possible to do this with "virtual columns", but I haven't found anything about this on Airtable.

If this doesn't work with Airtable, do any of you have any feedback on data aggregation using Airtable -> Zapier -> Google Sheets -> Airtable type automations?

Thanks for reading.

[Brian_Sweeny]

It's difficult to answer this question without visibility on your base. My spidey-sense is telling me, however that you may not have your data structure properly set up. If you can share screenshots, maybe I can help. - Brian 

[TheTimeSavingCo · Accepted solution]

If you're on a plan that supports it it seems like multi source syncing would do the trick: https://support.airtable.com/docs/multi-source-syncing