Jump to content
Sign in to follow this  
cartographer

Equation not autoupdating

Recommended Posts

For some reason, this equation only autoupdates,

when I select the field in question, or close and reopen the Filemaker document:

If(index>1;If(index+skip ≠ index; GetNthRecord ( addtoindex; Get(RecordNumber)-1 )+skip;GetNthRecord ( addtoindex; Get(RecordNumber)-1 )+1);index+skip)

where index, skip, and addtoindex are all fields.

and this equation gives the results for addtoindex itself.

Calculation result is a number.

Number of repetitions is 1.

Do not evaluate if all reference fields are empty.

Storage options is set for Do not store calculation results.

And no Global storage is checked.

Filemaker 8.0v3, soon upgrading to version 8.5 for the Mac.

Will this be improved in 8.5, or do I need to do something else that that every time I change the value of skip or index, addtoindex updates without my having to select it first or close the document?

Share this post


Link to post
Share on other sites

Any calculation field with GetNthRecord() needs to be unstored. Some unstored calcs only update after a Refresh Window [ flush cached join results ] step.

Create a script with the Refresh Window [ flush cached join results ] step and run it to see if the calc updates.

There is proably nothing wrong with FMP.

Share this post


Link to post
Share on other sites

I have no idea what this is trying to do, but try this calculation instead:

Case(

index > 1 and skip = 0 ;

GetNthRecord ( addtoindex ; Get( RecordNumber ) - 1 ) + 1 ;

index > 1 ;

GetNthRecord ( addtoindex ; Get( RecordNumber ) - 1 ) + skip ;

index+skip

)

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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