total records and count - what am I doing wrong?

[Mark Reed]

I have attached the fp7 file in hopes someone can tell me why my calc field is not working correctly.

Instead of it showing:

Record X of Y

(Z records total)

its showing X of X and X total

I am using:

"Record " & Get (RecordNumber) & " of " & Get (FoundCount) &¶&

"(" & Get (TotalRecordCount) & " records in total)"

magicvault.zip

[mr_vodka]

Make sure that the calc is unstored.

[Mark Reed]

yes it is unstored in the options

[mr_vodka]

Hi Mark. This needs to be checked.

[Orlando]

Hi Mark

As Mr_Vodka said, you need to make the calculation unstored, you need to make sure you have selected the "Do not store calculation results" option (see pic)

As soon as I did this it worked fine.

Regards

[-JC-]

I opened your file and changed the calculation field to return text instead of number and it worked fine.

[mr_vodka]

Simply changing the result data type wont do to help it refreshing for each record. Even though the data type should have been text, FileMaker unlike many other programs out there, is extremely forgiving regarding dta types.

The calc needs to be unstored.

[Mark Reed]

Thanks all.

Setting it unstored to recalc worked like champ!

[fful]

Thank you! I have been tearing my hair out for hours and searched the web for at least an hour before finding your solution. I had the same problem. You'd figure Filemaker would make a note on this in their "FoundCount" online help...

[Vaughan]

It's noted in the help for Get Functions...

Get functions

Use Get functions in scripts for error checking and prevention, or to capture information about the status of a database file or elements in it, or an action being performed.

Many Get functions return information that changes on a regular basis. For example, when the Get(CurrentTime) function is placed in a stored calculation field, the time will only update when a new record is created. If the calculation has other fields in it, but the calculation result still returns the current time, then the stored calculation result will only update when those other fields have been modified in the current record. If either of these calculations are unstored, the time will update as needed.