SIGN UP

Eliminate Duplicate Values In A View

By: Michael Clark | Asked: 06/10/2022
Forums › Category: How-to › Eliminate Duplicate Values In A View
Vote Up 0 Vote Down
Michael ClarkMichael Clark asked 3 years ago

I have a view that contains entries from two years and the entries may have the same value in one field: email address. I need to only return unique email addresses. How can I filter so that I get *all* entries (not just newest or oldest) from both years, with no duplicate email addresses?

1 Answers
Vote Up 1 Vote Down
Bobby Clapp Staff answered 3 years ago

My educated guess is that you need to work with these:

Where filter = https://formidableforms.com/knowledgebase/frm_where_filter/#kb-add-two-filters-combined-with-or
SQL Distinct = https://www.w3schools.com/sql/sql_distinct.asp

Michael ClarkMichael Clark replied 3 years ago

Thank you, Bobby. There's almost *always* a code snippet!

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community
crossarrow-right