Create app with multiple tables based in one google sheet

It's me again hehe, now  i want to know if there is a way to create an app with different views getting the data from an unique sheet with a lot of tables and delimit them wherever i want. I attach a screenshoot to you to understand me well. I have this sheet and I want to generate several views from it.

There is a way to do this? 

SistemasK_0-1673358813118.png

 

Solved Solved
0 5 2,664
1 ACCEPTED SOLUTION

You can create multiple views from a single app table. However, you cannot create multiple app tables from a single worksheet. Within your spreadsheet, you could replicate the various tables from your screenshot into separate sheets and then add each as an app table. If the smaller tables in your worksheet are aggregations of the data in the large table in your worksheet, consider instead performing the aggregation within the app itself.

View solution in original post

5 REPLIES 5

You can create multiple views from a single app table. However, you cannot create multiple app tables from a single worksheet. Within your spreadsheet, you could replicate the various tables from your screenshot into separate sheets and then add each as an app table. If the smaller tables in your worksheet are aggregations of the data in the large table in your worksheet, consider instead performing the aggregation within the app itself.

Hello dbaum, thanks you!! I understand that I can't create multiple tables based in one google sheet, so I'm going to create them separately. Thank you so much !! I'm learning a lot here!


@dbaum wrote:

However, you cannot create multiple app tables from a single worksheet


I just want to be sure that terminology is not confusing for new comers.  Depending on who you ask "worksheet" might refer to the entire file or just a single tab.  So to clarify...

  • Single File is commonly referred to "workbook" or "spreadsheet".
  • Single Tab is referred to as "tab", "sheet" or "worksheet"
  • One table per "tab".
  • A "spreadsheet" can have several "tabs" and therefore several associated tables in an app.

Thank you for the explanation Willow! I understand that, I have a spreadsheet with multiple tabs now, but i wanted to have a spreadsheet with an unique tab and inside that the multiple tables. 

Understood.  I just wanted terminology to be clear for you or anyone else reading the prior comments in the future, that "worksheet" was referring to a single tab.  I have seen many post where "sheet" or "worksheet" was referring to the File - a set of tabs.  In this context I felt it important enough to clarify.

Top Labels in this Space