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

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


bu hatayı bir türlü kaldıramadım bu nedir nasıl düzelte bilirim.
Ekran görüntüsü 2023-08-05 194827.png

0 5 850
5 REPLIES 5

Former Community Member
Not applicable

Hi Joseph - apologies but the article is not clear. Could you please illustrate with an example? Thanks!

 

What is the article not clear on? Here is a screenshot that explains using the [_ROWNUMBER] as a key and the fact that Appsheet will give a warning.

thanks joseph for helping because I agree the article is not clear

Error means App sheet is temporarily using that column as a primary key. You have to create a column in your excel spreadsheet  and create a system that can identify each row. you can use 1234... for each row then go back to app sheet and untick(Key) the column its complaining about and select(key) the new column you created. if i am not clear copy and paste the error on YouTube to get a demonstration   

Top Labels in this Space