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

  • Profile Image
    jsanussi
    Asked 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
    Mike_G
    Answered 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
    jsanussi
    Answered on May 19, 2017 at 09:43 AM
    Hello,
    Thank you very much for your support! Very nice of you - however, I have
    already figured it out!
    Have a great weekend (:
    Jovana
    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


    ...