Skip to main content
Solved

Returning lookup values for multiple instances of a field's value

  • April 4, 2023
  • 4 replies
  • 49 views
J
Forum|alt.badge.img+8

Hello all --

I am having a challenge bringing in data from a lookup field.  We have a table that lists incoming deliveries as each row.  There is a column labeled "tags" in this table that where we want to show tags from another table (product details) that the delivery table is linked to.  The challenge is that while each delivery is unique, the products associated with the delivery are not.  What seems to be happening is that the first instance of the product name (which is how the lookup is working) is returning the tags but not for all instances.  Is there a way to override this?  

Thanks,

Justin

Best answer by Justin_Eppley

Fortunately, I figured out the best way for me to do this was to change the link structure and link out from the table I am bringing data into rather than vice versa.  Thank you.

4 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Could you provide screenshots of your tables as well as an example of what you'd like to see based on said screenshots please?

Adam, Airtable Consultant - thetimesaving.company
J
Forum|alt.badge.img+8
  • Justin_Eppley
  • Author
  • Inspiring
  • April 5, 2023

Could you provide screenshots of your tables as well as an example of what you'd like to see based on said screenshots please?


Hi @TheTimeSavingCo ,

Please see screenshots of the tables.  The first one is the table where we are pulling in the field "Product Tags" and the second table is a synced view that has the product tags we are pulling in.  In the first table, you'll see a good example of what I am talking about.. the product labeled "Bedtime Chews (10pk)" has no product tags being populated for that particular instance, however, they are being pulled in for the first instance of that product further down the table.

Thanks,

Justin

 

 

 

 

 

 

TheTimeSavingCo
Forum|alt.badge.img+31

Hi @TheTimeSavingCo ,

Please see screenshots of the tables.  The first one is the table where we are pulling in the field "Product Tags" and the second table is a synced view that has the product tags we are pulling in.  In the first table, you'll see a good example of what I am talking about.. the product labeled "Bedtime Chews (10pk)" has no product tags being populated for that particular instance, however, they are being pulled in for the first instance of that product further down the table.

Thanks,

Justin

 

 

 

 

 

 


Thanks for the details!

> In the first table, you'll see a good example of what I am talking about.. the product labeled "Bedtime Chews (10pk)" has no product tags being populated for that particular instance, however, they are being pulled in for the first instance of that product further down the table.

Hm, I don't see another instance of "Bedtime Chews (10pk)" in the first table.  Could you also provide a screenshot of the "Incoming Wholesale" table with the linked field you're using to link each product to the table with the product tags?

Adam, Airtable Consultant - thetimesaving.company
J
Forum|alt.badge.img+8
  • Justin_Eppley
  • Author
  • Inspiring
  • Answer
  • April 7, 2023

Fortunately, I figured out the best way for me to do this was to change the link structure and link out from the table I am bringing data into rather than vice versa.  Thank you.

Terms & ConditionsAccessibility statement