Skip to main content
I have a database with two tables connected in a one-to-many schema. I built an interface with two pages, and I would like to link them using filters so that when the user clicks a button in the parent page, the child interface page with childrens data opens, filtered by the selected parent.
 
Is there a way to implement this natively or through a URL?

Hello,

Here is an example.

Parent page

My parent page is a list of car brands and is the only page visible in the interface:

When I click on the icon 🔎 for a given brand, it opens a page with the list of this brand's car models:

To do that, you first create you "child page". It must be a type of page that can be filtered by your parent field, a record review page on field brand in this example.

Publish you child page a copy the URL up to the equal sign:

Go to you parent table and add 2 fields:

"Brand zoom page" is a formula to concatenate the copied URL part with each record id using Airtable RECORD_ID() function:

"Brand zoom" is a button connected to the URL from field "Brand zoom page":

You can then go back to you interface to add field "Brand zoom" in the parent page and to hide the child page.

Regards,

Pascal


Hello,

Here is an example.

Parent page

My parent page is a list of car brands and is the only page visible in the interface:

When I click on the icon 🔎 for a given brand, it opens a page with the list of this brand's car models:

To do that, you first create you "child page". It must be a type of page that can be filtered by your parent field, a record review page on field brand in this example.

Publish you child page a copy the URL up to the equal sign:

Go to you parent table and add 2 fields:

"Brand zoom page" is a formula to concatenate the copied URL part with each record id using Airtable RECORD_ID() function:

"Brand zoom" is a button connected to the URL from field "Brand zoom page":

You can then go back to you interface to add field "Brand zoom" in the parent page and to hide the child page.

Regards,

Pascal


How did you link the two tables? I followed the steps, but it always loads all the results from the child table.

Thanks a lot for the response


Hello,

My example uses 2 tables, table "Brand" being the parent table and table "Model" being the child table.

In table "Model", each record is linked to a unique brand, meaning that when my "Child page" is filtered by a brand, it only shows the models belonging to this brand.

Could you send me some screen captures of what you have done so that I can understand better what is not set as it should be?

Thanks

Pascal


Reply