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.
Solved! Go to 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.
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.
User | Count |
---|---|
26 | |
25 | |
24 | |
23 | |
20 |