# Unique number check in a column possible?

**URL:** <https://community.glideapps.com/t/unique-number-check-in-a-column-possible/58040>\
**Category:** Ask for Help\
**Created:** [February 16, 2023, 6:42pm UTC](https://community.glideapps.com/t/unique-number-check-in-a-column-possible/58040 "2023-02-16T18:42:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ronald](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ronald/32/49776_2.png) [@Ronald](https://community.glideapps.com/u/Ronald)\
**Post date:** [February 16, 2023, 6:42pm UTC](https://community.glideapps.com/t/unique-number-check-in-a-column-possible/58040/1 "2023-02-16T18:42:20Z")

</div>

Hi and greetings from the Netherlands.

In my Glide table i have a column witch hold an sku number. That sku number has to be unique and in a fixed format of 7 digits. This 7-digit code is not sequential or otherwise arranged and is manually implemented. For example: 2308001 and then it’s not necessarily or likely that the next code will be 2308002. It’s random made up by the user and it should stay that way.

Now when entering a new sku code (a new row in that glide table) I want to check whether it already exists. Anyone have suggestions or ideas?

Thank you for your suggestions in advance!  
Ronald Klop

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 16, 2023, 10:52pm UTC](https://community.glideapps.com/t/unique-number-check-in-a-column-possible/58040/2 "2023-02-16T22:52:12Z")

</div>

Create a relation column from the code column back to itself. If it found a match, then the cell won’t be empty and you can use that for filtering or visibility conditions

---

<div class="post-metadata">

**Author:** ![Ronald](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ronald/32/49776_2.png) [@Ronald](https://community.glideapps.com/u/Ronald)\
**Post date:** [February 17, 2023, 7:21am UTC](https://community.glideapps.com/t/unique-number-check-in-a-column-possible/58040/3 "2023-02-17T07:21:37Z")

</div>

Thank you Robert,

That was the solution!  
Great!

Regards, Ronald

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 18, 2023, 7:21am UTC](https://community.glideapps.com/t/unique-number-check-in-a-column-possible/58040/4 "2023-02-18T07:21:41Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.