Checking for duplicates when adding via a form

1

Hello!
Is it possible, when adding some value through the Form, to immediately check the presence of this value in the table? To avoid duplicates.
Formula like:
Not(Table.Filter(ID.Contains(CurrentValue).Count()>0))
does not work.

2

Hi @Givi_B

This formula (for a checkbox for example), will show you quickly which row appear several times (based on ID value)

image
image1161×465 37 KB

Is that what you want ? I added it directly inside your doc

Please let me know,

Cheers,

Quentin

3

Yes, this will help sometimes, but here I want to generally prohibit entering text or a number if it is already in the database

4

OK Sorry.
As you cannot auto-refer to a column that you want to fill,
create a list of ID outside of your table

image
image912×651 38.5 KB

And add this condition to your field in form

image
image1240×781 38.2 KB

CPT2212121159-1170x393

5

Hi @Givi_B
Did you have a look on that ? Cheers

6

Hi, That helped! Thank you!
I don’t know yet how much this will slow down a large database, but it works great now!