I’m a newbie and starting to understand how Airtable works. But I have a question I can’t seem to figure out. I’ve read through a few similar posts/answers but not exactly matching up to what I need.
I have two base tables: users and jobs. Both of these tables can grow infinitely. I need to associate users with jobs conditionally. Because both users and jobs will continue to grow, having an association column in either table isn’t the most efficient way to approach this. Instead, I simply want to select users and jobs where ‘x’ & ‘y’ conditions are met and insert that data into a third table. That way, my app can point back to the third table.
Does anyone have any suggestions?
This interests me as well. I’m not sure of a way to do it in AT either. My hope is that I can use miniExtensions’ CSV download tool. Still not sure how it’s going to work, but I think with this tool it’s possible to schedule a regular download from specific views in an Airtable base and import into excel/sheets. I’d also have to figure out how to build something in excel that could accept and merge the two tables. Moe from miniExtensions seemed to think it was doable.
Also, Airtable is telling me to welcome you to the community, so, welcome to the community! lol
Thanks for the welcome and feedback. Yikes, yet another tool to consider and integrate. If only there was a simple sql statement you can append to a table in AT, it would make all of this so much easier.
Hi guys, I think you’re referring to automatically linking records between different tables? Is this correct?
Airtable doesn’t support the automatic linking of records between bases based on field values.
All linking of records is done “manually” — meaning that records must be “explicitly” linked to one another by the user.