Pretend I know nothing but basic HTML/CSS (mostly true). How would I go about making a progressive web app with inputs that go to a database with some basic Excel-type functions? Essentially I'm doing some manual tracking in a spreadsheet right now and would rather it be a nice touchscreen interface that anyone in the family can use from their phone
Discussion
metabase can visualize the tracked data and it also has writeback. in other words, it lets you build simple data entry forms. that would save you from completely doing everything from scratch. if you want further processing, you can write some postgres triggers that execute procedures whenever the user enters some data.
if you insist on writing everything from scratch, flask is approachable for beginners. you're still gonna learn postgres and some framework for the frontend.