I am designing a db to use for course evaluations (surveys). After completing a course, employees in my company should ideally receive an email with a link to a web form (data access page?), prefilled with the right information about the course (e.g. date, place, course_id, etc). The form includes a set of questions, toggle boxes and free text fields for the participant to fill in, and the form should be available to all course participants (which are transferred to the db in advance). There are many different courses being held at the same time - different courses but using the same evaluation form.
I have a feeling I can put the db in a network disk that all employees have access to, and use data access pages (forms?) that are viewed by the participant by a web browser. But how can I send a (unique?) link to each participant by email, ensuring that they can only evaluate the course they have attended, and protect (hide) the information that other participants have entered ?
Hints and general guidelines are deeply appreciated :-)
Start Free Trial
