2

We use google forms to send out tests to our students and must find a solution for the (as per title) following situation:

The scenario limitations:
NOT all our students can have a google account. We have to have the form public. We already have a spreadsheet (STU-INFO) with all our students' information.

Workflow:


A) Taking the test.
Using our existing STU-INFO we send an email to the students. The student receives an email.

Dear STUDENT,
There is a new test for you: CLICK HERE FOR "YOUR NEW TEST"
bla, bla, bla
Good luck

The student goes to the form and submits the test.


B) We would like the following:
When the student submits the form, the response gets "on-the-fly" auto checked whether the email submitted for the RESPONSES spreadsheet, matches one of the emails that already exist in our STU-INFO spreadsheet.
If the email matches, the respond gets recorded.
Otherwise the response should be discarded without even being recorded.
Ideally a pop-up message should be shown to the submitter. "Success!!!" OR "Sorry you are not registered for the test "YOUR NEW TEST" . Your answers are disregarded".
Worst case scenario? Instead of the pop-up {when the email does not match) an email is auto sent to the submitter with the test ID auto filled. "Sorry you are not registered for this test ID "YOUR NEW TEST". Your answers are disregarded."

I have little experience with scripts and the script editor in Google Sheets. As a final note, other add-ons (formmule, flubaroo and AutoCrat) also use the same RESPONSES Google Spreadsheet.


EDIT:
After reading the comment and answer left respectively by @Canadian Luke and @Ruben I feel I need to explain further why we do need such a function.

First of all we do give not one but two "warning" messages when students try to fill in their email addresses at the very beginning of the form.
The first one in the form of a hint: "ONLY REGISTERED students are allowed to take the test. ALL duplicate and/or unregistered responses will be discarded."
The second one comes as a custom message under Data Validation:
Data Validation--> Text--> Email address--> "Please make sure you type your registered email correctly so as to receive your grade"
About Ruben's answer. We have already tried and currently use pre-filled URL forms. The issue though is that (as explained in the beginning) the forms have to be public. Unregistered students, trying to be "funny" fill out the forms using pseudo-addresses anyway.

  • 2
    Just a suggestion, people get angry if they spend the time filling out a form, only to find out it's all for nothing by not being signed in. You'll likely have some angry students if there's a typo or the like. Please plan for that too – Canadian Luke Feb 27 '16 at 15:28
  • Please read my edit for further reasoning. – marikamitsos Feb 27 '16 at 23:19
  • The new edit section actually include, not only one but several questions this makes the question too broad. Instead of including several "food for thought" items pick one or post each one on separate questions. – Rubén Feb 27 '16 at 23:53
  • No problem Ruben. Will do right away. Thank you for the suggestion. – marikamitsos Feb 28 '16 at 0:37
4

Short answer

Once the response is submitted it's stored and there isn't a way to avoid this. By the other side, it's not possible to delete individual responses on the responses container bounded to the Google Form.

Explanation

At this time Google Forms responses are stored in the Google form file and optionally could be set to automatically send them to a Google spreadsheet by using a built-in feature.

It's worth to say that Google Forms also could be used as a script container and that it have the event on form submit that could be used to do some things with the submitted responses like to discriminate which responses should be sent to a Google spreadsheet, but not for delete individual responses from the responses container bounded to the Google form file.

Remarks

As was already mentioned in a comment to the question by Canadian Luke, relying on students typing their ID in a Google Form and automatically discriminating their responses based on it could cause "problems". One way to minimize this is to send to each student the URL to a pre-filled Google Form with their ID already filled up.

References

  • Please read my edit for further reasoning. – marikamitsos Feb 27 '16 at 23:19
  • @marikamitsos Just for the record, I read your edits to this question and to the one derived from this one. – Rubén Feb 28 '16 at 14:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.