amgdba Posted November 6, 2007 Share Posted November 6, 2007 THE SITUATION I have a script that changes a value in a related field, which then updates the calced cost value for that record, which then updates an unstored calc in the the current TOG which is equal to SUM(related::cost). The script then checks the the SUM value to make it is greater or equal to zero, else roll back value etc etc. The SUM calc is on the layout the change button is located on. THE PROBLEM: The SUM field is conditionally formatted to turn red when less than zero. If this is on, when the script goes to check the value of the SUM, even though the layout has updated with the correct new number and it has turned red, any reference to that value is the previous value prior to the script execution. When I turn it off, everything runs fine, turn it back on, and it stops working. I looked around a little here but there was no reference I found to this problem. THE QUESTION Has anybody else had this problem and is there an easy fix? Any insight into this would be welcome. Thanks in advance (I know it really not necessary as my scripting should curtail any user from actually generating a negative value, but never the less, the behavior is odd and obviously not a correct one) Link to comment Share on other sites More sharing options...
amgdba Posted November 6, 2007 Author Share Posted November 6, 2007 UPDATE Apparently the switching between layout modes was responsible for the temporary fix to the issue. Now the calculation just doesn't work at all, inspite of its updating the value on the layout. Oh well, back to the drawing board. Thanks in advance for anyones interest, but it would seem I have bigger problems than the formatting (maybe a commit issue). Link to comment Share on other sites More sharing options...
Lee Smith Posted November 6, 2007 Share Posted November 6, 2007 Update your Profile. In the mean time, check that you have the most recent release of the version you are using. Lee Link to comment Share on other sites More sharing options...
amgdba Posted November 6, 2007 Author Share Posted November 6, 2007 Indeed Mr. Smith it would appear there is an updater out there for my copy. I'm going to see what it does for me. Thanks for reminding me of the painfully obvious simple solutions while I was lost in a forest of calcs, scripts, plug-ins, variables, etc. Link to comment Share on other sites More sharing options...
Lee Smith Posted November 6, 2007 Share Posted November 6, 2007 and ... Link to comment Share on other sites More sharing options...
amgdba Posted November 7, 2007 Author Share Posted November 7, 2007 Just nostalgia (and actually started with 3, but I only joined the site circa 5, but then, I don't know what ver of FM was current when this site started). Link to comment Share on other sites More sharing options...
Lee Smith Posted November 7, 2007 Share Posted November 7, 2007 The version reflected in your profile, is not a status symbol, it helps us to determine what Functions can be used in our responses to your questions. My first version was FileMaker 4, by Nashoba Systems. Lee Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6019 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