Skip to main content

Retrieve last prescription for a given Patient

  • August 20, 2020
  • 2 replies
  • 46 views
C

Hi guys!

I work at a public mental health service and we use airtable to coordinate our work.

I have a patients table linked to a visits table, which in turn is linked to a prescription table, which is finally linked to a drug table.

I want to be able to retrieve the last drug a patient has received in the visits table. How could I go about doing that?

Thanks in advance!

2 replies

Avi_Doe
Forum|alt.badge.img+11
  • Avi_Doe
  • Known Participant
  • August 21, 2020

Hi!
You will need the field last modified or created date in the prescription table. Then you could make a view of this table grouped to patients name and sort it to created time or last modified date.

Hope it works for you!

    B
    Forum|alt.badge.img+19
    • Bill_French
    • Inspiring
    • August 22, 2020

    Just curious - is your patient health data for US patients, or outside the US?

    Terms & ConditionsAccessibility statement