Help

Combining data of two different column in a new table

Solved
Jump to Solution
235 2
cancel
Showing results for 
Search instead for 
Did you mean: 
jeremy_b
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

See Solution in Thread

2 Replies 2
Brian_Sweeny
6 - Interface Innovator
6 - Interface Innovator

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
18 - Pluto
18 - Pluto

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