I want to create an app to keep track of medications for my dog, who was diagnosed with Lymphoma. The medication dose schedule is a bit overwhelming:
- steroid pill twice daily (every 12 hours)
- chemotherapy once every 14 days
- anti-nausea pill 24 hours before chemo, then daily for 4 days after chemo (5 consecutive days)
- vitamin B12 injection monthly
- probiotic capsule weekly
I started making a google sheet with the necessary columns including:
- [Medication] (text)
- [Dosage] (text)
- [Frequency] (text)
- [Instructions] (text)
- [Next Dose Due] (date/time)
- [Administered] (true/false)
- [Last Dose Taken] (date/time)
- [Reminder] (yes/no)
If possible, I'd like the app to behave in the following way:
- When [Administered] is set to "true" for each medication, I'd like the value of [Next Dose Due] to be automatically set based on [Frequency].
Suggestions would be greatly appreciated regarding table structure (if changes are needed), as well as App structure (workflows or automations). Thank you for your time spent reading my post.
LinkedIn
Twitter
