Doppelte Einträge finden

das würde mich auch mal intessieren. generell den die datenbank nach ähnlichen oder doppelten einträgen durchsuchen. auch drai jahre später…

Frank,

Maybe this helps:

https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/how-i-can-prevent-duplicate-records-being-added-5b7697059efc8227533e7d76?page=3

Steven

thanks. will try

Unfortunately, Ninox does not actulally enforce not saving a record if it is a a duplicate on a chosedn key field that you want as unique

However I check for duplciate customer account codes.

This is my script - I test it on entering new customers so that the account code is not duplicated!

let a := upper(Custid);
if cnt((select Customers)[upper(Custid) = a]) > 1 then
styled("A/c Code is in use !", "red")
end

so you could add something like this

Add a formula field to your form - then add a script to it 

you will need to enter your table name wher the products are stored

let a := 'Item nmber';
if cnt((select your table name here)['Item number' = a]) > 1 then
styled("A/c Code is in use !", "red")
end

record 1 - product item and code entered

Entering Record 2 - Product number 2 but inadvertantly tring to give it the same code as product 1!

Hope that helps

also forgot to say I have set the formula to show only whne the condition is true!

and they only way I could get it to work was to enter excatly the same scripnt into the 

Display field only if - section

So you need it it that and the Forumla section !