Creating one view with multiple sheets

I want to create one view with two different excel sheets. Is it possible.
Process which I want to set up:-
I have 3 different excel sheets - 1)Worker Personal Information (Worker Name, Contact Number, Email Id), 2)Assigned Product List (Staff Name, Product Details), 3)Alteration Sheet (Staff Name, Alteration or Mistakes made by staff)
So I want to create 2 views first when I am clicking on worker name then worker details will open by combining 2nd and 3rd excels. 

0 2 578
2 REPLIES 2

In a single app, you can indeed create multiple tables each based on a separate data source, including separate spreadsheet files or separate sheets within a single spreadsheet file.

You can likely accomplish your goal by creating necessary References between tables - AppSheet Help. Include a User ID column in every table. In tables #2 and #3, make that column a Ref type column based on the corresponding column in table #1. If each row in table #3 corresponds to a single row in table #2, then also include, say, a Product ID column in tables #2 and #3, with the column in table #3 a Ref type column based on the corresponding column in table #2.

Steve
Platinum 4
Platinum 4
Top Labels in this Space