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?
Solved! Go to 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.
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
Try this. YEAR instead of NAME
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.
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.
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.
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.
The only thing I can choose there is go to details.
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.
Sorry i didn't understand it fully. Can you help me with some screenshots.
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.
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
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |