Table not found

[tvinci]

The backend is working. Why am I receiving this error?

Thanks.

[Arthur_Rallu]

Can you give us a little bit more information?

1. Where are you tables set up (in the backend)? Spreadsheet on Google Drive, DataBase on the cloud?
2. Do you get any error message in the Editor?
3. How are the tables defined in the Editor?

[tvinci]

1. Google Sheets
2. The editor is fine
3. Routes and Clipboard have a parent-child relationship. (I believe this is what you were asking.)

[tvinci]

If you would like to check yourself it is Clipboard 11. I can add you as a user if you like because I have a users table that grants users different permissions. You may not be able to replicate the error if I don’t add you as a user.

Thank you.

[Arthur_Rallu]

A couple of things to check:

1. Is access to the spreadsheet specified as “as app user” or “as app creator”? (Ref: https://help.appsheet.com/en/articles/962142-access-mode-as-app-creator-or-app-user)
2. When you go to the Editor, select one of the tables in Data > Tables and click “View Source”, are you able to open and see the spreadsheet properly?

[tvinci]

1. App Creator, but the problem persists when I switch to App User. I have tried.
2. Yes

[Arthur_Rallu]

1. Can you check the audit logs and see if you get any errors there? (Ref: https://help.appsheet.com/en/articles/975998-audit-history-log)
2. If you press F12 or Function+F12, a console will open; what error messages do you see there?

[tvinci]

I discovered the reason for the bug and fixed it.

The reason for the bug is that the emulator was confused as to whether to access the Spreadsheet as the email address specified in the emulator or the email address linked to my account.

I think this is a bug in AppSheet.

[Arthur_Rallu]

Hey Tiffany,
Can you clarify? Were you trying to preview the app in the emulator using an email address different from the one you set up for your AppSheet account?

[tvinci]

So I have a users table in my app that specifies users email addresses and their permissions in the app. I wanted to test the app so I designated myself in the table as a user with limited permissions. But AppSheet knows I’m the creator. So when I tried to use the emulator with limited permissions it didn’t work.

I worked with @Aleksi on discovering the bug.