Load data from Google Sheets

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.

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.