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?