I’m using airtable to track software, on servers, in locations. I have a table setup for locations, that are linked to servers in the servers table. And the software table is linked to the server table. So software on server, in location. Is there a way that Airtable can dynamically create a lineage view so that when I put in the name of the software, it will link to the server and then the location. Or putting in the name of a location and getting the servers, and then software that’s associated?
The goal of this would be for maintenance activities at any level, we’ll know what’s affected and can notify the proper location/software/server owners.