Is there a way we can have someone fill out a form, and then do another form and it combines on one xcell spread sheet in order? (Example attached.)

  • AutoManiacs
    Asked on February 13, 2017 at 10:22 PM

    Example 1st form

    First Name ?

    Last Name ?

    Pickup location?

     

    Then the second form

    drop off location?

    Time?

    Were you satisfied?

     

    So on the google spread sheet it will read the following ounce complete.....

    First Name   - Last Name - Pickup Location - Drop Off Location - Time - Were you satisfied?

    John              Smith            Atlanta Blue      Atlanta Red            5:45     5 Stars        

        

    Is this possible?

  • Chriistian Jotform Support
    Replied on February 14, 2017 at 1:55 AM

    Unfortunately, this is not possible at the moment to have two forms to update one Google Spreadsheet. Alternatively, you can use the ImportRange but you need to manually update a field on spreadsheet as this is not automatically update the sheet when receiving submission.

    You may also try to use the Combine Submission App from JotForm where you can combine form submissions from two forms into one Report.

    To achieve this, first thing to do is to export your data, please see this guide: How to Download Form Submissions as Excel/CSV/PDF?

    Then, upload the exported file using the Import App.

     

    Let us know if you need further assistance.
    Regards

  • AutoManiacs
    Replied on February 14, 2017 at 2:45 AM
    Great thanks, so you have a Tutorial on this?
    ...
  • Chriistian Jotform Support
    Replied on February 14, 2017 at 4:26 AM

    Please follow the instructions below to achieve this:

    1. Use the Combine Submission App to combine existing submissions data, please see this link to get the app: http://apps.jotform.com/app/combine_submissions. 

    Is there a way we can have someone fill out a form, and then do another form and it combines on one xcell spread sheet in order? (Example attached Screenshot 30

     

    2.The CSV file that was created and contains the combined submissions data can be imported to an existing jotform using the Import Data App. Please see this link to get this app: https://apps.jotform.com/app/import_data

    Is there a way we can have someone fill out a form, and then do another form and it combines on one xcell spread sheet in order? (Example attached Screenshot 41

     

    3. Please import the submission data to the form that can accommodate the combined submissions. The form should contain the fields that were in the combined forms data.

    4. Lastly, integrate your current form that contains the current combined submissions data to google. Here's  the guide on How to Integrate Form with Google Spreadsheet.

    Let us know if you need further assistance.

    Regards