Is there any way to retrieve data from Google Spreadsheet to confirm inputted data - to populate or confirm input?

  • Profile Image
    Renata Lavach
    Asked on May 01, 2015 at 05:22 PM
    In 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?
  • Profile Image
    Ben
    Answered on May 01, 2015 at 05:37 PM

    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?.