Creating User Resitrictions with the use of a database

[ChelsieMarie]

I have been assigned to create a fillable class evaluation form. We have
around 2000 students, and are expecting around 25,000 surveys returned.
Anyone can create a survey and then dump the results into a database. But, I
need to make sure that ONLY the students enrolled in the class may take the
survey. Additionally, they may only take the survey ONCE per class.

Where should I even begin?


I chose to try InfoPath 2003 as my first attempt. I would like to know if
this request is even POSSIBLE to perform in InfoPath.

 

[alex94040]

This is definitely possible in InfoPath. However, to make that happen,
you need to make sure that you have access to several things the list
of students. This may be somewhere in a SharePoint list, or a database.


Here's how you'd proceed:
1) Create an InfoPath form view that asks the student for their
studentID + some other identifiable information (i.e. date of birth),
so that you can check it against their records.
2) Make a secondary data connection request to see if provided
credentials match what you have in your records. Also check that this
student didn't submit the survey yet.
3) Take the student to the survey view. You also need to make sure that
this view is not showing up on the View menu by default (you can do
this by setting appropriate view properties).
4) When the student is done, have them submit the form to a SharePoint
form library or another central location.

Hope this helps!

Thanks,
Alex Weinstein [MSFT]