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

    Google Spreadsheet Integration: How to make sure the data in Sheet 1 will be passed without interruption in Sheet 2 after a successful form submission

    Asked by jsanussi on May 19, 2017 at 06:40 AM
    I have a situation with the integration
    of responses with google spreadsheets. Not sure if it is possible to share
    the screen with you?
    In words, I have 3 tabs on google sheets:
    1. responses from jotform
    2. a mapping of sheet 1 with calculations (connected with sheet 1)
    3. summary (connected with sheet 2)
    Problem: when a new response data is added in sheet 1, the formula in sheet
    2 is completely wiped out. and therefore the data does not transfer. And
    therefore, the data in sheet 2 does not appear in the summary sheet 3.
    If that makes sense...
    If you have a solution, please let me know! I have been spending hours on
    this - thank you very much in advance!
  • Profile Image
    JotForm Support

    Answered by Mike_G on May 19, 2017 at 07:05 AM

    First, I just would like to inform you that you can share a screenshot in the support forum following the instruction in this guide: How-to-include-screenshot-image-in-the-support-forum

    With regards to your concern, I understand that you are trying to have the data in Sheet 1 appear in Sheet 2. However, the issue you are having is that when a new submission comes in, the formula in sheet 2 disappears.

    I see that you are working with this form (http://www.jotformeu.com/form/71291751254354). We will be glad to help you with your concern. Would it be possible for your to share with us the link to your spreadsheet? We would also like to make test submissions directly to your form if you will allow us.

    We will wait for your response. 

    Thank you.

  • Profile Image

    Answered by jsanussi on May 19, 2017 at 09:43 AM
    Thank you very much for your support! Very nice of you - however, I have
    already figured it out!
    Have a great weekend (:
    Jovana Sanussi
    Ihr Fuhrpark 4.0 | Avrios International AG
    T +41 79 453 61 01
    W avrios.com
    B blog.avrios.com
    Besuchen Sie uns auf @getavrios