Ask the Expert

Wants to create view selection formula for documents

Can you help a newbie? I am looking to create a view of documents that do not have Ref documents created for them. I wish to omit any document that has Ref documents. Can you help, either with code or else by directing me where to find the solution?
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.

This was first published in August 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: