I am trying to write a calculation to display text "This number has already been used" following a find.

The recordfound count has to be 2 or greater but less than the total record count to display that.

I have a formula

If (get(Foundrecordcount) >1 < get(totalrecordcount) ; "This number has already been used" , "")

and it is not working. Could someone please help clear this up?

Thanks

STan

Stann,

Update your profile to include your platform, operating system and version of FileMaker. The link is just below your name in blue "profile".

Lee

I s there anyone who can help with this. I keep trying to write the formula but it goes and doesn't work.

I agree the behavior of Get (FoundCount) is odd. It evaluates only at the time that the record is created. To see how the functions behave try pasting the following into a calculated text field:

"Get ( RecordNumber ) = " & Get ( RecordNumber ) &

I should add that Get (FoundCount) behaves this way in a calculated field, but it works as expected in an "if" statement while running a script, i.e. it returns the current found count.

Calculations using Get functions such as these, must be unstored in order to update without being forced.

Stan, I'm not sure I understand your purpose. However, each test must be made independently of the other. E.g. 0 < x < 1 has no meaning in FileMaker (at least, not an intuitive one). 0 < x and x < 1, however, does.

Well, there's no bug with the Get( ) as long as unstored.

The calc should look something like

Get(FoundCount)>2 and Get(FoundCount)<Get(TotalRecordCount)

sorry, French version here at the moment

Hmm... so agreed with Queue

Umm.. I'm curious about this now. Get (FoundCount) works fine for me if used in a script but does not update if used in the definition of a calculated field, whether it be indexed or not...

It isn't whether it's indexed; it's whether it's unstored. You have three options regarding field storage: indexed, unindexed, and unstored. Get function calculations must be unstored if you wish them to update automatically, as Status functions were in previous versions. Get(FoundCount) and Get(TotalRecordCount) work just fine if unstored.