Where does a mulitpage form save data on hitting next

  • Profile Image
    sjreynolds
    Asked on December 03, 2015 at 07:30 AM

    Hi, 

     

    I have a mulitpage form using page breaks

     

    I need that form to save data into a google spreadsheet each time the next button is hit so that we can monitor where clients are leaving the process.

     

    The form ive hosted here http://salons.rockpamperscissors.co.uk/test is supposed to save data into a google sheet, but only does so when Submit it hit on the final page, rather than when next is hit on each of the other pages

     

    I know i could have several forms, but the data would then be spread out over numerous google sheets.

     

    HALP

  • Profile Image
    Chriistian
    Answered on December 03, 2015 at 09:21 AM

    Hi,

     

    Unfortunately, that is how the Google Spreadsheet integration works. It only adds the data/response to the spreadsheet once the user has submitted the form. The workaround would be to create a different forms per page but as you mentioned the data will be submitted to a different/separate spreadsheet. 

     

    Do let us know if you need further assistance.
    Regards.