I would like to identify duplicate records in one table

Question

I have a text field titled Building Name and I would like to identify duplicate values in the Building Name field. I also would like to know how many for each - particularly in a summary report. Do I perform this with a formula query? If so , how?

------------------------------
Jason Tommy
------------------------------

PrashantMaheshw · Answer

Formula Query is 1 way , Personally I export to excel with RID, highlight in excel and introduce a new field isDuplicate and reimport back. Whole process takes me around 3 min

BUT I believe so will formula query
https://community.quickbase.com/blogs/ashley-banning/2021/07/26/finding-duplicates-in-qb-just-got-easier

------------------------------
Prashant Maheshwari
------------------------------

Sign up

Login to the community