Implicit (RowNumber) key

AppSheet AppSheet Q&A
1

hello friends,

i have two issues.

  1. Table ‘test’ has an implicit (RowNumber) key – if multiple users insert or delete entries concurrently, data loss can occur.
  2. in another case i have no errors or orange remarks, but when I try to enter the app on my phone, i get the massage “worksheet scheme is expected to contain 7 columns, but 5 columns are actually present”
    even that all seems ok, and on the desktop there is no error massage.
    also on the phone app, the massage refers to the Spreadsheet name, but added a dash and a number (-12345).
    if I hit cancel, I can enter the app.
    but I cannot synchronise.

any suggestions?

Regards,
Harold.

2

Harold_Iliya:

  1. Table ‘test’ has an implicit (RowNumber) key – if multiple users insert or delete entries concurrently, data loss can occur.

Your Test table’s key column is set as _RowNumber. Advise reading this for assigning keys to tables:

Harold_Iliya:

  1. in another case i have no errors or orange remarks, but when I try to enter the app on my phone, i get the massage “worksheet scheme is expected to contain 7 columns, but 5 columns are actually present”> even that all seems ok, and on the desktop there is no error massage.> also on the phone app, the massage refers to the Spreadsheet name, but added a dash and a number (-12345).> if I hit cancel, I can enter the app.> but I cannot synchronise.

Please check the following:
(1) One of your tables have 5 columns in the gSheet but the column structure in the app counts 7. Locate that table in the app editor and hit Regenerate Structure button in the Column Structure header

2X_f_f78708cdb26c8c64f4caea12545de5e32b680385.png

(2) Ensure in your gSheet back-end that there is no any data other than the columns that are in the app. May be remind you that provided you put some manual calculations, texts etc. anywhere in the gSheet out of the table-schema boundary, AppSheet will try to interpret them as column data and issue the above error

1 Like