Local Database where a form is sent to several notes users - how to get data reports from the email data
Posted on 2006-04-18
I am quite new to using domino designer to create a new database. Here is a quick plan of what I want to do: -
Due to company restrictions I cannot create a server copy of a form. Therefore, I have created a local database that will be distributed to the department (roughly 75 users). The database has a page, that directs the user to a form to fill in. The form has around 10 fields that the user selects from a list or enters text into the fields. The form has a submit button that sends a doclink of the form to 3 email addresses. I am testing this at the moment and it works OK, but what is puzzling me is how to get at the data when it has been received. Notes redirects the notes to a folder, based upon the subject of the email, hence all emails are automatically redirected to this folder upon receiving them. I have created a view within the database that shows all documents. The problem I have is once I deploy the database, I will get emails from everyone that goes to this one folder in notes. This is OK, but I need to know how I can build a view within notes to 'show' all of these documents. I am struggling to figure out how I can do this so any help with reference to @commands I can use in a view to get at the 'field' data for each document would be really helpful to me.
Thanks for any help you can provide. I don't know the points system involved in this as this is my first posting. It's difficult for me to understand hence 250 points. Thanks if you can help or point me in the right direction. If there is a better solution to the one I am trying to develop, please let me know. Thanks!