Popup that identifies and displays duplicate records

jakegartenberg · ‎10-21-2022

We have an issue with users submitting duplicate records. I am trying to create a popup window that would display on the insert of a new record if a query to look for duplicates returns at least one record. the following criteria must be met:

The popup would display the records that were returned by the query as potential duplicates, and have links to them as well.
The popup would ask the user to confirm the insert of the new record or allow them to cancel.

Has anyone done something similar in the past? or know of an OOB example that does something similar? My thought process was to use an onSubmit() client script however we only want it to run on insert of a record not on update.

Is a UI Page the best way to create the popup? or can a GlideModal popup show multiple records and link to them as well?

jonsan09 · ‎10-21-2022

Are you trying to get this running on a catalog item or table record?

jakegartenberg · ‎10-21-2022

table record

Bert_c1 · ‎10-21-2022

See:

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/field-administra...

for a business rule example, that checks for "duplicates". for you, the business rule will be configured to run on "Insert". And you can replace the logic to get a new number with an "addInfoMessage()". But this runs when the user submits the record and doesn't present any UI to "confirm" or "cancel" the record submission. You may use a Client Script and AJAX (to query the server) and achieve what you want.

Nic Omaha · ‎11-19-2023

Looking to do the same thing, did you ever find a solution to this?