Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) 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
Like This?
Exactly what I want, but how do I get the Set Variable in the Actions tab?
Ignore that, just found it!!
Thank you.
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
Please close this thread by selecting correct answer if your requirement satisfied.