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

    the integration with google sheets is great,does it need IP address?

    Asked by ambitionone on November 30, 2016 at 03:14 PM

    Hi,

     

    I want to send people a link to their data, using the google sheets integration.

    On my laptop it works, and i can change data in either jotform or google sheets, but on my phone it doesnt work.

    Is it IP address related? Is there another way to do this?

    Page URL:
    https://form.jotformeu.com/63345468896372

    JotForm and OR another
  • Profile Image
    JotForm Support

    Answered by Jim_R on November 30, 2016 at 07:46 PM

    Hello, I just wanted to point out a few things about your question so you have a better and clearer idea on how to use the Google Sheet Integration:

    1. I want to send people a link to their data, using the google sheets integration.

    On a normal use case, form owners wouldn't want to do (or shouldn't do) this. Why? Because everyone's data is on the sheet. If 100 unique people submitted the form, then ALL their data will be shared to anyone whom you shared the link to.

    If the Submission Data is safe to be shared (meaning no sensitive and Personally identifiable information were shared), I still wouldn't recommend you share the sheet with them with the pretense that some random user might accidentally edit/delete it entirely.

    This integration was created for the sole purpose of letting the owner (you) have the submission data exported elsewhere. Nonetheless, if you really aim to share the data to everyone, as an alternative, why not try:

    HTML Table Listing: How-to-Create-an-HTML-Table-Listing-Report

    Grid Listing: How-to-Create-a-Grid-Listing-Report 

    2. On my laptop it works, and i can change data in either jotform or google sheets, but on my phone it doesnt work.

    The sheet itself, once integrated, should never be modified, especially the content of the rows along with the table/column headers as there's a chance that it will break the integration.

    3. Is it IP address related? Is there another way to do this?

    No it's not IP address related. The browser you used on your phone probably can't render Google Sheets as opposed to how it normally works on desktop/laptop browsers.