button to view table filtered by ID

That is not possible in the data layer, but you can get a similar experience to what you’re looking for on an interface page.

First, at the data layer, make sure that you have already created a linked record field in your main table. (This is the field where you will link record #33 to all of its related records in the agenda table.)

Then, at the interface layer, create an interface page based on your main table. I would recommend using the “Record Review” interface page for this.

Then, on your interface page, you can add the linked record field to that page.

However, in the right margin underneath “Appearance”, you would choose to display the linked record field as a “view” instead of a “field”.

This will enable you to automatically see all of a record’s linked records whenever you choose the main table’s record in the left margin.

So, for example, whenever you choose Record #33 in the left margin, you will automatically see all of its linked records on the page.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Thnak you. I will take a look

First, make sure your "Main" table is properly linked to the "Agenda" table using the ID field. You can do this by adding a linked record field in the "Agenda" table that links to "Main".

Once the link is set up, go back to your "Main" table. For each record, you will now see the related Agenda entries linked to it. You can also add a lookup field to pull the "Done" field from the linked Agenda records.

This way, when you're in the "Main" table, you can easily see all related Agenda records for each ID.

Taha, AIrtable Advisor

Hmm, I think you’d have to use an Interface for this I’m afraid.  I’m not sure what your workflow is, but I worked on a similar thing and basically summarized the data and then pulled it over via a rollup so it looked like the following.  For that workflow I just needed a birds eye view of everything though, so not sure whether it works for you

If that doesn’t work, then I reckon you could try an Interface and it might look like this:

And I’ve set up both here for you to check out!