AnsweredAssumed Answered

Hello, I am new to FileMaker 13 pro, and I am experiencing issues with a form that I’m using for a...

Question asked by Malcolm_2 on Mar 22, 2014
Latest reply on Mar 24, 2014 by philmodjunk

Post

Hello, I am new to FileMaker 13 pro, and I am experiencing issues with a form that I’m using for a travel clinic. The following is a case statement which calls a text prescription, dosage, and number of pills to be dispensed. Because dosage for children is dependent upon their weight, there are four distinct weight ranges and therefore associated subsequent dosing. The statement is calling to initially check that the parents have accepted (‘accept’, or ‘decline’ radio buttons) the medication recommendation.  Then check that the dosage calculation field is not empty (only one of four choices for dosage will return the correct dose and fill the field). The statement is then supposed to call the prescription, insert the correct dosage, and finally insert the correct number of tablets for the complete journey, into the prescription. Each of the statements independently works correctly, but when combined in the case statement as I have written it, the statement returns only the first choice.   All fields are formatted as text. This is my first attempt at using FileMaker, so I would greatly appreciate any assistance that experts may offer. Malcolm Case( (PaedMalUptake = "accept") and (not IsEmpty ( Paed Malarone2 )) ; GetAsText (Malarone Rx paed)  & ¶ &  GetAsText ( Paed Malarone2 ) &"     MITTE:  "& GetAsText ( Paed Malarone2Total2) ; (PaedMalUptake = "accept") and (not IsEmpty ( Paed Malarone3 )) ; GetAsText (Malarone Rx paed)  & ¶ &  GetAsText ( Paed Malarone3 ) &"      MITTE: "& GetAsText (Paed Malarone3Total3) ; (PaedMalUptake = "accept") and (not IsEmpty ( Paed Malarone4 )) ; GetAsText (Malarone Rx paed)  & ¶ &  GetAsText ( Paed Malarone4 ) &"      MITTE: "& GetAsText ( Paed Malarone4Total4) ; (PaedMalUptake = "accept") and (not IsEmpty ( Paed Malarone5 )) ; GetAsText (Malarone Rx adult)  & ¶ &  GetAsText ( Paed Malarone5 ) &"      MITTE: "& GetAsText ( Malarone Tabs); " ")

Outcomes