Prevent duplicate entry on a new form

Hopefully the last question, Can I change the color of that text?

I’m not sure, actually. You could try using a format rule.

Hello Everyone,

I badly need help.

I want to make sure that no duplicate data entry occurs

The fields in each row are as follows: (State, City, House Number)

Example

State City House Number Duplicate (y/n)
Dhofar Salalah 234 N
Dhofar Hafa 234 N
Dakhiliyah Salalah 234 N
Dhofar Salalah 234 Y ( Duplicate)
ISBLANK(
  FILTER(
    "table",
    AND(
      ISNOTBLANK([State]),
      ([State] = [_THISROW].[State]),
      ISNOTBLANK([City]),
      ([City] = [_THISROW].[City]),
      ISNOTBLANK([House Number]),
      ([House Number] = [_THISROW].[House Number])
    )
  )
)
2 Likes

Thank you so much, you saved me, man

1 Like

The formula works fine when add a new record. When I modify it give me an error

1 Like

Oops! Yep! I missed a line! Try the following:

ISBLANK(
  FILTER(
    "table",
    AND(
      ISNOTBLANK([State]),
      ([State] = [_THISROW].[State]),
      ISNOTBLANK([City]),
      ([City] = [_THISROW].[City]),
      ISNOTBLANK([House Number]),
      ([House Number] = [_THISROW].[House Number]),
      NOT([_ROWNUMBER] = [_THISROW].[_ROWNUMBER])
    )
  )
)
1 Like

How about this it worked with me. is it correct?

ISBLANK(
FILTER(
“table”,
AND(
ISNOTBLANK([State]),
([State] = [_THISROW].[State]),
ISNOTBLANK([City]),
([City] = [_THISROW].[City]),
ISNOTBLANK([House Number]),
([House Number] = [_THISROW].[House Number])
)
)
- LIST([_THISROW])
)

1 Like

Looks good to me!

1 Like

Thank you, man, you are a savior

1 Like