Filtering resources for a record

[mcnadger]

Hi everyone,

I'm pretty basic with Airtable, but have been using it for years.

I have created this base with an interface that explores the New Zealand Maths curriculum. 

I now have a resources page, which is fed by a form so that teachers can submit resources to support areas of the curriculum. What I am wanting is a way to show specific resources based on the current record that they are looking at on the MATHS interface page, ie, filter the resources page to match what the current user is looking at.

Can I add a button to do this, or include the filtered resources in the actual math record? I don't want to individually have to do this for each record, some way of doing it globally/dynamic would be great.

[TheTimeSavingCo]

Hmm I would try using a junction table to help with this.  Assuming your data looks like this:

Steps:
1. Create a new table called "Curriculum <> Resources"
2. Link the "Curriculum" and "Resources" tables to "Curriculum <> Resources"
3. Create formula fields in the "Curriculum" and "Resources" tables that concatenate "Strand", "Sub Strand" and "Year"
4. Paste the values from the formual fields into the linked field

And the output is this:

Which now allows you to set up your interface like so:

Link to base

---
To maintain the links in the Resources table, you can have automations that trigger when the teachers submit that
resource form you mentioned

For the Curriculum table, it'll depend on how it's being populated and you could do it manually