Uniqueid() is not generating ID code

[Krismar]

Created a new table "Calculations" with columns ID, Item ID, Item name, Quantity. 
Set the ID column as key column with inital value "uniqueid()". 
Created a table style view of the table, when going to the view in the app, the result is "no items".

[Marc_Dillon · Accepted solution]

Are you expecting it to retroactively generate the ids for existing records? Because it won't.

[Krismar]

Ok it will only generate code if i add a new row and it has to be done in the app not directly in sheets. 

Generated the IDs manually with RANDBETWEEN formula but every time I edit/add something in the table the IDs get renewed.
I have the ID column set as "editable" so it should not have any problems but still wondering if it's good that way.

[Marc_Dillon]

No, it most definitely is not good for the id value to change.

[Krismar]

Thank you!