Help on Button?

[dmohanty]

Hi All,

I need some help in Buttons.

Requirement:

• First Home page should have 3 Buttons. If I click on any one button, the required sheet will be activated (I can do)
• But while on First Home page, rest 3 Sheets will be hidden. When Clicked on 1st button, the 1st sheet will be activated along with Home page and rest 2 will be hidden. Similarly for next two buttons and sheets(HOW TO DO THIS?)
• When a sheet is activated, it should have a Button to navigate to Main page back (I can do)
• But when the main page is displayed again, all the next sheets again go back to hidden (HOW TO DO THIS?)

Can anyone show me a sample example on this? Or any better alternate way to do this?

Regards!!!

[#2 · Accepted solution]

Hi

PFA sample QVW.

Hope this helps.

Thanks

Sabal

[maxgro]

- define a variable vshow (0 = show main,1 = show first sheet, .....)

- in every sheet go to General --> Show sheet --> Conditional and add an expression

=$(vShow)=0          (this is for main, adapt to other sheets)

- add the buttons with action as image

see attachment

[dmohanty]

Thanks a ton Sabal for this quick help. Its really appreciated. I got the concept!!!

[dmohanty]

Thanks a ton Massimo for this explanation!!!.

Its really appreciated. I learnt the concept.