Testing / Filtering on Checkboxes

Testing / Filtering on Checkboxes

Hi there,

Zoho Creator is a great application. I don't have any database backgound, but I am able to design a database for an NGO in South Africa, for free, as a volunteer. Thanks very much!!

I have a table with the member organisations of the NGO. They pay a small yearly fee for the services of the NGO. So they want to track if a member has payed for each year.

So I made an extra form with the code:
form Payments
{

OrganisationName
(
displayname = "Organisation Name"
type = picklist
values = Add_Members.Organisation_Name
)

PayedinYear
(
displayname = "Payed in Year"
type = checkboxes
values = {"2006", "2007", "2008", "2009"}
)

}


















I have a view with this code.

list "View Payments"
{
show all rows from Payments
(
OrganisationName as "Organisation Name"
PayedinYear as "Payed in Year"
)
filters
(
PayedinYear
"Not in 2007" : !PayedinYear.contains("2007")
)
}















The PayedinYear filter displays the organisations who have payed in year 2007. I want to filter the organisations who did not pay yet is this year.

Please can you tell me how to do this?

Cheers, Frans