Prevent Duplicate SKU's or Order Numbers

[Curtis]

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

Example:
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.

[nathanaelb]

How do I create a custom form?

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…