Solution to Prevent Duplicate Entry

[Darren_Murphy]

I’m not sure I understand, but… a question. Are you using a custom form or a native Glide form?
If you’re using native forms there is no way to prevent duplicate entries. This is because nothing is written to the table until the form is submitted, and so there is no way to detect the duplicate.

This is where custom forms come in. With a custom form, you target your input components at User Specific Columns, and the values are written to those columns immediately. You can then use those to detect duplicates before the form is submitted and take appropriate action.

Here is a concept app that demonstrates how to do it:

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…