AboutPaski K. Paskaradevan Expertise I have 3 + years in Lotus Notes application development. I am a CLP R5 Application Development. I can answer any question pertaining to application development.
Experience R5 CLP. In addition, I have a bachelors degree in Engineering and a MBA.
Question Hi Paski.
I need to send an e-mail survey which the recipient needs to complete and send back. I would like to add a button at the end of the survey for the recipient to "SUBMIT" the survey. I would need it to basically be a Reply with the edited e-mail, which when I receive it, it will be the completed form, not an attachment or DocLink.
I would appreciate any assistance you can give me.
Thanks in advance,
Bruno
Answer Hi,
First of all, you cannot do this from your mail box. Even if you do, you will not be able to analyze the results unless you want this to be a simple yes/no answer. If that is the case, just create a button with @mailsend formula sending mail back to you.
If this is a survey with multiple questions, this need to be a stand alone application.
Create a database on a server. Create a mail in document for that database (your notes admin need to create this for you). This database will then be assigned a mail in name and any mail sent to that mail in name will land in this database.
Then you develop your survey form. That form will have the submit button which will send the form back to the mail in database. You can either use a sendto field to specify the recipients OR you can use a separate form where you will specify the recipients and you will send your survey form to each of the recipient in the list one at a time using the Send method. While doing the send, store the form using the true statement in the send method. The form will be sent with the form stored and it will have the Submit button.
When the form comes back to your survey database, it will have stored form. If your audience is a huge number, the database will get huge in size in no time. So, in that case, you will write an agent which will unstore the form. This agent can run either scheduled or after mail arrives.
Now you have all the completed surveys in your database and you can now construct views or export to an excel file for analysis.
Finally, all the codes above should be written in lotus script.
