Help

Displaying project-specific years in Airtable views

Solved
Jump to Solution
303 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Cora74
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

 

1 Solution

Accepted Solutions

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:

Screenshot 2024-11-15 at 12.37.57 PM.png

Screenshot 2024-11-15 at 12.35.11 PM.png

Screenshot 2024-11-15 at 12.35.14 PM.png

Link to base

 

See Solution in Thread

4 Replies 4

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
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi Adam, you're right! 🙂 

The Base:Cora74_0-1731596931091.jpeg

Here's the interface:

Immagine 2024-11-14 161446.jpg

This is the page detail:

Immagine 2024-11-14 160308.jpg

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!!

 

 

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:

Screenshot 2024-11-15 at 12.37.57 PM.png

Screenshot 2024-11-15 at 12.35.11 PM.png

Screenshot 2024-11-15 at 12.35.14 PM.png

Link to base

 

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