Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Button help

Hi,

I am trying to create a show/hide button.  I understand I need to create a Set Variable for this......but how do I do that??

Thank you

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

1) Create a variable vSHOW and set value as 1 (CTRL + ALT + V)

2) Now create a button and write below in text

     =IF($(vSHOW)=1, 'HIDE','SHOW')

3) go to Action field and click add >> External >> Set Variable

     Variable vSHOW

     Value =if(vSHOW = 1, 0,1)

4) Now go to specific object or chart >> Layout Tab >> Show >> Conditional >> vSHOW = 1

View solution in original post

5 Replies
MK_QSL
MVP
MVP

Like This?

Not applicable
Author

Exactly what I want, but how do I get the Set Variable in the Actions tab?

Not applicable
Author

Ignore that, just found it!!

Thank you. 

MK_QSL
MVP
MVP

1) Create a variable vSHOW and set value as 1 (CTRL + ALT + V)

2) Now create a button and write below in text

     =IF($(vSHOW)=1, 'HIDE','SHOW')

3) go to Action field and click add >> External >> Set Variable

     Variable vSHOW

     Value =if(vSHOW = 1, 0,1)

4) Now go to specific object or chart >> Layout Tab >> Show >> Conditional >> vSHOW = 1

MK_QSL
MVP
MVP

Please close this thread by selecting correct answer if your requirement satisfied.