# Get(LayoutName) calculation in case statement

This topic is 4321 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

Hey guys trying to make a multi purpose hybrid field that changes based on the layout. ( There is 5 different fields that are spread over 10 layouts which would bring 50 calc fields to 5 )

So layout name would dictate what field to show up...

Weird thing is that a simple if statement is working perfectly... But there is ten different layouts.

When I try n put it in a case it doesn't work.

I've even tried simple math logic

Sample

Case(

If (Get ( LayoutName ) = "AprilInvoice" ; 1 ; 0 )=1 ;april text;

If (Get ( LayoutName ) = "MayInvoice" ; 1 ; 0 ) = 1;may text;

)

Maybe I'm overlooking something simple, I've been working at this for 7 hours today...

Regards, Mike.

##### Share on other sites

Try =

Case (

Get ( LayoutName ) = "AprilInvoice" ; april text ;

Get ( LayoutName ) = "MayInvoice" ; may text

)

Are you sure you need a different layout for each month? Couldn't the seasonal text be calculated directly from the invoice's date?

##### Share on other sites

Try =

Case (

Get ( LayoutName ) = "AprilInvoice" ; april text ;

Get ( LayoutName ) = "MayInvoice" ; may text

)

Are you sure you need a different layout for each month? Couldn't the seasonal text be calculated directly from the invoice's date?

Been there; done that... Not sure why but couldn't make that function work with case statement.

But your comment has given me an alternate solution by using a field to set for identifying what invoice is needed and like you suggested would eliminate the need for other layouts just use calc's for everything.

##### Share on other sites

This topic is 4321 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account