2 Replies Latest reply on Mar 21, 2011 1:50 PM by GianandreaGattinoni

    Filter Portal Records by CurrentDate



      Filter Portal Records by CurrentDate


      Huge NOOB, so please bear with me. That also means that the answer to this question will probably be simple!

      I have created a database which keeps track of Dr's appointments at a summer camp - EASY! Now I need to create a bunch of reports for it to make - not so easy.

      The database has three Tables:

      Patient (personal info, insurance)

      Visits (diagnosis, dr. seen, date, time, diagnosis, orders)

      Meds (Name of Med, dose, frequency)

      Tests (a place to put test results like x-rays, lab work)

      I need to create a report that gives the following data from each table for THE CURRENT DATE that the medical staff can print each day, i.e. a log of all patients seen that day and by whom:

      Patient (Name, Birthdate, Health Insurance Number)

      Visits (Diagnosis, Treatment, Dr. Seen)

      I've set up a report based on Patient with a portal containing the fields from Visits but can't figure out how to sort the portal records so that ONLY and ALL OF the records created today will appear. Am I way off base?

      What's the calculation that would only display visits made today?

      (inb4 search the forums, as I've searched for about an hour now :))


        • 1. Re: Filter Portal Records by CurrentDate

          If your portal records have a date field, you can sort your portal (or its relationship) by the date field in descending order to put the most recent record at the top.

          In FileMaker 11 only, you can define this portal filter expression:

          Visits::DateField = get ( CurrentDate )

          To only show portal records with today's date in the portal.

          But you may want to try a different approach.

          If you create a summary report on a layout based on visits, you can do a find for all records with today's date and list them in order with fields from the patients (and possibly the meds table) included on this layout to provide the complete info. The format of this report might lend itself to printing better than the data entry layout you show in your screen shot.

          • 2. Re: Filter Portal Records by CurrentDate

            Have you tried to define in the portal a filter?

            Something like : fieldVisitDate = Get ( CurrentDate )