The spreadsheet row number is being used as a key in the table 'Meath'. It's best to include an 'ID'

AppSheet AppSheet Q&A
,
1

Hi,

I am new to AppSheet and low code apps.

I have created an excel spreadsheet, and have also customised the App but continue to get an error:

(The spreadsheet row number is being used as a key in the table ‘Meath’. It’s best to include an ‘ID’ column in the table.)

Can anyone help me resolve this?

1 Like
2

Please take a look a the the below article and the section titled, "Row number keys" in that article.

https://support.google.com/appsheet/answer/10106672?hl=en

1 Like
3

I have an ID column in my table, have zero formulas in the sheet, column type set to text, and I try to set the ID column as my Key in AppSheets, yet every time I hit save, AppSheets moves the key back to the Row Number column and gives me a warning. I’m about to throw my macbook!