Triggers Question.

[MuraliPrasath]

Hi,

How to do force selection field on particular sheet? When the user clicks on sheet then the particular field (Approved) should select by default.

Need Help?

[sushil353]

Hi,

You can use sheet based trigger:

Go to Settings> sheet property > Triggers> OnActivateSheet> Action Type (Selection )> Select in field

HTH

sushil

[Kushal_Chawda]

like this

Go to that sheet->sheet properties-> Add action-> Select in Field

[tresesco]

Right click on the sheet->Properties->OnActivateSheet->Actions->Selection->Select in field ...

[ToniKautto]

I just want to add to the above OnActivate trigger advise that selections are made in the data model, so even if the selection is made on a sheet if will affect all objects int he application.

[MuraliPrasath]

It's not working guys. It is correct ?

[MuraliPrasath]

Hi Toni,

I just want the selection on only one sheet. How to achieve this?

[avinashelite]

please find the attachment for the solution

[tresesco]

Field name should be - ShipmentStatus

and Search String - COMPLETED

[MuraliPrasath]

Hi Avinash,

This is affecting all other sheets also. It should apply only one sheet. Help me?