Database to track my pet's health

Configuration Frontend
1

Hello all,

I’m looking for an easy way to track the health of my pet. This includes the different kinds of foods he eats (dropdown list preferably), how many times he uses his litter box, and if he has hairball issues. I’d like to just use a form but each day, the data needs to reset automatically to defaults but stores the info in a database of some sort. Ideally like a spreadsheet view that I could put on a separate card.

I’ve begone some work and I can collect data, but don’t know how to store or review the history. I’ve attached a screen shot of the collection options, but need help with the daily reset to zero and the storing of yesterday’s data to a database with history view.

Anyone done anything similar to this that I can modify?

Thanks,

Screenshot 2025-09-02 at 11.20.48 AM
Screenshot 2025-09-02 at 11.20.48 AM1062×816 35.4 KB

2

I’m not sure home automation software is the best fit for your needs. Have you looked at the available pet heath tracking apps? 10 Best Apps to Track Your Pet's Health: Keeping Your Pet Healthy

3

Thanks @tom_l. I will check these out. I’m trying to limit the number of apps that are on our phones and would rather have it on my ha. Might have to use another db in a VM or something.