Survey Reminder

HCL Domino Domino Forum
1

I have a form on which the “sender” selects the people to complete a Survey. The form allow them to select the people’s names and then they click on a “Send Survery” button. However, this form doesn’t get saved, it is simply one used to select the people to send to.

Then the questions for the survey is fetched from a profile document and a on the fly document is created with the questions and sent to the people selected on the first form.

The “receiver” receives the Survey in his inbox. Then submits it, and it is mailed into the survey database. It also changes the subject line of the original Survey emial, stating that the Survey was completed (to avoid them sending it more than once), and the Send button is hidden, by setting a field HideButton to 1.

The “sender” is notified via an agent that a new Survey has been completed (every time new mail has arrived, as this is a mail in database).

Ok. So this all works WONDERFULLY. Now it was requeted, that the “receiver” be sent a reminder, if they haven’t completed the survey in 7 working days. But this is impossible right!?!? How will the db know, that it was sent to all these people and who exactly didn’t send theirs back. There is no way I can figure out on how to make this possible.

Any ideas? Or should this be a case of, “sorry, not possible”?

2

Subject: Survey Reminder

You can’t do anything about the past, but if you save the recipients document from now on, you can “tick off” the respondents on any new surveys sent out as they are returned to the survey db.

3

Subject: RE: Survey Reminder

Hi Stan,

Thank you for the reply. I’ve taken out the SaveOption field on the survey form. And I have put in the call doc.Save(true, false) in the script. but now it saves the blank survey doc (sent out) and the filled in one comes back. so I sit with 2 documents? how would I link them up?

4

Subject: RE: Survey Reminder

There must be a unique key in there somewhere – a date, a subject, a tracking number or something. There would be no way to make sense of the survey results otherwise. That key should allow you to do a lookup to the recipients document (which should be different enough from the sent/returned surveys to allow them to be held in a separate view).

5

Subject: RE: Survey Reminder

Thanks again Stan. I’ll play around with the whole idea and see what would be best and how I can get it to work. Thanks again. I will probably create a new unique field that will store the unique key when sent and scan the surveys for the key, if not found, then they haven’t submitted, if found, then ignore.

Thanks