Jump to content

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.

Link to comment
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?

Link to comment
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.

Thanks for the quick reply!

Link to comment
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.