Appsheet, unique ID, no data visable in Google sheets

[robbertzalm]

Dear members,

I am new to Appsheet.

I have started building a simple inventory web app.

I have started with an excel document with some headers and data.

I have used Appsheet to start building the webapp with succes.

Appsheet suggested to introduce a ID column in my googlesheet and use this as an unique ID.

I have created the column in google sheets and used regenerated scheme in Appsheet.

To the column ID in Appsheet I have set parameters to --> Type: 'text', I have ticked 'Key', 'editable' and 'require'. As initial value I have used 'UNIQUEID()'.

Now when I enter data using WebApp in AppSheet I do not see the data appear in my google sheet document. 

All the data do appear in the webapp where I can also edit and delete.

Why can't I see the data in my google sheets?

If I remove my ID column --> regenerate scheme --> tick rownumber  as key..........I can see the data in google sheets.

[robbertzalm · Accepted solution]

Looks solved by creating a new google sheet with the same headers.

Now it works flawless.

Previous sheet came from an exported My SQL csv file into Excel.