I'm new to the Filemaker Community, so I hope you'll bear with me for this question. I'm happy to read a link to another discussion if this has already been addressed. I just couldn't find anything for the life of me!
Anyways, I work for a non-profit music festival. I have an income list, where I keep track of who is donating money to what event. The problem is that my event value list (based on the EventID) shows all of my events - ones that passed months ago, and ones that are upcoming. Is it possible to limit that list? When an event has passed more than a week ago, it would be amazing to not see it in the list. I only want to see values of events that have passed up to 7 days ago, and events that are still upcoming.
I'm tracking a fair amount of information in my events, including the date. I'm just not sure how to make that information useful in something like this.
I'm stumped, and super grateful for any advice!