News for hackers. Stuff that matters.
Re:Plain Vanilla Web by jfengel on Monday May 12, 2025 @08:29AM (#43962204)
I've found that "send me a spreadsheet and I'll upload it" isn't a great user experience. It's just a big pile of cells, with no documentation (which they wouldn't read anyway).There are a billion things they can do wrong, and they get no feedback on it until I email it to them. They don't know what the options are for any field, and it's easy to enter a nonstandard value. A typo in a header row can lead to data loss with no errors.

There are times when it's the easiest way to handle things, especially for experienced users. But I find it a massive hassle to maintain support for every possible mistake the user can make.

Re:Plain Vanilla Web by bandoti on Monday May 12, 2025 @09:58AM (#43962980)
It could work but there is still a bit of developer overhead: (1) Use iron-clad schema validation in the database; (2) Provide some forms over top the Excel data like old Access applications.

The benefit would be that you have a fixed set of UI components available in Excel and don’t need to worry about styling and whatnot.

Re:Plain Vanilla Web by dragontamer on Monday May 12, 2025 @09:48AM (#43962860)
Excel is more than cells?

If you have certain options, use Excels forms to place buttons, menus and selections.

Re:Plain Vanilla Web by accrual on Monday May 12, 2025 @10:05AM (#43963054)
Fixed drop-down fields are very helpful for shared/inter-company spreadsheets too. Highlight them in red until they're changed, then enforce the value via dropdown.
Re:Plain Vanilla Web by tchalvakspamm on Wednesday May 14, 2025 @08:57AM (#43983981)
Oh god, a webpage built in excel
Re:Plain Vanilla Web by j45 on Tuesday May 13, 2025 @05:09AM (#43970997)
Spreadsheets are often where so much software starts.

I'm not an instant fan of it, but it is one way for someone to lay out their thinking about how to solve something that works.