I am developing a dock check-in and punchlist combination tool for some of our employees. The gist is that of the primary tables, one (let’s call it Dock Check) is to be a list of each item, summarizing their quantities and listing every room in which the specific item is to be placed. The second of the primary tables (let’s call it Punch List) is organized by room, and lists each item in the room.
I want a field in Dock List to return every room in which the item is listed on the Punch List. I can’t determine if I’m just having trouble with the logic or if this isn’t a possibility in Airtable.
The only supplemental table presently is a rooms table, which just lists the room #, room name, and department.
Thank you in advance for your help!