What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    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.)

    Asked by AutoManiacs 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?

  • Profile Image
    JotForm Support

    Answered by Chriistian on February 14, 2017 at 01: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

  • Profile Image

    Answered by AutoManiacs on February 14, 2017 at 02:45 AM
    Great thanks, so you have a Tutorial on this?
    ...
  • Profile Image
    JotForm Support

    Answered by Chriistian on February 14, 2017 at 04: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

     

    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

     

    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