Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

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

Posted

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?

Posted

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.

Posted

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

Posted

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.

This topic is 4882 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
×
×
  • Create New...

Important Information

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