Jump to content

Get Nth record doesn't update


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

Recommended Posts

What am I doing wrong?

I want to compare the value in an Address field to the value in the same Address field in the previous record.

I've created a calc field-

GetNthRecord(Address;Get(RecordNumber) - 1)

This works at first, but if I change the Address in the first record, the calculation in the next record does not update until I click in it.

I've tried both storing the calc results and not storing but it seems to make no difference.

Any ideas? Thanks.

Link to comment
Share on other sites

It works for me with the following unstored calculation field:

GetNthRecord(Address; Get(RecordNumber) - 1) = Address

It reutrns a 1 if they are the same and a 0 when they are different. It updates when I change record 1 and move to record 2 without clicking into the field.

BTW, you might want to update your profile to show that you are using FileMaker 8.

Link to comment
Share on other sites

It's important to figure out whether the field didn't update at all, or if simply the screen display didn't update.

If it's the latter, you can force it to update by a "Refresh window/flush cached joins" script step.

If it's the former, you may need to "trigger" the update by setting another field, "TriggerField" in the same record, something like:

Let(

dummyFieldToUPdateThis = TriggerField;

GetNthRecord(Address;Get(RecordNumber)-1)

)

Then you just have a script step which sets TriggerField to any value.

Though, I suspect your problem is probably a display problem, not an actual update problem?

Link to comment
Share on other sites

This topic is 5685 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
 Share

×
×
  • Create New...

Important Information

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