Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Here is the scenario. I am having two sheets (Home & Trans) which is defined with two unique alternate states.
When user do the selections and clicks "Home" or "Trans" button the selections needs to be transferred to other sheets as well.
Attached the sample applications.
Note:
I dont want to use the "Triggers" on the "selections". Looking for the solution by using variable.
-Jay
If selection is impacting on both sheet/tabs objects, then why Alternate States are there ?
May be I am missing somewhere.
Hi Mayuresh,
That is my issue/requirement. Though it is same name I cant use it.It is kind of "One day data" against "History Data".
Thats why we moved for alternate state.
Do you want to provide like below ?
Suppose Year List box in Home sheet having values like 2012,2013,2014,2015 with Selection 2014
and Year List Box in Trans sheet showing Years other than 2014.
try like this...
instead of applying alternate states to entire sheet, apply the alternate states to charts only not for list boxes.
No, in Trans sheet also I need to have 2014 to be selected.
Hi Pradeep,
Thank you for your reply. In this case how to transfer the selections? Any way i cant link columns which is in both sheets.
Copy Selections from one field to another
Can you briefly explain your requirement with sheet object and filters/list boxes on both sheet ?
Provide screenshot of application UI.
May be you can try with Select in Field Actions.
I just created only for ID and ID_T
Check the Attachment..
