Hi! I'm new to QV, so any help you can provide is greatly appreciated. I currently have a document with 5 sheets. The first sheet forces the user to select one or more of three fields. I want to hide the remaining 4 sheets in the document until at least one of the fields has a value set in the first sheet.
I am trying to accomplish this by doing the following: hide the remaining 4 sheets by setting "Document Setting" -> "Sheet Properties" -> "Show sheet" -> "Conditional"=0. Then I am setting a trigger when a selection is made on the field: "<field-name" -> "On select" -> "Add" -> "Activate Sheet" -> "<sheet-id>".
But this isn't working. I am assuming this is becuase "activate sheet" is not the intended action, but it is the closest action I could find to what I wnated to do. Can somebody please help me?
Thank you for the prompt response, shree909. But I want this to be seamless and transparent to the user, which is why I am leaning towards using triggers.
To show only the specific sheets, You can create some buttons in the home page and give one variable and give values to different sheets. I have attached the document with home page sheet, and four other sheets . Hope it helps you .
