Enforce column value is unique (distinct)

[Darren_Murphy]

Glide doesn’t provide any native mechanism for enforcing uniqueness. To do so, you need to create your own logic in the data editor.

The general approach is to use a multiple relation that matches the column in question to itself, and then check if the relation is empty or not.

The below (copyable) concept app demonstrates how this can be done

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…