How to create a view containing records that does not exist in another view?

5 pts.
Tags:
Lotus Notes
Lotus Notes View
I have a survey database and I need to create a "NoRecordsView" comparing View1 (respondent) and View2 (expected respondent). My "NoRecordsView" shall contains those who did not respond. View1 and View2 contains different forms with one common field. Thanks.

Software/Hardware used:
Lotus notes

Answer Wiki

Thanks. We'll let you know when a new response is added.

Views work with fields, and therefore a view won’t work if you haven’t marked a field on the document of the ‘expected respondent’ form that no answer was received. You can solve that in an agent (or an action): simply make the code loop through the View2, and lookup the respondent in View1, if it doesn’t exist then you mark the document with ‘NoResponse’, and make your new view select on that field.

If you do not want to fill another field then you can make an agent or an action that places a document without respondent in a folder. The logic of such an agent or action is pretty much the same: loop through View2 and lookup the respondent in View1; if not available then place the document in a folder. You can make a shared folder that appears in the ouline, as long as you know that no one else can place or remove documents from that folder.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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
  • shivasanjay
    You need to have one additional field in both the formswhich tracks the value for no response, and then you can filter out those documents.In the view selection formula you need to apply this formula for example:select  (form="a" | form="b") & status="no response". Check if I understood your question correctly.
    2,125 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following