Prevent Duplicate Items on checklist.LIST

[amielalcala]

Hi everyone,

I'm currently facing this issue where there are duplicate records that are being generated in an HR Task under checklist.LIST.

Any idea how to prevent this from happening? It's also affecting the mobile app as it's currently showing duplicate checklist items.

Thank you!

[Sandeep Rajput · Accepted solution]

@amielalcala You can create an onBefore insert business rule on the checklist table and check if a checklist record already exist for a Document (HR Task sys_id in your case). You can use current.setAbortAction(true); to terminate the new record creation if the record already exist.