Log in to create and rate content, and to follow, bookmark, and share content with other members. Not a member? Join Now!

AnsweredAssumed Answered

How to transfer forms to a related record

Question asked by davidmadrigal on Jun 23, 2011
Latest reply on Jun 24, 2011 by philmodjunk

Like • Show 0 Likes0
Comment • 8

Summary

Product

FileMaker Pro

Version

new

Operating system version

mac

Description of the issue

I have 2 forms created. I have a patient list that I currently have a patient selected then have my patients fill out the two forms. These patients will be seen in clinic by weekly so I need to change the form so that the old forms will be saved and I can select a new form to be filled out for the next visit. I also want to be able to view the old form during their next visit to do a comparison. How do I change my existing forms so that I can bring up a blank form every visit?

No one else has this question

Outcomes

8 Replies

philmodjunk Jun 23, 2011 1:06 PM
Mark Correct
Correct Answer
You've posted this request in the section of the forum intended for reporting possible bugs with the software. Had you posted in the FM GO section you would have received an answer much sooner and from more people.

Please look up "Portal" in FileMaker help. This is a frequently used tool that can help you here.

You need at least two, or possibly three tables for this, depending on whether you can use one table for both forms or not.

Patients---<Forms

Patients::PatientID = Forms::PatientID

Patients::PatientID should be an auto entered serial number and "allow creation of records should probably be enabled for Forms in the above relationship. (IF you need two tables for your two forms, add a third table with a similar relationship to Patients.)

Now a portal to Forms on the Patients layout can list all the existing forms for that patient and you can always add more Forms without losing the existing forms simply by adding more records to Forms with the same PatientID field.
Like • Show 0 Likes0
Actions
davidmadrigal Jun 24, 2011 9:13 AM
Mark Correct
Correct Answer
Thank you for the response however I am not savy on the filemaker Jargon. Is there a way you could take me through the keystrokes involed in doing something like this. I have a table with my list of patients and 2 more tables, 1 for each form. Sorry I am sill getting used to the software.
Like • Show 0 Likes0
Actions
philmodjunk Jun 24, 2011 9:36 AM
Mark Correct
Correct Answer
Have you checked out "portals" yet?

Can you set up portals to your Form tables on your Patients layout? (Even if it turns out to be impractical to use the portal to display and edit your forms, being able to get this far tells me a lot about what you currently can and cannot do and the portals may prove to be a useful way to select a specific patient form for viewing/editing/printing.)
Like • Show 0 Likes0
Actions
davidmadrigal Jun 24, 2011 10:04 AM
Mark Correct
Correct Answer
I do not use portals or know what they are. I do my editing of data from browse mode and i change the looks of my forms from the layout mode. What is the signficance of using portals?
Like • Show 0 Likes0
Actions
philmodjunk Jun 24, 2011 10:19 AM
Mark Correct
Correct Answer
If you had looked up the term in Filemaker Help like I suggested, you would know the answer to that question.

Portals are an extremely useful tool for working with related records in Filemaker. You have three tables, one for Patients and two more for your different "forms". They should be related by a PatientID number so that you can see all the forms of one type for a given patient in a list. That "list" is very often produced in a portal in FileMaker.
Like • Show 0 Likes0
Actions
davidmadrigal Jun 24, 2011 10:33 AM
Mark Correct
Correct Answer
sounds good, think ill give it a try
Like • Show 0 Likes0
Actions
davidmadrigal Jun 24, 2011 12:36 PM
Mark Correct
Correct Answer
The forms I have made are very elaborate and have many fields to them. Is there any way to just make a button that from the patient file will generate the form so the patient can fill it out then on their next visit push the button again for the same form but a blank version of it
Like • Show 0 Likes0
Actions
philmodjunk Jun 24, 2011 2:43 PM
Mark Correct
Correct Answer
But of course. The portal was just a step to get you started. If you can list the records from your forms in your portals, you have working relationshps that will help you work with your forms more easily. You can actually add a button to such a portal that brings up that specific form for the doctor to read.

But let's get you started with a button and script that creates a new form record for the current patient.

If you were able to get a portal working, you should have this relationship for both of your forms tables:

Forms1>----Patients-----<Forms2

Patients::PatientID = Forms1::PatientID
Patients::PatientID = Forms2::PatientID

Write this script, I am likely using different layout, field and table names, so change the names to fit your database:

#This script must be run from the Patients layout
Set Variable [ $PatientID ; Patients::PatientID ]
Go To Layout ["Forms" (Forms)]
New Record/Request
set field [Forms::PatientID ; $PatientID ]

Put a button on your Patients layout set to run this script. Since you have mentioned two forms, each in different tables, you can create two such scripts and a button to run each.

Some additional info that you may or may not have figured out already for the design of your forms:

Any data you collect in fields on your Patients layout need not be re-entered on the forms you pop up. Using a Patient Name field as an example, you can enter layout mode on your forms layout and then use the Field tool to add the Patient Name field to your forms layout, selecting the Patients table from the drop down list at the top of the specify field dialog and then selecting the patient name field from the list that appears.

With this set up this way. You'll see the patient name already entered on your form when you click the button you've just created for this purpose automatically.
Like • Show 0 Likes0
Actions

How to transfer forms to a related record

Summary

Product

Version

Operating system version

Description of the issue

Outcomes

Related Content

Recommended Content