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.
