# Duplicate Records Checker

**URL:** <https://forums.knack.com/t/duplicate-records-checker/13751>\
**Category:** Get Answers\
**Created:** [February 9, 2023, 1:35pm UTC](https://forums.knack.com/t/duplicate-records-checker/13751 "2023-02-09T13:35:02Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![andrewstee38626](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)\
**Post date:** [February 9, 2023, 1:35pm UTC](https://forums.knack.com/t/duplicate-records-checker/13751/1 "2023-02-09T13:35:02Z")

</div>

Ok, Ive seen this has been asked a few times over the years, but as an experienced Knack developer Ive notbeen able to find or think of a good native soltuion without resorting to api’s in and out of knack.

Does anyone have a suggestion for record duplicates. Specifically on lastname & postode. I cant use formula fields to check as they are not able to be flagged as unique (only created after data entry).

I wish Knack had a native dupe checker, but it seems to not have been something they have really looked at, despite requests.

Thanks,  
Andrew Steele (UK)

---

<div class="post-metadata">

**Author:** ![Sunny\_Singla](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/sunny_singla/32/1007_2.png) [@Sunny\_Singla](https://forums.knack.com/u/Sunny_Singla)\
**Post date:** [February 9, 2023, 3:49pm UTC](https://forums.knack.com/t/duplicate-records-checker/13751/2 "2023-02-09T15:49:32Z")

</div>

Hello Andrew,

There is no native solution. But using javascript I did this many times. And also explain in the below request.

> [@Combine fields to make a unique record](https://forums.knack.com/t/combine-fields-to-make-a-unique-record/11824/17):
>
> Also @Sunny_Singla , I’m trying to hide the text formula field with CSS like you suggested, but it just wont hide, can you check my code here too to see what i’m doing wrong? Thank you! Happy to pay you for your help as well. #kn-input-field\_1403 { display:none !important; }

or

[https://roberts.knack.com/farmers#checkuniqueness/](https://roberts.knack.com/farmers#checkuniqueness/)

javascript used

$(“#field\_281 , #field\_282”).live(“change , blur”,function(){

$(“#field\_283”).val($(“#field\_281”).val()+" “+$(”#field\_282").val());  
});

Thanks,  
Sunny Singla  
[ssingla1985@gmail.com](mailto:ssingla1985@gmail.com)  
+919855089359

---

<div class="post-metadata">

**Author:** ![andrewstee38626](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)\
**Post date:** [February 9, 2023, 4:17pm UTC](https://forums.knack.com/t/duplicate-records-checker/13751/3 "2023-02-09T16:17:21Z")

</div>

Thanks Sunny, I guess we may be able adapt that one - I really wanted to “flag” a field so we can omit them from tables once found.

---

<div class="post-metadata">

**Author:** ![JDWorleyKY](https://avatars.discourse-cdn.com/v4/letter/j/9de053/32.png) [@JDWorleyKY](https://forums.knack.com/u/JDWorleyKY)\
**Post date:** [February 9, 2023, 9:19pm UTC](https://forums.knack.com/t/duplicate-records-checker/13751/4 "2023-02-09T21:19:51Z")

</div>

Sunny is the best! This solution works great for our app. It prevents the user from even submitting the form in the first place.

---

<div class="post-metadata">

**Author:** ![andrewstee38626](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)\
**Post date:** [February 10, 2023, 12:09pm UTC](https://forums.knack.com/t/duplicate-records-checker/13751/5 "2023-02-10T12:09:49Z")

</div>

Hi Thanks for this, but the leads are coming in via api, not a form, so we need to check and flag once they are in the object.

---

<div class="post-metadata">

**Author:** ![Sunny\_Singla](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/sunny_singla/32/1007_2.png) [@Sunny\_Singla](https://forums.knack.com/u/Sunny_Singla)\
**Post date:** [February 10, 2023, 12:45pm UTC](https://forums.knack.com/t/duplicate-records-checker/13751/6 "2023-02-10T12:45:16Z")

</div>

> [@andrewstee38626](#):
>
> Does anyone have a suggestion for record duplicates. Specifically on lastname & postode. I cant use formula fields to check as they are not able to be flagged as unique (only created after data entry).

Then why you not try to concatenate those field via API (it actually looks simple as I think)

---

<div class="post-metadata">

**Author:** ![andrewstee38626](https://avatars.discourse-cdn.com/v4/letter/a/dfb087/32.png) [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)\
**Post date:** [February 10, 2023, 1:03pm UTC](https://forums.knack.com/t/duplicate-records-checker/13751/7 "2023-02-10T13:03:55Z")

</div>

It does, but we are not supplying the leads - its from outsode websites and they are not able to do so, apparently 🙂