Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

  • Newbies
Posted

Need some help. I am trying to use an if statement with a calculation in a repeating field that looks at a non-repeating field with the extend function.

If(LH1 >= Extend(HEEL) and LH1 <= Extend(IHEEL) ," ","** **")

This works perfectly except when there is no entry in the first cell of the LH1 field. It returns the ** **. If I make an entry then it works perfectly All other repetitions in the repeating field work fine. Any way to fix the first cell? I've tested both clicking and unclicking the " Do not evaluate if all referenced cells are empty"

Posted

Something to keep in mind with FileMaker Pro: A number field can be expressed as a Boolean. A Boolean value is either true or false, and is often used to test the condition of something. A zero or null value in a number field is treated as false in the Boolean sense; any other data is treated as true.

This means that Filemakers implementation is slightly off theory!

--sd

This topic is 6726 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
×
×
  • Create New...

Important Information

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