ROW ID changed now AS table keep showing warning

AppSheet AppSheet Q&A
1

In my wisdom or idiocy take your enum, I unticked the RowID column as Key column, I was reasoning the timestamp column would make better key column I cans use in Zapier to do a record lookup, lo and behold, Appsheet went nuts with this bright idea of mine, now I am sitting with a constant warning, and it seems I cannot undo my folly

Column ‘Row ID’ of table ‘Weather Data’ is part of a computed key, but was marked ‘ReadOnly’. Since the table allows Adds, key columns cannot be read-only. We turned off the ‘ReadOnly’ option for this column.

It still works, after I set the rowid column as Key again, however it keeps this warning and it seems to ignore any effort of setting rowid as key again

Franco_Austin_0-1742819783130.png
Franco_Austin_0-1742819783130.png1726×567 44.6 KB

Suggestions, I am about to delete the table and start over with it, it is appsheet database table, thinking of converting to to GoogleSheets, fix it and then import again or just build the table again. Advise appreciated

2

A dedicated column for row key is ALWAYS superior - i.e. a dataless key

When you set it as the Key column, did the Editable property enable again? If so, check it to turn it on. Make sure the Required property is also set.

Also, the check the app table properties and make sure it is not marked as read only. The table needs to at least allow adds.

.

1 Like
3

Thanks I tried it, then gave up and just rebuild the table from scratch, gave me the chance to fix some stuff, luckily it is early days with no data and very little else build around the table

1 Like