I am building a Google form to manage summer camp subscriptions. Each request must enclose parents and child data. The problem is, if a family wants to subscribe more than one child, the process must start from scratch and all parents data must be entered again. Could there be a way to reload (also with a Google Apps script) to form with partially prefilled data based on the previously sent data? Such as "do you want to send another request" question right before the submit, if yes, reload the form with pre-filled data... Keep in mind that the response sheet must contain one row per each child.... Any idea?

  • I guess summer camp subscriptions have finished but please have a look to a simple form I prepared. You get results using a single query. If it suits your needs I will turn it to an answer and you can use it for your next subscriptions. – marikamitsos May 13 '19 at 1:21
  • Thanks for adding your thoughts! Is it possible to view the logic behind the form? – Riccardo May 13 '19 at 5:51
  • Each parent fills just 1 form, his/her details once plus one section for each child. This way you avoid starting the process from scratch having all parents data entered again or prefilled data. One form for all their children. – marikamitsos May 14 '19 at 7:40
  • Did you ever try out the form. Does it fulfill your needs? – marikamitsos Jul 8 '19 at 16:37

You could add a regular question to ask for sending another request but the pre-filled form will not be shown immediately if you use a "regular" Google Apps Script.

A "regular" Google Apps Script will use on form submit event to create the pre-filled URL. It could post the URL somewhere or send it through email.

You could implement a "hack" that capture the HTTP POST request made by the Google Form respondent view but this could be very convoluted. Maybe as a challenge for Google Apps Script / Google Forms fans could be interesting. I did that few years ago for a project but the use case completely different, maybe it now works with current version of Google Forms and I don't think that will be able to make a simplified version soon.

An intermediate solution could be to embed the form on a web application that checkouts for new submissions from the active user.

| improve this answer | |

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.