Hidden field in a Google Form

by

I assume you’re only interested in ways to programmatically assign a unique ID before the user fills out your form.

No, Google Forms still has no direct support for hidden fields such as you have in HTML Forms. Your only option appears to be the custom styling route, which you’re already aware of.

Here are two promising ideas that just don’t work…

  1. Pre-fill a deleted question. If you delete a question from a form, it remains in the response spread sheet – unfortunately Forms suppresses values for deleted questions that are presented in pre-filled URLs, otherwise you’d be able to trick your Unique ID into the submission that way. (I thought this might be a clever work-around, but was disappointed that it didn’t work.)

  2. Pre-fill a question on a skipped page1. You can set up a question on a second page that the live form will skip over, and you can also generate a pre-filled URL for that question. So far, so good – but if the user doesn’t actually navigate to that page, the pre-filled response is not submitted.

1Thanks to @AdamL, who posited this idea during a previous discussion on this topic in the old forum.

More Related Contents:

  1. How can I be getting multiple unwanted event blocks from the same onFormSubmit Trigger?
  2. Is it possible to ‘prefill’ a google form using data from a google spreadsheet?
  3. Single Google Form for multiple Sheets [duplicate]
  4. Dynamic selection options in Google Apps Script for forms
  5. How to prefill Google form checkboxes?
  6. Refresh data retrieved by a custom function in Google Sheet
  7. How do you create a “reverse pivot” in Google Sheets?
  8. Create Google Calendar Events from Spreadsheet but prevent duplicates
  9. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  10. Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?
  11. Retrieving Google Sheets cell border style programmatically
  12. Determining the last row in a single column
  13. Cannot find method getRange(number,number)?
  14. How do I add formulas to Google Sheets using Google Apps Script?
  15. Deleting rows in google sheets using Google Apps Script
  16. Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank
  17. Adding Buttons To Google Sheets and Set value to Cells on clicking
  18. Custom function throws a “You do not have the permission required to setValue” error
  19. Script to convert .XLSX to Google Sheet and move converted file
  20. Apply multiple font colors to the text in a single Google Sheets cell
  21. How to evaluate a spreadsheet formula within a custom function?
  22. Google Sheet use Importxml error could not fetch url [duplicate]
  23. On Edit doesnt work if cell auto updates – Need a workaround Google Sheets
  24. Iterate over range, append string to each
  25. Can the google spreadsheet ‘query’ function be used in google apps script?
  26. How to pause App Scripts until spreadsheet finishes calculation
  27. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  28. Can the google spreadsheet ‘query’ function be used in google apps script?
  29. google script openById : You do not have permission to perform that action
  30. Redirect after submitting Google Form

Leave a Comment