Load data from Google Sheets

  • Profile Image
    guarinmla
    Asked on February 17, 2021 at 10:31 AM

    Hi,


    I have created a form here - https://www.jotform.com/build/210472614203443#preview.


    Is there a way to trigger an error and disable the "Place Order Request" button if the field "OR Number" has the same value with a cell in the Google Sheet?


    I have already integrated this form in Google Sheet such that "OR Number" is also present in the Google Sheet as a column.


  • Profile Image
    Bojan_J
    Answered on February 17, 2021 at 12:26 PM

    Greetings.

    Unfortunately, it is not possible to load data from Google Sheets, you can only save data there. An alternative solution would be to use Spreadsheet to form widget, that allows you to upload an existing spreadsheet, and load data from that.

    However, this solution is not dynamic, and you will need to manually upload a new Sheet every time data in it update.

    Let us know if you have any additional questions.