Check for duplicate entries

Help Center Get Answers
1

 anyone found a way to check or report on duplicate entries? I have a field text formula that generates a uniques ref but you cant use UNIQUE on a formula ... I cant think of a way of finding them except sorting a table byt this ref and wading through ... anyone any ideas please?

thanks

Andrew Steele (UK)

2

You mentioned if they type phone number the same way. Is your phone number field formatted as 'phone number' or text?

3

Hi Neal,

yes that works but means yo have to wade through many pages of tables with a single entry in 99.9% of all groups just to find the ones that have 2 or more in ... thanks though, its a start

4

Hi Sam, yes thats the only way I can see it working at the moment.  We keep telephone number unique as well, so it checks as you enter, but only if the same number has been sent it and is typed in the same way. 

thanks

 

5

I can't think of a good way in Knack, but you could export the table, open with MS Excel, then use conditional formatting to highlight duplicates.

6

Idea :

Grouping summary on formula field might help.

Each unique value of formula field will show corresponding duplicate records.

Would you like to update/merge duplicate records to remove duplicates?

Following image is from https://.knack.com/hc/en-us/articles/226584588-Tables

Neal

NealPatil @ gmx.com

7

As we are in the UK we have to set the type to be free, as there isnt a specific format to suit UK phone numbers :frowning: