Identify duplicates without creating a connecting table?

Ask the Community Get Answers
1

I have an object in which there is a field called barcode. There are about 35,000 records in this object. It’s a list of applications for historical records … the barcode is the archive item number. It’s very possible that more than 1 applicant might apply for the same barcode … about 2500 have multiple requests.

I need a way to flag visually (for the staff fulfilling those applications) that the barcode is used across multiple applications, so they fulfil them all at the same time.

The native Knack way to do this would be to create a Barcodes table and connect each application to that table then count the number of applications connected to each barcode, and then set a flag in each application if barcode count > 1. That works, but the issue is it almost doubles my overall record count … which will force me up to the next payment tier.

Does anyone know of another way to achieve this without needing to create additional records?

2

And just a bit more info. The applications are not created via a form .. they are currently imported on a weekly basis but will eventually be via an API. So i can’t use any “on submit” functionality …either record rules or JavaScript. And I’ve discovered no way to do it with tasks.