Common Field selection in multiple page

[#1]

Hi All,

Need your help to resolve question with regard to field selection.

if i select a particular field say Country= USA in a tab1 (individual page) and go to next tab (different page) also having a country field which is not same as tab 1 lets say its field name is Country1 having similar countries as compared to country field  but the count is less

Is it possible if i select in tab1 country= USA and move to next tab does it automatically select USA

[Agis-Kalogiannis]

Hi Deepak

You can add a trigger to do that:

Document Properties -> Trigger -> Field Event triggers

Select your Country field and click on OnSelect button

Add an action:

Selection, Select in field,

and for Field, select Country1, and for Search String type: =only(Country)

I hope this helps

Agis

ALK

[#3]

Hi Agis,

thanks for your quick suggestion, however i tried the same but unfortunately its not working.

Please suggest me some other alternative

Regards

DD

[oknotsen]

You can also add a trigger on entering a sheet (Sheet properties, Trigger, OnActivateSheet). Put a trigger there that does the same thing Agis described.

[Agis-Kalogiannis]

I've tested it locally and it's working.

Make sure that you are using exactly the same field names as they are case sensitive.

Also, the only() function will work when you select ONLY ONE country.

Can you please tell me the reason you want both these two fields selected?

Are they associated already? Do they refer to a different thing?

[#6]

these two fields are non associated with each other but few countries are common in both hence both are diffrent field. the requirement here is if i select any country in one tab the same country should be filter in other tab.

can you please do the changes in my attached qv file and send it back.

Many thanks for your help

DD

[Agis-Kalogiannis · Accepted solution]

Hi Deepak

Is this what you need?

Triggers do not care if the fields are associated or not.

I hope this helps

Agis

ALK

[#8]

Many Thanks Agis, it works! since i missed to provide action on sheet properties, one more question please

Does it work in reverse way? i  mean it works if i go from tab1 to tab2 thats fine, is it possible if i select from tab2 to tab1

thx,

DD

[Agis-Kalogiannis]

Of course.

You need to do the same and apply the trigger on the other field as well.

Here it is 🙂

[#10]

Superb! Great help Agis

Much appriciated

Thx