How to go layout if last character of find number is 2?

[mmonsalveg]

Hello ,

I would like to know how to set my script to go to specific layout if the last character of the field that im searching is 2?

example:

if im searching for " 2245-2" ... go to layout "2"

if im searching for " 4587-3" .... go to layout " 3"

hope you understand,

thanks for your help.

mauricio

[doughemi]

If[Right(YourSearchField;1) = 2

Go to Layout("2")

Else If (Right(YourSearchField; 1) = 3

Go to Layout"3")

End If

[Vaughan]

Your best bet is to use onRecordLoad script trigger to run a script that changes to the layout whenever the record changes (in browse mode). The script would be what doughemi posted above.

Then, whenever the records are viewed the correct layout will be displayed *as you browse through them* automatically. This includes as they are viewed after a find.

Having said that, why need separate layouts for something like this?

[LaRetta]

You can also just use one script step in the OnRecordLoad trigger attached to the layout of:

Go To Layout [ by calculation ; Right ( yourSearchField ; 1 )