and even more powerfull :
did anyone develop a tool to look for "approximate" duplicates ?
lets say i have a text field
i want to find texts that "seem" to be the same…
we could imagine having a sort of cursor in order to tell the tool "how approximate" we want the search to be…
i think plenty of us would use such a tool
don't you think ?
a hint might be with the use of a word counter or something…
I addes this to our feature request list.
badly needed… thanks
How can I find any dublicates (several entries with the same content)? Thanks!
Anwer from an support member in another post you could have found too by searching for "duplicates":
Thursday, October 11, 2018 5:09 PM
Hi, you can use a formula to identify duplicates.
Here is an example:
You can insert a formula of the following form into the appropriate table (in the example Contact) in the field "Trigger after update" of the table properties:
let myFirstName := 'First name';
let myLastName := 'Last name';
let cntFirstName := cnt((select Contact)['First name' = myFirstName]);
let cntLastName := cnt((select Contact)['Last name' = myLastName]);
if cntFirstName > 1 and cntLastName > 1 then
'First name' := null;
'Last name' := null
The system checks whether the fields First name and Last name already contain the same combination of names in another data record.
If this is the case, a message "Duplicate!" appears and the fields are cleared again.
If you do not want to perform the check at table level (i.e. every time any field content is changed in the table), you can also insert the script at each of the individual fields in the same option ("Trigger after update") of the field properties.
Apologies in advance for this very basic question, but I can't seem to find an answer that's written for someone as new to this as I am. I want to adapt this formula to make sure my CustomerID field is unique within my Contacts table, but I'm obviously missing something fundamental, as I can't make it work. Please help? Thank you!