Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 07, 2023 06:51 AM
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?
Solved! Go to Solution.
Apr 07, 2023 12:47 PM
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.
Apr 07, 2023 12:47 PM
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.
Dec 27, 2023 03:07 PM
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.
Jul 22, 2024 01:10 AM - edited Jul 22, 2024 01:10 AM
Hello, I also wanted to ask about this, as I am having trouble linking multiple tables into one interface