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?
@dhaval wrote:I want to allow the submit button to work only when the Status field is ""
Please include in the valid_if of Status field [_THIS]=""
@dhaval wrote:an error should pop up informing the user "Please add the correct items".
In the valid_if error message of the [Status] field, you could include an error message "Please add the correct items".
"
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |