I am creating an app that is pulling multiple...

(Tom Galland) #1

I am creating an app that is pulling multiple google sheets data so we can view them all in one place. But I am struggling with one thing, I want to put the sheets into sub categories to organise them all.

Example: Department Name > Day of the week > Google Sheet that shows meetings for that day

Is this possible?

Hope you can help!

(Aleksi Alkio) #2

You can group the table view more than once. First group the view with Department Name field and then with the Day of the week field.

(Tom Galland) #3

@Aleksi_Alkio Can you tell me how to do that?

(Praveen Seshadri (AppSheet)) #4

@Tom_Galland, you might be saying one of two things:

a) you want the app to show the data grouped by Department name -> Day of week. I think this is what Aleksi assumes you meant. If so, you can use the grouping option in the Table view to achieve this b) you have data sitting in different sheets by day of the week and department. you want the app to aggregate and show all these different sheets as though they were one sheet. I suspect this is what you mean. If so, this is not a suitable data representation for AppSheet. The system does not union/aggregate a large number of distinct sheets and treat them like a single set of data. I would advocate merging all of these into a single sheet with extra columns for Department name and Day.