Rohan Singh All work

Low back pain tracking app

An Android diary where a person logs back pain three times a day, next to sleep, medication, work and activity.

Context
Clinical internship, CMC Vellore
When
Jan to Jun 2024
Tools
Kotlin, Android Studio, Google Apps Script, Google Sheets, SQLite
Testing
Installed on 10 people's phones
Links
Source on GitHub

Problem

Low back pain is common and long-lasting, and how bad it feels changes through the day. Patients rarely record it, and almost never alongside the things that affect it, such as sleep and activity. That leaves clinicians with a vague picture.

What I built

  • A daily form that records pain in the morning, afternoon and evening on a 0 to 10 scale.
  • Questions on sleep quality, pain medication, whether it was a working day, and physical activity.
  • Responses saved to Google Sheets through Apps Script, with SQLite storage so it works offline.
  • I wrote the user stories first, then built the app around them.

Testing

I installed the app on 10 people's phones, friends and colleagues in different states, to check that it worked across devices and to find bugs and performance problems.

Empty daily survey screen Filled daily survey screen with sleep rating, pain sliders and medication answers