- jsanussiAsked on May 19, 2017 at 06:40 AMI 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!
- JotForm SupportMike_GAnswered 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.
- jsanussiAnswered on May 19, 2017 at 09:43 AMHello,
Thank you very much for your support! Very nice of you - however, I have
already figured it out!
Have a great weekend (:
Ihr Fuhrpark 4.0 | Avrios International AG
T +41 79 453 61 01
Besuchen Sie uns auf @getavrios