I'm pretty new to zoho and deluge scripting. I have tried to do this thing that seems straightforward, but it is not working.
I have a membership form and a payments received form. Members pay dues each year. I want two views: one that shows who paid dues for 2012-2013 and one that shows who did not pay dues for 2012-2013.
My deluge criteria for the NOT PAID view is:
show all rows from Payments [Year_Dues_Paid_For != "2012-2013"]
This fails because if people paid in other years, they show up on the unpaid list list for 2012-2013.
If this was a regular database, I would specify the criteria like this:
show all rows from Payments WHERE NOT IN [Year_Dues_Paid_For == "2012-2013"]
But that doesn't work in zoho of course.
How can I enter criteria to show members who did not pay dues for 2012-2013?
Thank you,
Bonnie