total records and count - what am I doing wrong? - Calculation Engine (Define Fields)

March 13, 200817 yr

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

March 13, 200817 yr

Make sure that the calc is unstored.

March 13, 200817 yr

Author

yes it is unstored in the options

March 13, 200817 yr

Hi Mark. This needs to be checked.

March 13, 200817 yr

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

March 13, 200817 yr

Newbies

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

March 13, 200817 yr

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.

March 13, 200817 yr

Author

Thanks all.

Setting it unstored to recalc worked like champ!

August 29, 200817 yr

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...

August 29, 200817 yr

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.