Duplicate Name Checker System

Get Help
1

"Hi Adalo Community,

I’m working on implementing a duplicate checker system in my app to detect when the same worker is assigned to multiple work programs with overlapping dates. Here’s what I’ve built so far:

I’ve created a ‘Duplicate Checker’ collection that has relationships with both my Workers (PRG_operai) and Work Programs (PRG) collections, plus a boolean field to flag duplicates. I’ve also set up a ‘Check Duplicates’ button that should:

  1. Create new records in the Duplicate Checker collection for each worker in the current program
  2. Check for overlapping dates between programs for the same worker
  3. Set the boolean flag to true when duplicates are found

I’ve successfully configured the first step using Create Multiple Records. However, I’m struggling with the Update Multiple Records action where I need to compare workers across different programs to detect overlaps. Specifically, I can’t find a way to properly compare worker IDs between records in the Duplicate Checker collection.

Has anyone implemented a similar duplicate detection system? I’d greatly appreciate any guidance on how to set up these filters correctly to identify when the same worker appears in multiple programs with overlapping dates.

Thank you in advance for your help!"

2

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.