I would like to prevent duplicate entries of uniquely barcoded items. I would like the app to check to see if the barcode exists in the system before adding a record. Is there a way to do it?
You can if you create a custom form and use a relation to check for an existing barcode. Only enable the submit button if the relation is empty.
I’m just dropping this here so I have something to refer people to when they ask.
This is a simple concept app (copyable), that demonstrates the following techniques:
Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide)
Preventing duplicate new entries using User Specific Columns and Relations
Enforcing mandatory input items
The use of visibility conditions and user specific booleans to control user flow
There is nothing particula…
3 Likes