+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: How to add custom date filters? (/showthread.php?tid=14527)
How to add custom date filters? - lolekbolek - Aug 15th, 2016
My form collects service requests from clients. To view them, I go to "View submissions", where I see a table with all the fields. Right now, it is sorted by "Date of service", but the problem is that the first page of the table starts with the first service date that was entered long time ago.
Question 1: can I add a filter like "All dates after first of month" or "All dates after today" (including today), or "60 days after today"?
Question 2: can I make any of such filters the default when I open the view?
Many thanks in advance!
RE: How to add custom date filters? - ADaniel - Sep 2nd, 2016
This has been on the wish list to be added as a feature in FormTools by other users for awhile now, but no change has yet been made to that Standard Filter in the View itself.
The only way I can think to get around this is bit clumsy, but would provide the ability to do some filtering. Copy your existing View as many times as you need to make additional Views, each containing a "Standard Filter" with a specific date range. For instance, one view could have a filter of anything after a specific date, or between two dates (such as a month range), etc. Create as many Views as you need basic filters (obviously awkward to create an infinite number of views for every scenario, so you might have a View that contains a filter for specific year, or specific month/year). Then make sure the particular client who needs this is assigned the view(s). You can easily switch between the views when you pull up the Form's list on your screen, as the views accessible to the particular user appear in a drop down box on the upper right.