Hi new to Airtable, and getting stumped combining data on 1 table from 2 other tables. using 1 table to reference another table. The setup is:
I have 3 tables Staff/Projects/Billing,
- in the projects table I assign staff to a project and count the hours
- in the staff table I have each staff member and their rate and location
- in the billing table I list a billing line item link it to a project and then from the projects table I pull in the assigned staff member and the hours worked. I then want to perform a lookup on the staff table using the staff name pulled from the projects table, using this to get the country and the price. But this is where I am getting stumped.
The obvious answer is that I pull the staff data to the projects table and then pull that data again to the billing table, but I want to avoid the doubling up if possible as in the long term this will be used on a largish database so any optimization I can achieve will help.
FYI in this situation, linked columns are single records only.
stills of the setup below to help explain.
Billing table - the price and country column are just to illustrate
Is there a way to do lookups as I’m after or is it better to just pull data through.