Ejecutar Data Validity solo cuando se inserte un registro

[SoldiverSof]

Buenas noches comunidad,

Cómo lo menciono en el titulo, estoy tratando de validar una columna que almacena un código de un comprobante cuando se ingresa un nuevo registro pero ocurre que cuando quiero modificar un registro ya creado la formula del Data Validity manda error debido a que él código único ingresado para el registro en edición ya existe.

Existe alguna manera de qué la formula solo se ejecute cuando el registro se esté creando y no editando?

[Suvrutt_Gurjar]

Please employ the technique mentioned in the article referred below to avoid duplicates.

Essentially, you need to remove the current row from the filter expression, as highlighted below.

ISBLANK(
FILTER(
"Table Name",
([_THIS] = [Column Name])
)
- LIST([_THISROW])
)

List expressions - AppSheet Help

[SoldiverSof]

Hi Suvrutt,

I can´t get the idea that you show. Please, Explain me more about it, I can`t solve it yet

[Suvrutt_Gurjar]

If possible, please share your valid_if expression. Then I can suggest changes.

[SoldiverSof]

Here is it.

COUNT(FILTER("TableName", ([UniqueIdBill] = [_THISROW].[UniqueIdBill])))<=0

[Suvrutt_Gurjar]

Assuming you are trying to avoid duplicate in the column CodigoFacturaReciboCheque column, please try

ISBLANK(
FILTER(
"Table Name",
([_THIS] = [CodigoFacturaReciboCheque])
)
- LIST([_THISROW])
)

[SoldiverSof]

I made the changes, but it doesn´t work. When I edit one row, the validation always ocurrs and blocks me to save the row change.

[Suvrutt_Gurjar]

The table name in your column description and table name in the expression seem to be different. If so, any specific reason you are doing so?

[SoldiverSof]

Yes, the information of ID's I take them from another table that has the IDs.

[Suvrutt_Gurjar]

Please explain what you mean by information of IDs and please restate your requirement more properly. It was not mentioned that the tables are different anywhere in previous description. 

[SoldiverSof]

Sorry,

Ok, I have two tables. In the first one, I save the main information. The second one is a SQL View that has just the uniques ID's from the first table. When I make the validation, the formula validates if the unique ID joined is In the SQL View. 

[Suvrutt_Gurjar · Accepted solution]

Please try

ISBLANK((FILTER("TableName", ([UniqueIdBill] = [_THISROW].[UniqueIdBill]))-[_THISROW].[UniqueIdBill])

[SoldiverSof]

TableName will be the second table(SQL View)?

[Suvrutt_Gurjar]

Yes

[SoldiverSof]

I doesnt work, I tried now.

[Suvrutt_Gurjar]

Please try the table name as dbo.Gastos.CuentasProyectos

[SoldiverSof]

Thanks Suvrutt, 

This was the solution. 

Regards