Suggestions please.
I am using a Google worksheet as data source. The worksheet itself is populated using an IMPORTRANGE function, in cell A1. The resulting data has a column of unique ID “sectionID”, type = Number.
The table key keeps defaulting to _RowNumber, complaining that the chosen key column is invalid because it contains a spreadsheet formula.
This isn’t technically correct - the sectionID column is data only - but I see where AppSheet may be coming from as the whole range is generated by a formula.
Interesting side note - the table has been accepted previously… but something has made AppSheet notice it now, and flag the error.
When you say, Make sure the table is read-only, I apologize if this is a stupid question, but doesn’t that mean you can’t write to the object any longer? I had a previous version of this working without this issue, and I regenerated the schema after deleting an unrelated column and now I’m having all sorts of issues with this default to ‘_RowNumber’ when I have a clear ‘ID’ column. (I’ve tried several data types, and AppSheet still wants to think I have a formula on the Sheets side, when I don’t, even though I played with it a little)