Connect multiple spreadsheet to appsheet with user specific

[Sujay24]

Hi all , 

I am pretty new to appsheet and working on creating app , that takes multiple spreadsheet data.

each spreadsheet is associated with each user  , inam trying to link sheet and user using 

USEREMAIL = "hard-coded email I'd"

The issue I am facing is , when i change the one user to other. 

The table content remains same , to change that need to click on icon of different user.

How to solve this issue or am I doing anything wrong.

Thanks in advance 

[AleksiAlkio · Accepted solution]

Better option would be to have only one table and filter the data depending on the user's email. Please check this article how to do that.. https://support.google.com/appsheet/answer/10104977?sjid=5520674034602329462-EU