Script for conditional Layout Use

[IplayWoW]

So, I'm trying to use a script that triggers a printable layout... But I want to use a different layout depending on the input of an "identity" in a field (One layout is in Spanish and one is in English).

Field name for Identity: "Identity"

So: If "Identity 1"; use Layout1

: If "Identity 2"; use Layout2

But I'm having some problems with the 12th Line.

I have attached a picture of the script. Sorry, I was too lazy to type it out.

Thanks for any help

[Fitch]

After you GTRR,

If( Identity = 1)

     Go to layout1

       Else

     Go to layout2

 End If

Is there more to it than that?

[IplayWoW]

How is this supposed to look then?

Go to Related Records

If( Identity = 1)

     Go to layout1

       Else

     Go to layout2

 End If 

Perform Script ["Sort and......"]

And then continue with the rest of the script?

Edited July 24, 2009 by Guest

[Fitch]

Yes, I presume both layouts are based on the same Table Occurrence, so your sorting scripts should work on both layouts.

[IplayWoW]

Let me give it a shot.

Thanks Fitch, I appreciate the help

[IplayWoW]

Hey Fitch,

Just wanted to let you know I finally got the script to work. I had to tinker around with it a little bit but I finally got it to work with your help.

I had some external layouts coming into play so I had to repeat the Go To Related Records twice within the If/Else statements.

It looked like this

If 

Go to Related Record [show only related records; From table: "QuoteLineItems"; Using Layout "Quotation 1" (QuoteLineItems)] Else Go to Related Record [show only related records; From table: "QuoteLineItems"; Using Layout "Quotation 2" (QuoteLineItems)] End if

Once again, thanks for your help!