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.
Google API integration (Fusion Tables)Asked by docentdev on February 10, 2014 at 03:30 PM
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?
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.
is there an easy way for people that don't code to do this.
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.