# Enforce column value is unique (distinct)

**URL:** <https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842>\
**Category:** Ask for Help\
**Created:** [May 11, 2022, 8:12am UTC](https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842 "2022-05-11T08:12:25Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 11, 2022, 8:33am UTC](https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842/2 "2022-05-11T08:33:04Z")

</div>

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?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014):
>
> 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](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…

---

_[View the full topic](https://community.glideapps.com/t/enforce-column-value-is-unique-distinct/41842)._
