Layout specific calculation

[HunterBoss]

All

I'm not sure if I've got a problem or I'm just panicking.

I have a layout called "Sorted." I have a specific sort script that I only use on this layout.

The table associated with the layout "Sorted" has 3 calculated fields that return values dependent upon the sort results.

My problem/question is what happens when I go to other layouts?

I'm never going to use the sort script I associate with the layout "Sorted" on other layouts. But, other layouts will be sorted based upon different criteria.

So, is there a way to have a calculation only "work" (I'm sure that's the wrong phrase) or calculate based on the layout it is on?

I want it to remember the values from the sort on Sorted when I go to a different layout and not recalculate them.

I know I can do a script to set the calculated values into an additional field. I was hoping to be able to accomplish this without that.

Possible?

Thanks

Christopher

[comment]

calculated fields that return values dependent upon the sort results.

Such as?

[HunterBoss]

Calculated Field 1 is the client ID number if that record is the most recent active record for that client

Calculated Field 2 is the record ID number if that record is active for that client

So, on other layouts I may sort by phone number or state or city or county, etc. I need Calculated Fields 1 & 2 not change.

This help?

[comment]

Calculated Field 1 is the client ID number if that record is the most recent active record for that client

Such calculation does not need to depend on the current sort order - and probably shouldn't.

Not sure what this would be useful for, though.

[HunterBoss]

comment

That's not true. There are multiple records for multiple transactions in the table. When ever a transaction is edited new record is made. I'm not the source of the data. I use what's sent to me. I need to find out which is the most recent record for different types of fields. Without the sort order there's no way that I know of to find the most recent record(s).

So, that being said, I do appreciate your responses, but is there a way to have a calculation that is layout dependent? Fields are only updated/valued/calculated/whatever when a specific layout is active?

Christopher

[comment]

Without the sort order there's no way that I know of to find the most recent record(s).

Do they have a date field?

[HunterBoss]

yes

[Vaughan]

Fields are only updated/valued/calculated/whatever when a specific layout is active?

Make the calculation unstored, and only display it on the layouts you want to use it on.

[comment]

See if this helps:

MostRecent.zip