Hi
I’m working on a events db and the client wants to be able to produce a list of non respondees to an invite by comparing the ‘Sent Invite’ view with the ‘Responded invite’ view so she has a view that is populated with users that are yet to respond, is there a way to compare these two views and create a list of outstanding reponses
Any help is appreciated
Thank you.
Subject: RE: Comparing two views
It’s certainly possible to create a view such as you describe, but the details would depend on how you store the data. If you describe your application in more detail, someone may be able to give you a better answer. Do you store a separate document for each person invited to each event, or do you just list all the names of invitees in a single ‘event’ document? Do you create a separate document for each invitee/event to indicate that person’s response (and if so, why!?!). How many invitees might there be to a single event? What document types exist in the application?
Wing Mar’s suggestion that you create a folder and put documents into it is appropriate for some situations, but he’s wrong when he says this can’t be automated.
However, a more likely scenario is that you would just update the document about the person’s invitation, to contain information about their response also. Then it’s very easy to create a view of those who didn’t respond.
So far, I don’t know any reason you can’t put all the information about an event into a single document, with multivalued fields listing the invitees and their responses.
Subject: Comparing two views
I guess you could create a LotusScript agent to run over the documents in the Sent Invite view, then lookup by name(?) in the Responded Invite view to see if a response was received. If you want the results to appear in a view format, you could create a folder called “Outstanding Responses” where you could copy the document to if a response was not found. But this would need to be a manual process.
An automated approach might involve creating an agent to be triggered when new mail arrives to find the document in the Sent Invite view, by name(?) and mark it with some flag that a response was received. The Outstanding Response view would just show any invites without this flag.
Since I don’t know how your event db works (i.e. is this a mail-in db?), these approaches might not be feasible, but I hope it helps point you in the right direction.