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.
Is there any way to retrieve data from Google Spreadsheet to confirm inputted data - to populate or confirm input?Asked by Renata Lavach on May 01, 2015 at 05:22 PMIn integration, I see that you can have the information typed into the form them put into a Google Sheet. Can you make the form draw information from a Google Sheet instead? That way it either populates the field, or at least verifies that the info input is correct?Google Spreadsheet retrieve data AJAX
Unfortunately this is not possible Renata.
The reason is that forms are used to collect data, not to show data. As such you will always be able to send your data to Google SpreadSheet and many other alternatives, but you would not be able to retrieve the data or validate the data in the spreadsheet.
You could come up with your own code that can do that for you by creating a widget that would do this for you - which you can see more about on your other thread I have just replied to here: Can we create our own widgets?.