Skip to main content

Link items

  • February 28, 2023
  • 1 reply
  • 0 views

Hello, i am new to airtable and really love it! I built an inventory list. This list is linked to another table for our videoproduction. Here we can choose items from our inventory we need for the shooting. This is working flawlessly. We now want to generate a packing list for the shootingthat displays all the selected items in a new table. So my first question is how can I setup a filter to the linked inventory list to show only selected items in our shotlist?

the second question is: Is it possible to link items to another? For example If i select a camera for the shooting, batteries should be automatically selected as well.

 

1 reply

TheTimeSavingCo
Forum|alt.badge.img+18

> how can I setup a filter to the linked inventory list to show only selected items in our shotlist?

I'm not sure how your tables are set up, but assuming you're doing something like this:

Then using the following filter seems like it'd do what you'd like?




> Is it possible to link items to another? For example If i select a camera for the shooting, batteries should be automatically selected as well.

Well, sort of but not really.  You could create another linked field in your "Items" table, where you link the "Camera" item to the "Batteries" item like you said, and so you'd end up with something like this:


Link to base


Reply