Find and mark duplicates automatically

[Isebar_DE]

How to do that :

[Christiaan_Huizer]

have a look here @Isebar_DE

How to get unique records in Coda?

Cheers, Christiaan

[Math_24]

Hi
you can do it with this formula for example:

thisTable.filter(currentValue.Name == Name).find(thisRow).count() > 1

[Isebar_DE]

Hi. Thx for the answer. Is there a error in the fomula or did i not do something?

[Isebar_DE]

Hi Christian.
Thx for the answer but this is way to complicated for me.
Still very much a beginner with coda.

[Christiaan_Huizer]

hi @Isebar_DE , I am sorry to hear that, the blog intents to show a fundamental principle you can apply in various contexts.

it is the same logic as developed by @Math_24 , but he writes a kind of Javascript inside Coda (using == for example, which may be confusing when you are not familiar with JS).

He will respond to you and I guess he suggest to replace currentvalue.name with thisRow

Cheers, Christiaan

[Isebar_DE]

@Christiaan_Huizer , @Math_24

Like this?

[Christiaan_Huizer]

hi @Isebar_DE ,

in two steps:

thisTable.Filter(Name.Contains(thisRow.Name)).Find(thisRow)

this one output a number in third column.

The next step is to put a function behind the checkbox:

enjoy, Cheers, Christiaan

[Math_24]

Yes, the problem is that you’re probably comparing him to himself.

currentValue.name == name (currentValue) but need name thisrow.

More details :
thisTable.filter(currentValue.Name == thisRow.Name ).find(thisRow).count() > 1

or like @Christiaan_Huizer proposal, which works very well

[Isebar_DE]

@Christiaan_Huizer @Math_24 solved. Thanks alot guys.