The ER Doctor Asks for Your Medication List and You Can't Remember the Third One
You take five medications. You know three by name, one by the color of the pill, and one you haven't taken in three weeks because you forgot to refill it. The ER intake nurse needs the exact names, dosages, and frequencies. You're pulling out your phone, opening Notes, and finding a list from 2022 that's missing the two medications your cardiologist added last spring.
This template replaces that abandoned list with a live, filterable medication database.
Frequency as Multi-Choice Is Smarter Than Free Text
The Frequency field offers thirteen options: 1x through 4x daily, with meals, individual meal times, morning, evening, morning and evening, and "as required." Multi-choice — not single-choice — because a medication taken twice daily with meals checks both "2x day" and "With meals" simultaneously. That multi-tag approach lets you filter for everything you take at breakfast when you're setting up your pill organizer on Sunday night.
The Status field divides your list into "Currently taking" and "Not active." Inactive medications stay in the database because your doctor will ask about them. "What have you tried for blood pressure?" is answered by filtering Status to show everything, not just current.
The Refill Countdown Nobody Watches Until It's Too Late
The "# of Refills left" multichoice tracks remaining refills: 4+, 3-4, 2, 1, 0, Infinite. When a prescription drops to 1, you need to contact the prescribing doctor for a renewal before the pharmacy runs out. At 0, you're already overdue.
The "# Days Supply" field and "Prescribing Date" together tell you when the current supply runs out. Coverage Type — with options for specific insurance plans and pharmacy discount cards — determines which pharmacy gets the refill to minimize out-of-pocket cost.
Pharmacy and Doctor Fields That Work Like Speed Dial
Both "Pharmacy & PH #" and "Prescribing Dr. & PH #" are multi-choice fields with phone numbers embedded directly in the option text. When you need to call Walgreens about a refill or reach your cardiologist about a dosage change, the number is right there in the record — no separate contacts lookup, no Googling the office number.
The RX Number field ties each medication to its specific prescription ID at the pharmacy. When you call in a refill to the automated system, it asks for the RX number. When you transfer a prescription to a different pharmacy, they need that number. It's the kind of data that lives on the pill bottle label you threw away three months ago.