In domains with thousands of people in names.nsf, many of whom are generated by agents, it is difficult to find duplicate people documents.
Here's an agent that will do this for you:
The agent should be set to: "Manually From Action Menu" and "All documents in view."
Place this formula into action field:
@If(@Elements(@DbLookup("";"";"People";@Trim(@Subset
(LastName;1))+@If(Firstname !="";" , "+@Trim(@Subset
(FirstName;1));"");1))>1;@Prompt([OK];"This Person occurs "+@Text
(@Elements(@DbLookup("";"";"People";@Trim(@Subset(LastName;1))
+@If(Firstname !="";" , "+@Trim(@Subset(FirstName;1));"");1)))+"
times:";@Implode(@Char(10)+FullName));"");SELECT @All
When you start the agent with the People view open, you will be prompted with the FullName for every double occuring person document.
You will wonder how many of them do you have...
