Prevent Duplicate SKU's or Order Numbers

Is anyone aware of the best practice for preventing duplicate entries?

We have an inventory app, to prevent duplicate SKU codes we have a joined list column to compile all the existing SKU codes in a sheet.
Then we have a warning hint element which appears on the entry form if a duplicate is detected. Technically a duplicate can be entered but the user is notified.

1 Like