Solved: Filter to create a check of two conditions to avoi... - Page 2

Inventarios_FOO · 08-24-2021 03:05 AM

Hello, how can I create a filter for a form that checks the table where the data will be recorded if the value of one of its columns does not exist according to 2 conditions, basically what I want is to check that it is not duplicating the document number of the same vendor in the data table records to avoid data duplication. This table has a column for vendor and another for document number.

Here I show you the form:

Proveedor = Vendor
Nº Documento = Document Number

Right now the formula I am using certainly checks that the document number is not being duplicated, but I need to apply a second condition to check that that document number does not already exist from the same vendor.

ALL these statements are true:
…1: This statement is false:
…(The value of column ‘Nº Documento’) is one of the values in the list (The list of values of column ‘Nº Documento’
…from rows of table ‘Cuentas por Pagar’
…where this condition is true: (This statement is false:
…(The value of column ‘ID Transaccion’) is one of the values in the list (LIST(
…The value of ‘ID Transaccion’ from the row referenced by ‘ID Transaccion’))))
…2: This statement is false:
…(The value of column ‘Nº Documento’) is one of the values in the list (The list of values of column ‘Proveedor’
…from rows of table ‘Cuentas por Pagar’
…where this condition is true: (This statement is false:
…(The value of column ‘ID Transaccion’) is one of the values in the list (LIST(
…The value of ‘ID Transaccion’ from the row referenced by ‘ID Transaccion’))))

Thanks!!

Aurelien

OK.

Then, what about this:

ISBLANK(
  FILTER("Cuentas por Pagar",
  AND(
    [_THISROW].[Nº Documento]=[Nº Documento],
    [_THISROW].[Proveedor]=[Proveedor]
  )
)

Or, if you set this in the [N° Documento] Valid_If field:

ISBLANK(
  FILTER("Cuentas por Pagar",
  AND(
    [_THIS]=[Nº Documento],
    [_THISROW].[Proveedor]=[Proveedor]
  )
)

Let us know if that works for you

Edit: For reference:

View solution in original post

Filter to create a check of two conditions to avoid duplicating data