Forum Discussion
Filter table based on user input
Add the date field from your calendar table to the page as a slicer and choose "after" drop-down option.
You can then remove the slider feature and condense the object to only show the date field the user would be entering into.
Thanks Drew, Got the date table down. How can I make it so the Project tables shows any project that has an End Date after the date chosen? I want it to take the day entered, look at the other table and only display those that have an "End Date" after the date input in my new date table.
Sorry, my ignorance. I just made a relationship between Date and End Date and it works. Sorry, Brain fart.
While I have you here, how can I make the default date in my calendar be "Today" so they do not have to scroll through past dates? Thanks
Glad that it is working!
I might be misunderstanding the next question... I thought you wanted to simply have a field that a user can type a date into to filter the table. Is that still the desired result? Or are you asking if that field can be defaulted to TODAY so that the user does not have to type it in?
It was my understanding that your desired result would look like this where the user would enter the date to filter:
select date filter to relative and choose option -> This and Days, like this:
