Interface to show multiple tables?

[Ron_Daniel]

Longtime Airtable user, but limited experience with Interfaces.

My regular workflow has three browser windows open at once:
Window 1: Shows the fields of one record from Table A
Window 2: Shows a filtered view of the records in Table B
Window 3: Shows a filtered view of the records in Table C

Is there a way to create a single interface to show these things?

[kuovonne · Accepted solution]

Yes, you can show records from multiple tables in a single interface page.

How you go about it depends on whether or not you want to see linked records.

If the records are not linked, you can have independent grid views, each with their own filters. I like to use a filter element for this. Note that filter elements are not as robust as the filters in a view.

If the records are linked, you can show a grid of linked record. Note that if you want to show records from two tables away, you would need a second record picker based on the previous linked record field.

Another technique I use is to use a multiple-collaborators field in the parent record, paired with a script that ensures that a given collaborator is only in a single parent record. The other tables have chained lookups of the multiple-collaborator field. In the interface, the child and grandchild tables are filtered to only show records where the lookup of the multiple-collaborator field includes the current user.

[brooksvb]

Is there a way to display data aggregated between two tables in the interface?

For example I have inventory of physical computers and virtual machines in two tables, and they share a lot of fields, so I'd like to show a total count summed between them or based on a field condition.

[ragingcherry]

Hello, I also wanted to ask about this, as I am having trouble linking multiple tables into one interface