How to create multiple spreadsheet entries for multiple registrants?

  • milesofmusiccamp
    Asked on January 17, 2019 at 3:08 PM

    Hi

    I'm hoping to create stream lined registration form for my summer camp business. When families register, I'd like for them to be able to fill out information for each family member conditionally in a form and have it populate as a separate entry in the spreadsheet. How can I make this possible? I've tried conditionally hiding/showing form elements but I need that information to populate on a separate row on the spreadsheet. I've seen where you can redirect them to a new form after submission but can't seem to figure out how to do that. Is there an easy "add another person" section?

    Thanks,

    Lauren

  • jherwin
    Replied on January 17, 2019 at 4:34 PM

    Unfortunately, when the user submits your form it will only store in one spreadsheet. However, if you want for each field/entry to place in a different spreadsheet then the redirect option (as you said) is the solution for it.

    Please follow this guide to achieve that: Redirecting Users to a Different Page.

    Each form will have a different spreadsheet integration.

    Guide: How to Integrate Forms with Google Sheets.