Security filter and duplication

[Ing_Fred_Fiifi_]

I have security filter on the app. Therefore the user capture their work and see only their data. But the problem is how do I prevent duplicate between the two users. Thank you

[Marc_Dillon]

If the duplication is only based on a small number of columns, you might duplicate just those columns in another table, and load that full table into the app for this purpose.

Otherwise, you don't prevent duplication at the time of record creation. You could instead run a Bot, with the 'ignore security filters' setting turned on, that will do some action when it detects a duplicate.

[Ing_Fred_Fiifi_]

Any sample please..... Or how show me how I can do it pls