The key keeps on changing to _RowNumber despi...

(WESLEY RENTON) #1

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 KULAÇOĞLU) #2

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

(WESLEY RENTON) #3

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

(Levent KULAÇOĞLU) #4

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

(WESLEY RENTON) #5

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

(Levent KULAÇOĞLU) #6

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

(WESLEY RENTON) #7

The usual way. With ref and the sheet name.

(Levent KULAÇOĞLU) #8

@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