Modificar hoja

[Joncini]

El nombre de columna '_RowNumber' en el esquema 'Calendario de Pagos_Schema' del tipo de columna 'Number' tiene una restricción de validación de datos no válida '=UNIQUEID()'.

Tengo este error y no pude continuar, no me deja colocar en el ROWNUMBER que sea UNIQUEID, revisé varias maneras pero no encontré el error.

Agradezco me puedan orientar

[Aurelien]

Google translate: 

Column name '_RowNumber' in schema 'Payment Schedule_Schema' of column type 'Number' has an invalid data validation constraint '=UNIQUEID()'.

I have this error and I could not continue, it does not let me put in the ROWNUMBER that is UNIQUEID, I checked several ways but I did not find the error.

I appreciate you can guide me 

Hi @Joncini

Row number cannot have an expression, as it is an indication of where is located your record in your Sheets.

I would suggest adding a key-column in your sheets, as the first column, and set its initial value with the expression UNIQUEID().

It should look like this:

In your sheets:

In your app editor, in Data>Columns:

[Joncini]

Aurelien, thanks for your comments, that's what I try to do, but when I put
a UNIQUEID in the ROWNUMBER it doesn't accept it, and this happened to me
when I tried to modify a column in Google Sheets, because the APP was
working before, when I do something modification to the sheet Google Sheet
always throws me an error, you understand me.

I appreciate if you guide me, Thank you

--

*John Alexander Gutiérrez García Cel 317 515 3746*

[SkrOYC]

Hola @Joncini, por favor vuelve a leer el comentario de @Aurelien 

NO puedes usar ningún tipo de fórmula en el _RowNumber.

Agrega manualmente una columna a tu hoja de GSheets que sea la llave/Key/Id para las filas y allí es donde podrás agregar la fórmula UNIQUEID()

[Aurelien]

Muchas gracias @SkrOYC por espresar en español lo que intentó describir en inglès (and please excuse my spanish, I did not practice it for...well, 10 years 🤣)

[Joncini]

Thanks. Me again, this is what I get on the screen

[image: image.png]

I created the Key column but it keeps throwing me an error.

--

*John Alexander Gutiérrez García Cel 317 515 3746*

[Aurelien]

Hi @Joncini 

The image did not load.

I think you are answering from your message service, can you try using the communty interface instead ?