Greater than one field less than record Count Ques

[stann]

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

[Lee Smith]

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

[stann]

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

[Matthew F]

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 ) &

[Matthew F]

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.

[-Queue-]

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.

[Ugo DI LUCA]

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

[Matthew F]

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

[-Queue-]

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.