duplicados appsheet

[elezan82]

Me podeis ayudar con este codigo?

COUNT(SELECT(RECOGIDAS[Pedido Compra],[Pedido Compra]=[_THISROW].[Pedido Compra])) = 0

Con esta formula, no me deja modificar la entrada

Gracias.

[Suvrutt_Gurjar · Accepted solution]

Please try 

ISBLANK(
FILTER(
"RECOGIDAS",
([_THIS] = [Pedido Compra])
)
- LIST([_THISROW])
)

Basically, the highlighted portion of - LIST([_THISROW] takes care of disregarding the current row's value so that the duplicate check does not fail on a row edit.

Please check the last section of the article below

List expressions - AppSheet Help

However, please be aware that in AppSheet, such validations can fail in a multi user environment when two users try to simultaneously work on the same row/data.