Hi there, is it possible to use a web API ser...

(Joe Davies) #1

Hi there, is it possible to use a web API service with AppSheet to check a condition on a remote MS SQLServer database before a record is submitted to the database?

(Aleksi Alkio) #2

Are you trying to read the condition while you are saving the record or more like generally?

(Joe Davies) #3

Thank you for replying… I want to check that the value being entered exists on the MSSQL Database in order to validate the entry before it gets submitted as a new record. If the value does not exist then the user needs to be prevented from submitting the record. Thanks!