Any advice for a newbie using AirTable as a data source? When adding an AirTable base as a table source, I get errors in AppSheet saying that the “_RowNumber” column isn’t good as a key. Seems that would make sense to use the row number in AirTable, but AppSheet doesn’t want me to do that.
If you do not specify a key, and AppSheet cannot automatically find a good key, AppSheet will default to using the worksheet row number as the key. The row number is not a good key. If entries are moved or deleted, or if users add or delete entries simultaneously, the row number for each row will change and there is no way for AppSheet to uniquely identify the row. The Editor will give a warning if row number is chosen as the key.