Jump to content

Twist6

Members
  • Content Count

    12
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Twist6

  • Rank
    member
  1. Twist6

    Case statement issu

    Eos, I have just seen your last file example, and I totally (well maybe not 'totally - yet) understand now the use of tables vs fields. Your comments are also much appreciated, and your sensitivity to the 'newbies' like me that are confused by some of the terminology of a new world. I am very aware of this misunderstanding, knowing that we in the medical world are guilty of thinking that everyone knows what we are talking about, as our language is every-day for us but certainly not for the people we interface with. This assumption causes most of the issues between Drs and their patients. So I thank you for recognising this. The other similarity is that we do not wish to appear stupid by asking dumb questions. Your latest file will allow me to start from 'scratch' using it as a guide, and produce a much better and efficient product. I am aware of your precious time that you spent in formulating this template .... you are a thoughtful teacher and mentor. I will strive to be the same. I may have to get back in a few weeks to ask a few more questions and maybe report progress, but promise not to be a burden. Thanks again, Twist6
  2. Twist6

    Case statement issu

    Eos, Thank you for your file, I can see how efficiently it works. I truly appreciate you help thanks again Twist6
  3. Twist6

    Case statement issu

    Hello everyone, I have uploaded my travel clinic form to make things a little clearer. Allow me to prefix my question by reiterating that this is my first foray into using FileMaker pro 13 and indeed my first effort at programming, so I am sure that the coding is pretty “dirty”, as my only knowledge this coming from books and a few online tutorials. That having been said here is the issue that I’m trying to solve. I have calculated fields for both adult and paediatric prescriptions, as well as the total number of doses required for their trip, calculated from the number of days of their visit. For malaria prophylaxis I am using a layout which calls for prescription instructions, the type of medication that has been decided upon (drop down menu). The decision is made from the “accept” or “decline” radio buttons. As you can see, although very rough this seems to be working okay. When it comes to paediatric dosing, this is more difficult because of the variation in dosing required by weight. What I really want to accomplish, is to have the paediatric prescriptions act in a similar way to the adult prescriptions (in that they occupy the same area on the printed prescription, instead of appearing in a serial way down the page) Eos was kind enough to suggest a solution for calculating paediatric dosages which I have incorporated and is working well. As always, your expertise and skill is greatly appreciated. LaRetta, your suggestions for simplifying record names is appreciated and I will, when I get time, try to go back and simplify everything as you suggested. Thank you. Twist6 TravelSoftware Copy.zip
  4. Twist6

    Case statement issu

    eos, Many thanks for the file you sent. It's a little difficult for me to explain how this form works without showing an example. Would you be willing to have a look if I zipped it and attached here. If that is against protocol, I apologise ahead of time, and certainly understand if you are unable to do this. You have been most helpful already. Twist6
  5. Twist6

    Case statement issu

    It seems that I have a lot of cleaning up to do with this solution, so I will do some of that. Your points LaRetta are helpful. Eos, your 'Let' statement above worked flawlessly, and I so appreciate you guidance and the time you devoted to writing this for me, thank you. Wim, your observations and feedback were also pivotal to getting this to work. Thanks also to Brooks. As I have mentioned before this is my first venture into any forum and I am most impressed to find so many 'helping hands' I'm going to clean the language up a bit. I believe you have all contributed to my being able now to successfully complete this project. Thanks a lot. Twist6
  6. Twist6

    Case statement issu

    Thank you Eos for fowarding your file. I will have a look at it when I get home tonight after work. Thank you too Wim for pointing out the 'space'. I will make the amendments. That was stupid of me, but I will learn from the error, and also your counsel. I do appreciate all of your patience with beginners such as myself, and your willingness to share your accumulated knowledge. Twist6
  7. Twist6

    Case statement issu

    Hello Wim, Eos and all, The called fieds should be blank unless they fit the weight parameters, so I do not understand why they print. Thanks for you continued support Twist6 Paed Malarone2 If(((ChildWtKg) ≥ 11) and ((ChildWtKg) ≤ 20);"1 paed. tablet/day";" ") Paed Malarone3 If(((ChildWtKg) ≥ 21) and ((ChildWtKg) ≤ 30);"2 paed. tablet/day";" ") Paed Malarone 4 If(((ChildWtKg) ≥ 31) and ((ChildWtKg)<40);"3 paed. tablet/day";" ") Paed Malarone5 If(((ChildWtKg) ≥ 41);"1 adult tablet/day";" ") Paed Malarone2Total2 If((Paed Malarone2) = " ";" "; Round ( ( ( Days )+8 ) + .499999 ; 0 )) Paed Malarone 3Total3 If((Paed Malarone3) = " ";" "; Round ( (((Days)+8)*2) + .499999 ; 0 )) Paed Malarone4Total4 If((Paed Malarone4) = " ";" "; Round ( (((Days)+8)*3) + .499999 ; 0 )) Malarone Tabs Round ( ((Days)+8) + .499999 ; 0 ) Malarone Rx paed (Also = rxpaed , from ‘Let’ statement) Is just a text field containing the prescription instructions ie MALARONE Paed. tabs (62.5 atovaquone/ 25mg proguanil) Sig: Begin 1–2 days before travel to malarious areas. Take daily at the same time each day while in the malarious area and for 7 days after leaving such areas. Contraindicated in people with severe renal impairment. Should be taken with food or a milky drink.
  8. Twist6

    Case statement issu

    Sorry, Forgot to mention that the above reflects the coding that Eos provided viz: Twist6 Let ( [ rxpaed = Malarone Rx paed ; theString = " MITTE: " ] ; Case ( PaedMalUptake = "accept" ; List ( Case ( not IsEmpty ( Paed Malarone2 ) ; List ( rxpaed ; Paed Malarone2 & theString & Paed Malarone2Total2 ) ) ; Case ( not IsEmpty ( Paed Malarone3 ) ; List ( rxpaed ; Paed Malarone3 & theString & Paed Malarone3Total3 ) ) ; Case ( not IsEmpty ( Paed Malarone4 ) ; List ( rxpaed ; Paed Malarone4 & theString & Paed Malarone4Total4 ) ) ; Case (not IsEmpty ( Paed Malarone5 ) ; List ( Malarone Rx adult ; Paed Malarone5 & theString & Malarone Tabs ) ) ) ) )
  9. Twist6

    Case statement issu

    Hello all, Eos, I have inserted your recommendations, and below are the results. You can see that the correct prescriptions and dosages are displaying (in blue) for two different weights of children, but the other prescriptions are also not being suppressed so are appearing as well. Because there are four dosages possible, they are also appearing in the same order as the script (i.e.down the page 1-4). I could probably live with the displacement, but do you have any ideas why the other prescriptions are being called? Thanks again for your input. Twist MALARONE Paed. tabs (62.5 atovaquone/ 25mg proguanil) Sig: Begin 1–2 days before travel to malarious areas. Take daily at the same time each day while in the malarious area and for 7 days after leaving such areas. Contraindicated in people with severe renal impairment. Should be taken with food or a milky drink. 1 paed. tablet/day MITTE: 24 MALARONE Paed. tabs (62.5 atovaquone/ 25mg proguanil) Sig: Begin 1–2 days before travel to malarious areas. Take daily at the same time each day while in the malarious area and for 7 days after leaving such areas. Contraindicated in people with severe renal impairment. Should be taken with food or a milky drink. MITTE: MALARONE Paed. tabs (62.5 atovaquone/ 25mg proguanil) Sig: Begin 1–2 days before travel to malarious areas. Take daily at the same time each day while in the malarious area and for 7 days after leaving such areas. Contraindicated in people with severe renal impairment. Should be taken with food or a milky drink. MITTE: MALARONE tabs Sig: 1 tablet daily with food, starting 1 day prior to entering the malarial area, daily while there, and for seven days after departing the malarial area, at the same time each day. Not to be taken if pregnant or breast feeding MITTE: MITTE: 24 MALARONE Paed. tabs (62.5 atovaquone/ 25mg proguanil) Sig: Begin 1–2 days before travel to malarious areas. Take daily at the same time each day while in the malarious area and for 7 days after leaving such areas. Contraindicated in people with severe renal impairment. Should be taken with food or a milky drink. MITTE: MALARONE Paed. tabs (62.5 atovaquone/ 25mg proguanil) Sig: Begin 1–2 days before travel to malarious areas. Take daily at the same time each day while in the malarious area and for 7 days after leaving such areas. Contraindicated in people with severe renal impairment. Should be taken with food or a milky drink. 2 paed. tablet/day MITTE: 48 MALARONE Paed. tabs (62.5 atovaquone/ 25mg proguanil) Sig: Begin 1–2 days before travel to malarious areas. Take daily at the same time each day while in the malarious area and for 7 days after leaving such areas. Contraindicated in people with severe renal impairment. Should be taken with food or a milky drink. MITTE: MALARONE tabs Sig: 1 tablet daily with food, starting 1 day prior to entering the malarial area, daily while there, and for seven days after departing the malarial area, at the same time each day. Not to be taken if pregnant or breast feeding MITTE: MITTE: 24
  10. Twist6

    Case statement issu

    You are all most kind and helpful. Thank you Eos for taking out your valuable time to assist Wim and Brooks, and also LaRetta for your sage advice. This is my first venture into producing a database, and as I have proceeded I recognize that I need to address my nomenclature to avoid such complexities in the future. I will try Eos' solution, and zip the file if I am still unsuccessful. I have other medications that I need to use a similar structure, and I believe that if I can solve this one, I should be able to adapt the others. I'll return shortly. Thanks again everyone. Twist
  11. Twist6

    Case statement issu

    I did wonder whether that might be the case. I so appreciate your advice on this and I will try and rewrite. The intended output is a pre written prescription, with the added instructions, and the calculated number of doses. Thanks again for such quick replies, I have no resources in my area that program in Filemaker Pro so I was stumped.
  12. Hello all, I am new to both FMP 13 and developing. I operate a not-for-profit travel clinic and wish to automate writing prescriptions with data called from a form that I have developed. The paediatric dosing depend upon weight of the child, and the total doses dispensed, for the duration of the trip. I have a Case statement, which in its individual parts works well, but when put together only returns the first part. I have spent unknown hours looking at this but cannot determine what the issue(s) are. I would be very thankful for any advice. Radio buttons were used for “accept” or “decline” by the parent, and calling the prescription (Rx) body, instructions for use, and total doses. I apologise for any formatting issues with this post , I tried before but the text all ran together, and was difficult to read. So, I am trying again. 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); " ")
×

Important Information

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