Hi, I need my app to require confirmation for certain type of barcode text

[ezmedicom1234]

If I want my app to notify users or send confirmation messages when barcode texts are not fit for our company's structure, what should I do?

For example, correct data should appear like this "I2310A000000".

So if scanned data does not start with "I", and does not followed by "YYMM" and "A", also doesn't ends with 6 digit number, I want my app to make users to check their scanned data.

Can I implement such feature?

[Suvrutt_Gurjar]

Could you mention if the users will be submitting the barcodes using AppSheet's scannable column and you wish to invalidate the incorrect barcodes not matching the criteria you mentioned while scanning through AppSheet app?

[ezmedicom1234]

Yes, they will submit barcode through AppSheet's scannable column(I hope this screenshot matches my answer?), and I don't want to invalidate the incorrect barcodes, I just want to send warning to users for scanning incorrect barcodes.

Also, very sorry but what does "invalidate" entail? Does that mean incorrect barcodes will not be appear on the app and database?

[Suvrutt_Gurjar · Accepted solution]

---

@ezmedicom1234 wrote:

and I don't want to invalidate the incorrect barcodes, I just want to send warning to users for scanning incorrect barcodes.

---

You may want to elaborate what you mean by sending warning- how to send warning email, sms ?

---

@ezmedicom1234 wrote:

Also, very sorry but what does "invalidate" entail? Does that mean incorrect barcodes will not be appear on the app and database?

---

This is a normal practice. Invalidate means the invalid error message will be displayed below the barcode field something like below and the user will not be able to save the form with invalid barcode. The app creator can include the required valid_if expression in the Valid_if  constraint setting of the column settings. The error message will not display if the entered or scanned barcode matches the valid_if criteria mentioned in the column settings. The user can then save the form.

Please take a look at these help articles

Use column constraints - AppSheet Help

Check form input validity (Valid_If) - AppSheet Help

[ezmedicom1234]

Thank you! That was what I wanted!

[Suvrutt_Gurjar]

You are welcome. Please let us know if you have been able to create a suitable valid_if constraint expression. Or the community could help/guide you with the same.