Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I had a muti box conenction with values (postpaid, prepaid).
On the selection of 'prepaid', sheet1 should be activated and on selection of 'postpaid' sheet 2 should be activated.
can anyone suggest me how can i achieve this?
Hi,
You can achieve this by writing field Event triggers.
Go to Properties-Document Settings-Triggers-Field Event Triggers.
Then on The required field add an action :
Action Type : Layout
Action : Activate Sheet
Here give the sheet id which you want to activate.
Hope this helps!
Hi,
You can achieve this by writing field Event triggers.
Go to Properties-Document Settings-Triggers-Field Event Triggers.
Then on The required field add an action :
Action Type : Layout
Action : Activate Sheet
Here give the sheet id which you want to activate.
Hope this helps!
Hi,
PFA......... Hope it is helpful for you.........
Regards,
Nirmal.
hi...
go to sheet1 then right click the mouse and select properties
then in the general tab , in the show sheet select conditional
in the condition box insert match(getfieldselections(Field1),'postpaid')>0
where Field1 is the field in your multibox
for sheet 2 insert the condition match(getfieldselections(Field1),'postpaid')>0
Hii
PFA
PFA. Using a trigger.
Hi,
Go to the Sheet1 properties->General->Conditional->In expression write =values='prepaid'
Go to the Sheet2 properties->General->Conditional->In expression write =values='postpaid'
Hi Kausalya,
Try this.
Regards,
Tom