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โฆ
[Pupil number] column is marked as Read-only. You cannot assign a read-only column as a key column.
@Levent_KULACOGLU many thanks โฆ however the Pupil number column also keeps on changing back to read only even after I uncheck itโฆ
@WESLEY_RENTON do you have a sheetformula in that column in your gSheet? An Arrayformula function for example
This sheet is a reference for another sheetโฆ would that be the issue?
Are you using IMPORTRANGE or usual Sheetname!'CellRange reference?
The usual way. With ref and the sheet name.
@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
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |