Bug: data source Sheets is duplicated and used instead of the selected data source

AppSheet AppSheet Q&A
,
1

Hey,

I got an app with multiple tables in multiple Sheets. I added a new table yesterday, but when I add rows through my AppSheet app, the row is not added to the related data source.

I tried adding the table to an existing Sheets and also to a new Sheets, but got the same behavior:

  • The new table name is “storageNumber”
  • The Sheets ID is “1ssKt_if09FUNq…”, as written in the Table Source id
  • The duplicated Sheets was named NewApp-32785632_storageNumber (_)
  • When I change the table through the app or when I change the duplicated Sheets and sync, the changes are reflected in both ways
  • The original connected source Sheets stays empty when I change the app
  • When I manually add rows to the original source, it’s not reflected in the app
  • If I add/rename columns in the origin and Regenerate the Schema, it’s reflected in the Table configuration

    • Any idea what’s wrong?

    AppSheet table configuration:

    appsheet-bug__datasource-config-in-app
    appsheet-bug__datasource-config-in-app519×680 45 KB

    Expected data source:

    appsheet-bug__selected-datasource
    appsheet-bug__selected-datasource585×351 24.4 KB

    Actual-duplicated data source:

    appsheet-bug__duplicated-used-datasource-for-table
    appsheet-bug__duplicated-used-datasource-for-table678×381 31.1 KB

2

When the original spreadsheet “1ss..” is connected with your app, does it show the row #2 in the app?

3 Likes
3

No, it only shows the rows from the duplicate spreadsheet “1QG…”

I added row #2 to “1ss” manually to see if it’s reflected in the app after sync, but it wasn’t.

1 Like
4

By any chance is the Server caching ON?

3 Likes
5

Yes, it is on. I now turned it off and tried adding/editing a row from the app, but those changes appear only in the duplicate sheet.

I tried the same after regenerating the schema for the table, with the same result…

By the way, thanks for the replies and your time.

1 Like
6

When you have the original spreadsheet connected and you add a new record with the app, is it saved and visible via the app?

3 Likes
7

The table had the Shared setting OFF for some reason. I found this related. topic, which described similar behavior (new spreadsheet created).

I have 30 other tables where Shared is on and I don’t remember ever turning it off… Anyway, it’s working as expected now.

I guess it’s expected with Sharing Off, but in some cases, after adding a new record it wasn’t visible. I think it happened in the app editor and maybe it was stored correctly for the logged in user n the Desktop version or the app.

Thanks for the help!

2 Likes
8

Good to hear!

3 Likes
9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.