Home What's Next
Shop




Medication Tracker

Keeping track of your prescription pills (or an elderly relative) is easy thanks to NFC and Google sheets..

Using NFC (Near Field Communication) technology, I attached a NFC sticker to the lids of a standard branded pill container. This NFC tag communicates via my Android phone and Macrodroid (also available for the iPhone) with a Google Form and then recorded onto a Google Sheet.
When the tag is tapped against my enabled phone, it will open a link to a pre-formatted Google Form page. All I have to do is tick the boxes of which medication I have taken and press submit. Simultaneous my response will be added to a Google Sheets page. After a 10 second wait (required for other tasks to take place), it will send a text message, an email, a message on my phone's screen and a WhatsApp message (this can be customized to suit your needs), informing me (or a carer) that my pills have been taken.
The NFC tag can also be configured to made an entry into your Google Calendar.

Routines

Reminder - Message via my phone when I have not taken a pill by a certain time.

Acknowledgement - Confirmation when I've taken daily dose.

Record - Time and recorded onto a Google Sheet when I've take the Pill(s)

The NFC tag can also be programmed to do other routines.

Inform a friend or relative - Either by text or email, someone could be notified when your medication has been taken.

Reminder - Send a message to a relative that a pill has not been taken yet (time activated).

Please be aware that all users must be familiar with basic NFC usage, this means the device must be NFC enabled. Vulnerable patients must be in a position to understand how the basics of the system actually works.