Update:
I figured out how to get the Table 1 to pull from Table 2 by making linking the Product field in Table 1 to Table 2.
Then, when adding the Lookup field, I made sure to select the corresponding field in table 2 I wanted it to pull the information from.
However, there's a small detail that's bugging me.... Table 2 now has a field that says EP Sales Tracking 2 and it's populating with the dates to the corresponding orders.
Is there away to change the field that populates this field on Table 2? If not, I'm fine with just hiding it and ignoring, but figured I'd ask.
I attached some screenshots.
With grace,
JQ
Update:
I figured out how to get the Table 1 to pull from Table 2 by making linking the Product field in Table 1 to Table 2.
Then, when adding the Lookup field, I made sure to select the corresponding field in table 2 I wanted it to pull the information from.
However, there's a small detail that's bugging me.... Table 2 now has a field that says EP Sales Tracking 2 and it's populating with the dates to the corresponding orders.
Is there away to change the field that populates this field on Table 2? If not, I'm fine with just hiding it and ignoring, but figured I'd ask.
I attached some screenshots.
With grace,
JQ
Hi JQ,
Welcome to Airtable! Nice job figuring out the linked field & lookup, that's a great solution!
When you are using a linked field in another table, it will always show the Primary Field of each linked record. In this case it looks like your Table 1 has the date as the Primary Field (the first column of the table), so that's why it's populating the date in Table 2.
You can easily change the Primary Field of Table 1 to something more identifiable, like Last Name, by right-clicking on the header of the field and clicking "Change primary field". Note that there is only one Primary field for every table, so if you link those records to another table, whatever you set it to will also show up as the Primary Field there.
I hope that helps -- feel free to let us know if there is anything else you run into!
Rowan
Hi JQ,
Welcome to Airtable! Nice job figuring out the linked field & lookup, that's a great solution!
When you are using a linked field in another table, it will always show the Primary Field of each linked record. In this case it looks like your Table 1 has the date as the Primary Field (the first column of the table), so that's why it's populating the date in Table 2.
You can easily change the Primary Field of Table 1 to something more identifiable, like Last Name, by right-clicking on the header of the field and clicking "Change primary field". Note that there is only one Primary field for every table, so if you link those records to another table, whatever you set it to will also show up as the Primary Field there.
I hope that helps -- feel free to let us know if there is anything else you run into!
Rowan
@MxRowanP that makes sense. Thanks for that insight, that's super helpful.