The key keeps on changing to _RowNumber despi...

[WESLEY_RENTON]

The key keeps on changing to _RowNumber despite the fact that I keep on changing and saving it to another column… Why is it doing this?

I want it to stay on pupil number, however it keeps on changing back to rownumber and then the app does not work…

[Levent_KULACOGL]

[Pupil number] column is marked as Read-only. You cannot assign a read-only column as a key column.

[WESLEY_RENTON]

@Levent_KULACOGLU many thanks … however the Pupil number column also keeps on changing back to read only even after I uncheck it…

[Levent_KULACOGL]

@WESLEY_RENTON do you have a sheetformula in that column in your gSheet? An Arrayformula function for example

[WESLEY_RENTON]

This sheet is a reference for another sheet… would that be the issue?

[Levent_KULACOGL]

Are you using IMPORTRANGE or usual Sheetname!'CellRange reference?

[WESLEY_RENTON]

The usual way. With ref and the sheet name.

[Levent_KULACOGL]

@WESLEY_RENTON if you don’t expect AppSheet to construct that sheet reference function in your gSheet each time you record a data, I advise you to construct an Arrayformula in Row 1 of [Pupil number] column in your sheet and then remove the expression in SheetFormula property of that column. Uncheck Read-only and Hide marks and set the Show_if

property of this column to =False