Automatically click another button in another sheet when a button on the main sheet is clicked. How to do it ?

[#1]

Hi,

Attached is a sample dashboard.

In the Main sheet there is a button, clicking on which takes us to the next sheet.

The next sheet has button and a text box conditonally hidden. The text box appears on click of the button.

What i'm trying to acheiving is that when the button on the "Main" sheet is clicked it has to go to the next sheet and automatically click the button present in it and enable the text box instead of the user having to click the button in 2nd sheet again. How can this be done.

Thanks

Padmanabhan

[senpradip007]

Hi

PFA. Hope it will help you.

[#3]

Hi Pradip,

Thanks for the help. Actually I dont want the variable to be set in first button click. I just created the sample , to explain the problem. What i want is , the second button must get clicked automatically when the fist button is clicked.

[#4]

PS: I created the varibale just to explain the problem. What i'm looking to acheive is that the second button must get clicked automatically on the first button click. It is the only problem. My aim is not to set the variable and therefore show the text box.

[#5]

Hi Padmanabhan,

You Can add a button on the next sheet & give same Object ID as that of Button on First Sheet. & add any desirable action you want to set there on newly created button.

Please find attached file for the same.

-Regards,

Kiran

[#6]

Hi Kiran,

Thanks for the solution. I tried using same object IDs. But the problem in my dashboard is that the second button is not actually a button. It is text box with actions added to it. PFA.

My aim is not to set the variable and make the text appear. My aim is that the text box(which is also the button) in the second sheet must also get clicked when the big button in the main sheet is click.

PFA the modified sample.

Thanks,

Padmanabhan

[#7]

Hi Vali,

I am not able to see any attachments.

[#8]

Hi Padmanabhan ,

If U Set same variable in Actions for It will Automatically get Clicked.

Getting Clicked is nothing but  Actions to be performed.

If U want to be Action Performed in Second sheet text object by clicking on First sheet Button . U need set same actions for both..

I think U will get it.

Regards,

koti Reddy

[#9]

Hi Padmanabhan,

         PFA.

[Anonymous]

Why not use your trigger on activate of sheet 2,

PFA