4 Replies Latest reply on Mar 1, 2010 5:26 AM by warfadoc

    Archive and Delete



      Archive and Delete



      I am running Filemaker pro advanced. osx..  I am building a database to keep track of patients while they are in the hospital, I would like to have an active list that shows only patient that are admitted.  When they are discharged I would want to delete them from the active list and archive them to keep track of number of patients adm ect...  I am trying either to have a checkbox that says "Discharged" and when checked run a script that deletes and archives, or a button that does something similar.


      I would appreciate any help you can give me 

        • 1. Re: Archive and Delete

          two ways are possible...


          make a identical second table in your database. the button "discharge" marks this record as discharged, switches to the identical archive table, imports the marked records, switches back and deletes the marked records.



          the button only marks the record as discharged. then you have to add the status "active" into every search request, AND you have to make a search "active" instead of your "show all records"




          greetings from germany


          • 2. Re: Archive and Delete

            Thanks for the response... I am very new at filemaker.. I wanted a script that would be compatible with instant web publishing.. basically something that would delete and transfer so that doctors would only "see" a list with patients in hospital but would be able to go back and see previous patients.  Something that I have been trying as well is a layout that would only show hospitalized patients.. but I Have not been able to do so.

            • 3. Re: Archive and Delete

              To see only "active" patients, all you need to do is perform a find. Assuming you have a DischargeDate field (as you well should), find records where this field is empty. This can be scripted, and there is no need to move records from one file/table to another.

              • 4. Re: Archive and Delete

                Thanks that worked out great :smileyvery-happy:

                Now just one more thing is there any way to create a layout where a dialog box would ask for dates to create a list of patients adm from lets say 1/2/09 to 4/1/2009 ?