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?
I am using the Postgres connector by the way
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
I am already using UniqueID() in that column
@Pim_Sauter As an initial value?
Also i’d check the values in that column to make sure they are all unique.
Yes, as initial value; and all entries are unique. Don’t know what’s going on here
User | Count |
---|---|
43 | |
29 | |
23 | |
21 | |
13 |