We have a ticket id field and sometimes this is duplicate value. Is there a filter or any report we can run that will group these by potential duplicate values? We need a report or view to manually merge duplicate tickets but I don’t know how to properly identify the duplicate IDS in the ticket name this is an example attached how the ID shows.
Hi @cclark2,
If you’re open to third-party tools, I’d recommend approaching this with Koalify: https://koalify.io/
Koalify supports identifying tickets based on custom rules (such as matching ticket names). The app can flag these potential duplicates within HubSpot for you - and you can also use HubSpot’s native workflows to deduplicate tickets based on these custom rules you set up.
If you want to install and test the app, you can do so here: Koalify (Disclaimer: the link is an affiliate link which makes me eligible for commission. It leads to the exact same install process as the HubSpot app marketplace.)
As far as I now, this is currently not possible natively, at least not without custom coding your own solution.
Best regards!
For now, I’d export the tickets with that ID field and check the column for duplicates in Excel or Google Sheets. A simple COUNTIF formula will show which IDs appear more than once. It’s also worth checking where the duplicate tickets are coming from. It may be a repeated form submission or an integration creating the same ticket twice. Fixing that source will save you from doing the same cleanup again later.
Hi @, there’s no built in “find duplicate values” filter in ticket views, but you can get close, create a custom report (Ticket properties) and use a Group By on your ticket ID property any ID with a count greater than 1 in the report is a duplicate. Alternatively, if the ID is embedded in the subject line like your example, a saved view filtered by “Ticket name contains [ID]” per known ID lets you pull matches manually. For ongoing detection, a workflow that checks if property value equals any existing record isn’t natively supported, so many teams pair this with a custom coded action or an operations hub data quality automation to flag dupes going forward.