How to create a view filter for a field that is populated from zoho.currentdate.getYear()
I have an income-expense form with a field called "Year" that is populated by On Add -> On Load -> "input.Year = zoho.currentdate.getYear()"
I created a view that will print and serve as a report. The view contains the Year field. I need to be able to filter this Income vs Expense view based on the record in the year field but not a STATIC year (ie Year == "2013"). The user will not be able to edit the view and so will not be able to create a new static filter each time the year changes. What is the script to create such a filter?
I've also tried to create a "Current Year" filter in script but it would not show in the live view.
filters
(
Date_field
"Current Year" : Year == zoho.currentdate.getYear()
)
Update:...
I just noticed that the filter above does work, however, the pull down for the custom filter is NOT listed in the filter box but you pull down under the TITLE of the view? Is that correct or a glitch?