Navigate between interfaces with custom filters

[Minez97]

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?

[Pascal_Gallais-]

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

[Minez97]

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

[Pascal_Gallais-]

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