I’m looking for help related to setting up filters for a custom list.
- Here is a my situation:
Users on my app can create an availability status (letting their friends know when they are available, usually between certain times on a certain day that they set) using a form; they can either create a new status or they can edit their current status (by filling out a new form, or editing a current one). I have then set up the ability for users to see their friends statuses using a list on the users home page.
- The issue I’m facing is this:
What ends up being displayed in the list on a users home page are all statuses submitted by their friends at any time. What I want to show is the most up-to-date status, where availability is current (as in the time and date set by the user via the form is still current, not in the past). I want this information to display only while it remains current (as in once the availability date and time have passed, I don’t want the status to display in the list any more).
- Any thoughts on how I might set this up?
I’ve tried setting up a custom filter to only show statuses where the availability time and date are before the current time, but it’s very possible that I’m not doing something right. I’m still fairly new at this. I’m also wondering whether there is the ability to clear or reset to empty a form once the current form content is no longer valid (as in the availability end date and time have passed?)
Any help would be greatly appreciated.