3

I need an anonymous form (no names, emails etc) that shows unique ID so that if a person decided to reveal that ID to me I will be able to find his/her answers in the spreadsheet. The ID can show on the form or in the "Thank you" massage after submitting. Like mentioned before - emailing is not an option. I know of similar posts but for this particular problem I haven't found an answer.

1

Interacting with Google Forms before or during submission is not possible.

Alternative

You could use the Google Apps Script HTML Service for designing the "Thank you" message page presented after submitting the form (that will carry the ID followed by an explicit message for the submitters to copy down this ID) and create an app to handle your issue.
You could start though by creating a unique ID for your submissions.

0

Google Forms automatically assigns a unique id to each submitted response once the response is submitted. This id is part of the edit response URL which is displayed on the response submission confirmation page.

Another alternative is to add an optional question to allow respondent to write their own tracking code. You could suggest that write something like a color and a dessert name, or something like that.

To enable the option to allow respondent to edit their answers, from Send your form to respondents

You can choose whether someone can edit a response they’ve already submitted.

  1. Open a form in Google Forms.
  2. At the top right, click Settings Settings.
  3. Check the box next to "Edit after submit."
  4. Click SAVE.
0

You cannot give your user a unique id on the thank you page, but you can give a unique id in SMS or email. It's very easy to give a unique id to the form submitter by using Google's onFormSubmit function:

function onFormSubmit(e)
{
  var sheet = SpreadsheetApp.getActiveSheet();
  var row =  SpreadsheetApp.getActiveSheet().getLastRow();
  var unique_id=F+row;//output F1, F2...

  sheet.getRange(row,21).getCell(1,1).setValue(unique_id);
  //save in any coloum

  var str1 = "SMS Server api link sender id key and msgs..";
  var response1 = UrlFetchApp.fetch(str1); Logger.log(response1.getContentText());
}
  • ReferenceError: "F" is not defined. (line 5, file "Code") – Fergus Oct 29 '17 at 22:03

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.