Merge multiple menu views

[Kooiker]

Hello,

I have multiple months with massive data in my menu view. But i want to merge them with a year.
How can i make a "button" 2022 wich is folding out and i see all the months?

[jyothis_m · Accepted solution]

Got it. In that case you can

OPTION 1: create a Dashboard view which includes all these separate views

OPTION 2: Create another Sheet Say MENU with Columns [YEAR] [VIEW] [VIEW NAME] as below and make use of ACTION - Navigate to another view in the app

Please see the sample app i have created below

Sample-4 MENU NAVIGATION - AppSheet

NOTE : all sub views in sample app are dummy (blank Dashboard View). It will show the actual view accordingly in your app.

[jyothis_m]

Try this. YEAR instead of NAME

[Kooiker]

This is what i have now, that are all different tabs in my spreadsheet.
But i want to make a "button" for the year 2022. And if i click on 2022 that all this tabs appear.

I hope you understand what i mean.

[jyothis_m · Accepted solution]

Got it. In that case you can

OPTION 1: create a Dashboard view which includes all these separate views

OPTION 2: Create another Sheet Say MENU with Columns [YEAR] [VIEW] [VIEW NAME] as below and make use of ACTION - Navigate to another view in the app

Please see the sample app i have created below

Sample-4 MENU NAVIGATION - AppSheet

NOTE : all sub views in sample app are dummy (blank Dashboard View). It will show the actual view accordingly in your app.

[Kooiker]

Thank you so much.
I made the same menu as you, and now I want that if I click on the month feb he opens a tab from an other spreadsheet and shows me all the data I have there. Now i only see the details of my new menu spreadsheet.

 

[jyothis_m]

Have you selected the Action when Clicked in the Card View. You have to select the Action to navigate to another view. You can see it in the sample app.

[Kooiker]

The only thing I can choose there is go to details.

[jyothis_m]

 

[Kooiker]

Hello, I'm sorry for 1 more question.
Now I can navigate to an other sheet tab, but every month of the year that I choose navigates to the same sheet tab. Is it possible to navigate every month to an other sheet tab?
I hope you understand what i mean.

[jyothis_m]

Sorry i didn't understand it fully. Can you help me with some screenshots.

[Kooiker]

Sure, this is my menu

     

And every month I choose here, I see the same data from an other sheet.
What I want is, every month I choose, I want to see the data from different tabs.

I have this settings.

 

 And this is my menu spreadsheet

 And this is the spreadsheet with data with the tabs I want to see.

 

[jyothis_m · Accepted solution]

Create a Single Action for the MENU Table alone. No need to create ACTION for each Sheet.

Give LINKTOVIEW([VIEW NAME])

This will navigate to the corresponding VIEW based on the ROW clicked in MENU Table