How to automate an alert when duplicate row is created

1

Hi,

I have a table called Contacts with a column Name.
How do I create an automatic alert when a row with a duplicate name is entered?
Ideal would be a dialog box asking ‘Are you sure to add this duplicate contact? (Y/N)’

Already checked the community, but couldn’t find an answer. Any help or pointer is appreciated.

Best, Koen

2

Dear @Koen73

Just to keep it simple.:bulb:
This post explains how to find duplicates:

1 Like
3

Thanks @Jean_Pierre_Traets.
This works in the ‘Table’ view, not in ‘Detail’ view.

4

It would be nice if columns had a setting option: Allow/Do Not Allow Duplicates.

I would make heavy use of this, actually.

@mallika

4 Likes
5

+1 @Ander

Another nice setting option for columns would be: Mandatory Y/N

2 Likes