Allow user to submit appsheet form only when certain conditions are matched

I have created an AppSheet form to record sales orders. When the user inputs Order Id, he'd see a list of the items sold under that Order ID. Apart from prefilled values, I have created two fields - one is product_scan (this allows a user to scan the product's barcode) and Status (a formula field that would match the items' barcode scanned by a user and the list of prefilled items sold under the order ID. It would return the status "โœ…" if items match and returns "invalid items" if a user has scanned incorrect items. 

Now, I want to allow the submit button to work only when the Status field is "โœ…". If the Status field is "Incorrect Items", and a user clicks on submit button, an error should pop up informing the user "Please add the correct items". 

Can anyone suggest a workaround for this? 




0 1 53
1 REPLY 1
Top Labels in this Space