Hello! I have a problem. I am trying to chang...

(Дмитрий Николайчук) #1

Hello! I have a problem. I am trying to change key column. Adding new virtual column with app formula =UNIQUEID(), selekt key row and deselect key roe on _RowNumber column. But after saving _RowNumber again as key column… How can I fix that? The main problem is that I can not add events in my table, there is a mistake “There is already a row with the key ‘2’”


Hi I may be wrong but I don’t think you can use a virtual column for your key. You need to add a new column to your sheet for the UNIQUEID or select


diff column or columns (you can use two) as the key. Check out the documentation here. help.appsheet.com - What is a Key? What is a Key? help.appsheet.com

(Steven Coile) #3

@Lynn Virtual columns can be key columns.

(Steven Coile) #4

The problem here is that a virtual column’s App formula value is recomputed at least every time the app is synced. The UNIQUEID() function will produce a different value each time it’s recomputed. Consequently, the value is “unstable” (i.e changing), and cannot be used as a key.

(Steven Coile) #5

To accomplish your goal, you need to add a column to your spreadsheet in which the key will be stored for each row. A good way to do this is to copy whatever spreadsheet column is currently the key column into a new column and give the new column a new name. Then go into the AppSheet workbench and Regenerate the columns for the corresponding table, to make AppSheet aware of the new spreadsheet column. Once regenerated, mark the new column as KEY and unmark the previous one. SAVE.