I have this little app for which data was coming from SmartSheet. As I was having issues the the ID in my source data, I built my app in AppSheet using _Rownumber as key. Now that my data is fixed, ID added (I tried as ref and as number), I can change for ID as key and save, but whenever I try to make my last version the stable on, the app cannot load anynore, ans after a refredh I get this error "Column Name 'CG1' in Schema 'Photos_Schema' refers to ReferencedTableName 'Torquage'. That Table or Slice uses RowNumber as a key which is not a stable key." What am I doing wrong?
It appears that the column CG1 of the Photos table is of type Ref and refers to the Torquage table, and that the Torquage table uses the _RowNumber column as its key column. Use of _RowNumber as key is not recommended. It appears the app editor prohibits you from creating a Ref to _RowNumber, so you will need to find another way to accomplish what you want. I would strongly encourage you to implement your key columns using something other than _RowNumber.
User | Count |
---|---|
18 | |
10 | |
8 | |
6 | |
5 |