Wants to create view selection formula for documents

A view selection formula can only select documents for inclusion in a view based on the data in that document, or based on whether its parent is also in the same view. There's no way to select only documents that have no responses (or that have responses, or whose responses contain particular field values).

What you can do, however, is write a server agent that will scan for documents that meet your criteria and set a field value in those documents. The selection formula can use this field to decide whether to include them in the view. Or the agent can find these documents and put them into a folder. (Use the access properties of the folder to prevent users from manually adding and removing documents in the folder.)

I wrote an article for The View that explains how to create fancy views like this. If you're not a subscriber, you can still download the sample database.

Do you have comments on this Ask the Expert question and response? Let us know.