2 Replies Latest reply on Jun 5, 2014 10:12 AM by judyyaz

    Setting a value in a field



      Setting a value in a field


           This will be really easy for all you Filemaker Pros out there but I have not worked with calculations, etc. and just can't figure this out.   I have a field named SPAY and one named NEUTER, and a field named SEX.  What I would like to have is the SEX field set to Male or Female depending on the SPAY and NEUTER field, any help, thanks much!! 

           So, if the SPAY field =Spay, then Sex would equal Female, and if the Neuter field =Neuter, then the sex field would equal Male.

        • 1. Re: Setting a value in a field

               Set your SEX field to a calculation field with the result type 'Text' and the calculation as follows:

               Case (
                  SPAY = "Spay" ; "Female" ;
                  NEUTER = "Neuter" ; "Male"

               But, if you still want to be able to set the Sex field without selecting either Spay or Neuter you won't be able to as it's a calculation field. If this is the case then set the SEX field as Text with an Auto-Entered Calculated Value with the same calculation as above, but make sure the 'Do not replace existing value of field (if any)' checkbox is UNTICKED.

               Also, could you not have one field where the user could choose between Spay or Neuter? In your setup they could both be selected!

          • 2. Re: Setting a value in a field

                 Thank you Phil..............I new it would be simple, I was just missing a step!