Mark only duplicates, not the first occurance

[BikeBoy]

Hi folks,

I can't remember for the life of me how to script this: I want to have a calculated field that DYNAMICALLY marks only repeating duplicate records, not the first occurance of the dup.

For innstance: Case(Count(SelfJoin::ID)>1, 1, "")

This will mark all of the dups with 1, but I want to mark only the repeating ones. I'm aware of the script that does that, but I need to do this with calculated field as it must be dynamic.

Thanks for the advice

B

[Ugo DI LUCA]

Hi,

Case(RecordID = SelfJoin::RecordID, 1,0)

but I retain this thread as a must see

[BikeBoy]

Thanks Ugo, but it didn't work for me. This tags all of the records as 1, which is to be expected.

I guess I have the same problem as jasonwood from the thread you provided:

It seems to me that both of the duplicates would have a valid self relationship to eachother, so wouldn't they both get tagged?

[danjacoby]

Perhaps (and I haven't tested this) you could create a field that auto-enters an "X" (or some alert) if the self-join count is greater than one. That way, the first entry wouldn't enter the "X", but subsequent ones would.

I'm not sure how "dynamic" you need, since a record is either a dup when it's created or it isn't.

[Ugo DI LUCA]

Hi,

It should work, but change it to

c_checkdupes = Case(Record_Id = SelfjoinOntheFieldYouwantToCheck::Record_Id, " ", 1) if you wish

Record_Id = the serial

Selfjoin = Name::Name (this isn't the best example, but...).

I use it everyday !!!