HunterBoss Posted September 8, 2011 Posted September 8, 2011 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 Posted September 8, 2011 Posted September 8, 2011 calculated fields that return values dependent upon the sort results. Such as?
HunterBoss Posted September 8, 2011 Author Posted September 8, 2011 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 Posted September 8, 2011 Posted September 8, 2011 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 Posted September 8, 2011 Author Posted September 8, 2011 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 Posted September 8, 2011 Posted September 8, 2011 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?
Vaughan Posted September 8, 2011 Posted September 8, 2011 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.
Recommended Posts
This topic is 5073 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 accountSign in
Already have an account? Sign in here.
Sign In Now