How to create a view containing records that does not exist in another 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
Software/Hardware used:
Lotus notes
ASKED:
January 29, 2013 8:18 AM
UPDATED:
January 29, 2013 12:41 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
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.