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
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:
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
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()
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 
)
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
Hi @Joncini
The image did not load.
I think you are answering from your message service, can you try using the communty interface instead ?
