ITEM.PARTY is a list app.
I didn't mean to write a list app. I meant to write a table app that worked better than a spreadsheet for non-numeric data. But then I needed to make it work on my phone to update the data, and phone screens are really no good at all at presenting tables. So it became a list app in practice, and there are lots of those.
I've been working on other things, but I've realised that I was working towards a number of distinct goals for ITEM.PARTY.
(1) View lists as tables with smart rows and columns. Play with data by grouping items.
(2) Create and edit item lists from a phone that might be offline.
(3) Provide spreadsheet-like manipulations appropriate to mostly text/category based items, maybe some light calculating (converting units, bucketing, totals and averages...)
(4) Work with data wherever it may be, don't hide it within a centralised service.
I started with (1) and wrote the app as a PWA because I hoped that would be enough to give me (2), but that was a mistake.
I've realised that (4) was actually the most important one goal me, and it makes a bigger difference than it might look to how things pan out in practice. With data stored in a central location, you can talk about access to that data, and it makes sense to manage that access in the same location. The scopes converge: you get one account, one app, one data type. My original idea for goal 1 had been to take JSON data from anywhere and visualise it according to a schema, or setup. Private data, public, whatever. But after four months I'd made one compromise after another, and I found myself with an unexceptional list app with a Firebase backend and some quirky UI decisions, and no good reasons for people to use it over those other options.
So I think I need to start over. Be more radical.
If all this sounds like a weird retro list app for nerds that miss the 90's, so be it. (I don't particularly miss the 90's though.)
It's still here but no longer being actively worked on:
ITEM.PARTY online on the internet
Spreadsheets are very commonly used for working with items. Each item can go in a row (or a column), and each different aspect of the items gets a column (or a row). This works fine! But...
Nevertheless, a spreadsheet might be a better choice if
If there is a specialized app for the kind of items you want to work with, then absolutely use it! But...
Scrambles in the Lake District