Published: 29 Sep 2020 Last Modified Date: 14 Oct 2020
How to create buttons to swap sheets. Example: Buttons for swapping sheets between profit and sales
1) Create calculated fields with Strings for buttons. Example: Sales Button : "Sales" and Profit Button: "Profit" 2) Create two placeholder calculated fields as discrete and dimension as following: zero: 0 and One: 1 3) On an new sheet, Sales Button drag Sales Button, zero and one to Details on Marks Card 4) On an new sheet, Profit Button drag Profit Button, zero and one to Details on Marks Card 5) Makes Sales and Profit sheet as desired 6) Add the Sales Button and Profit Button to dashboard 7) Add a Horizontal/Vertical Layout container. Add Sales and Profit sheet to thisLayout container until a dark blue thick line appears 8) Hide the Titles of Sales and Profit sheet 9) Configure four actions as below:
Clicking on the button will get the respective sheet in the bottom view
Thank you for providing your feedback on the effectiveness of the article.