Displaying project-specific years in Airtable views

[Cora74]

Hi! We've created a base with a tab for each project (e.g., Project 1, Project 2, etc.), and within each project, we need to view (in the interface) the payments made, sorted by year. To manage this, we've created a column for each year within the base. However, this setup makes all years visible across all projects, which is not ideal since each project has a different timeline. For example, if Project 1 runs from 2022 to 2025, I would want to see only those years on that project's page, and not years that apply to other projects (like a project spanning 2008 to 2025).

In the interfaces, we have different tabs for different projects (e.g., charity projects), but currently, we don't have the option to filter the years so that only relevant years show on each project’s page. Is there a way to display different years per project within the interface, rather than having all the same years appear across all pages?

Thank you!

[TheTimeSavingCo]

Hm could you provide screenshots of your tables and how the Interface looks currently?  Without knowing how you've structured your data it's difficult to help!

[Cora74]

Hi Adam, you're right! 🙂 

The Base:

Here's the interface:

 

This is the page detail:

I would like to find a way so that on each detail page, we only see the years related to the selected project.

for exemple, for the first one, "Progetto S.", I only need to see "quota errogata 2020 , quota errogata 2021 , quota errogata 2022"  and not 2023 etc...  

I hope the explanation is a bit clearer..! Thank you in advance!!

[TheTimeSavingCo · Accepted solution]

Ahh I see, you're looking to dynamically display fields based off of each record's data?  This isn't possible at this point I'm afraid

If you were open to changing your base structure so that you're adding one record per year instead of one field per year you could achieve this though:

Link to base

[Cora74]

I did something similar to your suggestion, and it seems to work well. Many thanks for your help!! 🙏😊