Forum Discussion
AlexWilkinson
4 years agoQrew Assistant Captain
Lovely! Thanks so much. By the way, for those who have crafted their own solutions for finding duplicated people, here is an idea I have found very helpful. For "Last Name" create a formula-text-field consisting of the first __ consonants. (I use 3 consonants). Do the same for "First Name". Finding matches on these formula-fields can help to identify cases like "Wilkinson" (my actual last name) vs "Wilkerson" (how some people misspell it). If I understand how formula queries will work, extraction of the 3 consonants could be done dynamically, rather than in a static, stored formula-field. Nice!