Jump to content

checked boxes to filling in data

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

Recommended Posts

i'm new at filemaker and computer programing, so any help would be appreciated.

i'm in the medical field and want to keep a close attention to my patients' medication lists. i am creating a large (ie., more common) drug list of all my patients' medications; i am going to create it as a value list and field format it as a check box (so i can check off meds for each patient). that's the easy part. now, as most of you know, we take medications every so often (every 8, 12, 24 hours). so i as i check off a medication, i would like filemaker to ask, "how much", and "how often" for each medication. i would assume a computation would be the best solution (if, 'checked box', 'ask amount'; i don't know the computer language answer). or should i do a scripmaker step? i'm new at computer programing, so please reply with easy terminology. thanks, peter

Link to comment
Share on other sites

This is a classic "you need a related file" situation. Checkboxes stop being useful at a certain point.

Create another file, "Patient_Medications."


PatientID, Medication, Amount, Interval

I just built a little file. It's easier than explaining. You would use your existing medications file as the value list for the choices. I just used the field.

Patient Meds.zip

Link to comment
Share on other sites


when i was going through one of the files, patientss, how can i add more 'medications' to the list? right now, the list includes: beer, coffee and tea. i could not find the med list to edit this. i went to the define value lists (under file), and value list name 'meds' had the source 'from another file' called "meds". where is that list?

thanks for your help, pete

Link to comment
Share on other sites


i did. when i went to patient_meds file and looked under the defined value lists, the source of the value list name "meds" is from field; medication lists is from the patient_med file. i could not get into the medication list to edit it. do you know how? i want to know how i can add another medication, let's say wine. thanks.

Link to comment
Share on other sites

  • 3 weeks later...

hi queue,

i'm stuck again. i'm using your example you gave me. now, i'm trying to list all the fields on one line, separated by a comma, in another (newly created) field. for example, if the meds (in your example, coffee, tea, beer) are given every 8 hours (interval hours), then i want list all meds in a new field called "8 hours meds".

i wrote a script:


If ["Patient_Meds__PatientID::Interval_Hours = "8""

Insert Calculated Result ["8 hours meds","Patient_Meds__PatientID::Medication & Patient_Meds__PatientID::Amount & Patient_Meds__PatientID::AmountLabel & Patient_Meds__PatientID::Interval_Hours"]

Insert Text [", "]

Go to Portal Row [Exit after last, Next]

End If

Exit Loop If ["Patient_Meds__PatientID::Interval_Hours <> 8"]

End Loop

this script does not seem to go to the next portal row to obtain the next medicaton (tea) and list it if the interval is 8 hours.

i also tried to create a calculated field:

Patient_Meds__PatientID::Medication & Patient_Meds__PatientID::Amount & Patient_Meds__PatientID::AmountLabel & Patient_Meds__PatientID::Interval_Hours

and then "checked" the repeating fields with a maximum of 20 values. this did not work either.

can you help me out?



Link to comment
Share on other sites


You want related lists of Med depending on an interval ?

And you want this list to appear in a field, separated by a comma ?

It's not clear how many fields you'd have, which seems to depend on the number of different intervals. I also assume that is why you were looking for repeating fields.

The comma thing would be easy, by only substituting the "

Link to comment
Share on other sites


i was using example files that 'queue' sent me awhile ago. in reality, i'm creating a medication database and want to organize each patients' (all) medications by organ system. for example, cardiac (heart pills), infectious disease (antibiotics), pulmonary (like asthma drugs).

i have created two files (based on queue's example). patient history and patient medication; related based on their registration number.

the fields are: medication name, amount, dosage (units), interval, and organ system. (a new field would be called 'medication_cardiac.) i created a portal record of 10 rows (for 10 medications). when i wrote the script, the script inserted the first drug that had cardiac as the organ system, but would not go to the next row. that's where i'm stuck.

your suggestion: valuelistitems. is that created under define fields, or define value lists?

i understand the Substitute(field, "

Link to comment
Share on other sites

This topic is 7549 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.