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 API integration (Fusion Tables)

    Asked by docentdev on February 10, 2014 at 03:30 PM

    Hi,

     

    We are building functionality to get a user's location and persist it in a Google Fusion Table. On clicking submit, the page should write to the table (via Google API) and refresh, while the map on the page now shows the user's location.

    One way to do this is to have the JotForm write to a google spreadsheet, then periodically sync to the fusion table using a script. This seems to be a rather messy solution. Besides, the script will not have finished writing to the table when the map refreshes in the page.

    A better way to do this is to simply call the fusion table API, which looks like this (we will need to authenticate with an oauth token, which i assume is how the spreadsheet integration works in jotform now)

    https://www.googleapis.com/fusiontables/v1/query?sql= INSERT INTO <table_id> <column_name1> , <column_name2>} VALUES <value1> , <value2>

    Question: Is there a way I can call a google API with form data?

     

    JotForm table form data sql
  • Profile Image
    JotForm Support

    Answered by Mike_T on February 10, 2014 at 04:09 PM

    Thank you for contacting us.

    We do not have any integration with the Google Fusion service, so that you will need a custom script for this task. For example, you can instantly receive form submission data with a Webhook, then process it using your script.

    If you need any further assistance, please let us know.

  • Profile Image

    Answered by ashay245 on November 23, 2015 at 10:50 PM

    is there an easy way for people that don't code to do this. 

  • Profile Image
    JotForm Support

    Answered by Charlie on November 24, 2015 at 02:52 AM

    @ashay245

    I see you already have an opened thread with the same question on this thread link: http://www.jotform.com/answers/710656. My colleague is already assigned on it and will answer you directly there, please refer to that link.

    Thank you.