Sheet Navigation , Alternate state issue

[thimma_paul]

Hi,

I have 2 sheets and in sheet 1 , I have a multi box without alternate state, and in sheet 2 , I have a multi box with alternate state.

so, if user select a value Multibox obj in  sheet 1 , then in sheet 2 multibox should also select same value.

if value not available in second multibox, it should select default value as 1 'Lat Amer.'

We need to implement this, please suggest..

Sheet 1 WRLD_RGN1 used for multibox

LOAD * INLINE [
WRLD_RGN1, Value1
Lat.Amer, 1
N.Amer, 2
Caribbean, 3
Africa, 4
E.Eur, 5
Europe,6
MiddleEast, 7
Oceania, 8
Supra, 9
Asia, 10
OffShore, 11
India, 12
];

sheet 2 WRLD_RGN2 used for multibox

Region1:

Region2:
LOAD * INLINE [
WRLD_RGN2, Value2
Lat.Amer, 1
N.Amer, 2
Caribbean, 3
Europe,6
MiddleEast, 7
Oceania, 8
OffShore, 11
];

[dplr-rn]

You will need to use triggers and actions

e.g.

on select or on change of WRLD_RGN1 add action with the alternate state Select in field for WRLD_RGN2

[thimma_paul]

Yeah, in this we need to set to default when value unmatched, there I am facing issue

[uacg0009]

Hi Thimma,

Please try to use below expression in the trigger search string:

=If(Match(WRLD_RGN2,GetFieldSelections(WRLD_RGN1)) > 0,WRLD_RGN1,'Lat.Amer')

Aiolos

[dplr-rn]

What's your expression currently?

[thimma_paul]

Currently I am using getfieldselections function and is working foratched case

[thimma_paul]

Match case is fine, for uatch case I am working with Aiolos suggestion

[dplr-rn]

Great mark and close the thread if it does work

[thimma_paul]

Yes. working fine. and Thanks.