Solved: Restrict duplication on the same date and allow sa... - Page 2

wsaico · 09-14-2021 03:35 PM

Hello, I ask you for help with a formula, I am using this formula NOT(IN([_THIS], SELECT(Aduanas[N VUELO], [FECHA] = TODAY()))) to Restrict duplicate on the same date but when editing and saving again it does not allow me.
What formula can I use?

Steve

Try:

NOT(
  IN(
    [_THIS],
    SELECT(
      Aduanas[N VUELO],
      AND(
        ([FECHA] = TODAY()),
        ([_ROWNUMBER] <> [_THISROW].[_ROWNUMBER])
      )
    )
  )
)

View solution in original post

Restrict duplication on the same date and allow saving after editing