ran 20 users on a form and a spreadsheet for six weeks - when do i actually have to build the app
Six weeks ago I put up a form that dumps into a spreadsheet, and every morning I spend about 40 minutes doing by hand what the app is supposed to do (take a client's inventory export, dedupe it, mail back a clean csv). 20 people on it, 3 of them pay $15 through a payment link.
I keep waiting for the moment where this obviously breaks and I have to go write the thing, and it hasn't arrived. Is that a signal I'm building the wrong thing, or am I just early? For people who did the manual version first - what broke first? Volume, or something else?
@interval_ida · 2mo ago · 3 replies
Volume is almost never what kills the manual version. What killed mine was the promise. I told people 'back within an hour' and then had a Tuesday where I was in a dentist chair at 11am and three people got their file at 6pm. That is the moment you automate - not because you cannot do the work, but because you cannot do it on a schedule a stranger can plan around.
Order I would go in: automate only the path that carries the promise (intake, processing, delivery). Billing stays manual, onboarding stays manual, support obviously stays manual. My 'real app' for the first four months was one worker script and one table, and the whole admin side stayed in a spreadsheet for another year after that.
Reply
Report
@stipend_sam · 2mo ago
This, and the underrated part: the forty minutes a day is your spec. I wrote down every keystroke for two weeks and the resulting doc was more accurate than anything I would have designed up front, including three edge cases I would definitely have shipped without - files with a BOM, duplicate SKUs that differ only in casing, and one client who mails xlsx with a .csv extension.
Reply
Report
@query_quinn · 2mo ago
Did you tell people it was manual? I have gone back and forth on this. My read now is that saying it out loud buys you an enormous amount of patience, and the day you automate it you get to send an email that sounds like progress instead of a confession.
Reply
Report