Push button window close

[Former Member]

Hello,

I am trying to put a push button to close the window. I am able to open the window, but not close with the push button.

This is what i have done -

I have a push button, on click this will bring up two pie charts in a canvas container with a background. Inside the background i kept my close (push button) to close the canvas and background with chart.

The background is connected to a cell in excel A3 and i have two other cells with 1 and 0. All the components with dynamic visibility A3 matches 1 pops up the window with the containers.

How to make this work by disappearing the window by clicking the close button?

Appreciate your help.

Thanks,

Arun

[Former Member · Accepted solution]

Hi Arun,

Try checking the attached xlf file. Update the extension .txt to .xlf and check.

Taken sample data as example.

Hope this helps.

Thanks,

Uday.

Dynamic View.txt.zip

[Former Member · Accepted solution]

Thanks Uday,

Though my requirement was slightly different, i modified your code to modify it. Its working!!

Arun

[Former Member · Accepted solution]

That's Cool !!!

[former_member190855]

Hi Arun

Is the Close push button a separate button than the Open?

If your open and close button can be placed at the same position then try with Toggle button so that depending on on and off it sends two separate value to the same cell. After that you can easily set the dynamic visibility of the components and background you want to appear and disappear.

Runali

[Former Member]

Thanks Runali, able to fix it.

Arun

[former_member190855]

Cool!

[Former Member]

Hi,

But i am faced with another challenge, all my components are refresh on load. Hence the pop up window opens on first view in dashboard in launch pad. Any way to avoid this i need to open only on click.

Arun

[former_member190855]

Set the default value in excel with the value corresponding to close.

[Former Member]

Could you explain little more? Default value in excel you mean the Trigger cell for Refresh on Trigger field?

[former_member190855]

Sure.

I am assuming you have two PBs 1) to Open 2) To close

Each has a destination and I believe they are same cell say A1. So for example, Open button drops 1 to A1 and Close sends 0 to A1. The DV of the popup background and charts are set to A1 and 1.

What I mean in my previous post is type 0 in A1 as default value so that the popups dont show up unless you click the Open button.

If this is not the case please elaborate your current design.

Runali

[Former Member]

That works.

Thanks,
Arun