Hide add action to prevent duplicate

[romanus]

I am able to prevent duplicate second entry in the same day by adding valid_if formula:

ISBLANK(
  FILTER(
    "Presence",
    AND(
      ([_THISROW].[Date] = [Date]),
      ([_THISROW].[ID] <> [ID])
    )
  )
)

How to achieve the same purpose before opening the form by hiding add action button instead of the above situation when user filling the form with invalid value error message? I tried similar formula in the Only if this condition is true in Behavior, but do not work.

[Kirk_Masden · Accepted solution]

The “Only if this condition is true” condition in your action should work. If it isn’t working, please share the expression you used and the error message you got.