OnActivate Sheet Event Triggers - I give up! :(

[#1]

Hi All

Either I am misunderstanding the purpose of this or I have not stumbled across the correct syntax yet.

I have two sheets (labelled Fire and Medical).

I have a Field labelled EMERGENCY containing only two values (possible values Fire or Medical).

When I select the Fire sheet I want the value Fire in the EMERGENCY field to be selected by default (which would clear the value of Medical) and when I switch to the Medical sheet I want the value Medical in the EMERGENCY field to be selected (which would clear the value of Fire).

So far I have gone to Sheet Properties | Triggers | Sheet Event Trigger | OnActivateSheet | Add Action(s)

I have added the action 'Select in Field'

Under Field I have =EMERGENCY

Under Search String Medical

I have tried 'Medical' and "Medical" and various other things I can't recall.  The HELP is less than helpful with regard to examples of Search String syntax etc.

Many thanks

Oli

[Anonymous]

Type this:

in Field -->  EMERGENCY

in search string -->  ='Medical'

and so on for the other sheet.

Marc.

[aveeeeeee7en]

Hi

You are doing it the Right way. If possible, kindly share the Application with reduced data.

Regards

Av7eN

[aveeeeeee7en]

Hi

Are you using 'Clear All' Trigger After Emergency - 'Medical' Trigger.

If so, than Promote your 'Clear All' Trigger.

Regards

Av7eN

[#5]

Hi

Here is my test version.

Thanks

Oli

[simenkg · Accepted solution]

In Field you should not have = first.

The '=' will tell the text input to evaluate the field value of the following field.

Just put EMERGENCY without the = and i should work.

[#7]

Hi Simen

What a 'school boy' error!!  I could kick myself.

I did have the '=' in the search string at one point, but I guess combined with the '=' in the field it stopped it working....

Thanks again.

Oli