I have a table “A” that needs to pull records form another table “B”. Table “B” has records of personnel activities based by date.
Person 1 may have 6 activities on certain date. Instead of pulling records one by one, I would like to pull all records based on person’s name and date.
Thanks in advance for your help
Pull records from one table to another at once
+3What do you mean by “pull”? Are you talking about creating a report? Just having quick access to those 6 records?
+3What do you mean by “pull”? Are you talking about creating a report? Just having quick access to those 6 records?
I have a table “A” to use for producing a report using page designer.
I need to populate some fields from records in table “B”. Table “B” have several people doing several activities (e.g. driving time, working time, assisting time) in a week. I need to retrieve each person with their activities from table “B” to table “A”.
Right now I’m using a link feature, but I am retrieving or “pulling” same person several times manually until done with their weekly activities and making math calculations for that person on same record.
I have a table “A” to use for producing a report using page designer.
I need to populate some fields from records in table “B”. Table “B” have several people doing several activities (e.g. driving time, working time, assisting time) in a week. I need to retrieve each person with their activities from table “B” to table “A”.
Right now I’m using a link feature, but I am retrieving or “pulling” same person several times manually until done with their weekly activities and making math calculations for that person on same record.
You should be able to do something like this. Its in my free base so I can’t add a page designer but you can add a field for “Table 2 Link” and then add columns to get multiple entries to show.
You can also add a few more tables with dates to get creative with date/week filtering
2 tables - Airtable
Explore the "2 tables" base on Airtable.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.