Hello,

 

I've done several searches on this but have not found an answer.

 

I currently have a database into which the public can add records.  I want a public view where only certain fields will be searchable and viewable, and I know how to set that up.  However, when a user does a search I want only the records with a certain value set to "yes" to be shown to those users.  Let me explain why.

 

The database will allow users to add their own entries, but I want to verify each entry before it is publicly viewable.  This is to prevent fake data from being added.  So I have a field named something like DataHasBeenVerified.  This value will be set to "no" by default, and users won't be able to change it.  Only I can change it, and I'll change it to "yes" after the data the user added has been verified.

 

So when these users do a view or a search I do not want them to see records where the DataHasBeenVerified value is set to "no" since that could be fake data.  I only want them to be able to view verified data.  Is there a way this can be done?

 

My only other option that I can see is to create two databases, one for the data users enter and one for data that has been verified.  I'd then have to copy data from the first database into the second, but that's very tedious.  The database could potentially hold thousands of records, so I would like to minimze the amount of time I spend manipulating the data.

 

Thank you for any suggestions you have.  I've looked at other online database products and Zoho always outshines them all.