# Applying the Unique Value Rule to a Text Formula Field

**URL:** <https://forums.knack.com/t/applying-the-unique-value-rule-to-a-text-formula-field/12203>\
**Category:** Feature Requests\
**Created:** [March 9, 2022, 3:39pm UTC](https://forums.knack.com/t/applying-the-unique-value-rule-to-a-text-formula-field/12203 "2022-03-09T15:39:46Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [March 9, 2022, 9:01pm UTC](https://forums.knack.com/t/applying-the-unique-value-rule-to-a-text-formula-field/12203/2 "2022-03-09T21:01:18Z")

</div>

Hey @Brad - as you’re probably aware, you can’t set a text formula as unique. This subject has come up before and my college Julian Kirkness has written an article. I’m sure that this could also be solved with some JavaScript checking the values before the form is submitted, but I’m not a coder. 😊

> [@Enforce Uniqueness/Prevent Duplicates](https://forums.knack.com/t/enforce-uniqueness-prevent-duplicates/8474):
>
> How can someone require that values for combinations of two fields be unique? For example, we have a field called DrawingNumber# and a field called WorkTicketNumber. Together, these fields need to be unique: -A record can share a DrawingNumber with other records, but each of those records must have a different WorkTicketNumber. -A record can share a WorkTicketNumber with other records, but each of those records must have a different DrawingNumber. -No two records can share BOTH a DrawingNumb…

---

_[View the full topic](https://forums.knack.com/t/applying-the-unique-value-rule-to-a-text-formula-field/12203)._
