I have a database table with a key column. Ev...

[Pim_Sauter]

I have a database table with a key column. Every time I regenerate the columns (even when I don’t make any changes to the column structure), AppSheet will un-check the ‘key’ box, and make a column ‘ComputedKey’

Also, in general, is there a way to disable AppSheet automatically making virtual columns?

[Pim_Sauter]

I am using the Postgres connector by the way

[Simon_Robinson]

Maybe that column is not unique in some way.

Try creating a TEXT column with an App Formula of UniqueID() and use that as the Key

[Pim_Sauter]

I am already using UniqueID() in that column

[Simon_Robinson]

@Pim_Sauter As an initial value?

Also i’d check the values in that column to make sure they are all unique.

[Pim_Sauter]

Yes, as initial value; and all entries are unique. Don’t know what’s going on here