So it's basically just my wife and I right now. I haven't really taken the time to polish up some operational bits (we have really good logging/metrics where I work, and I miss it) or to market it though. I'm leaning towards letting people define a keywords area with three columns - the first is the word to trigger the command, the second is where anything after the keyword gets put (in some sanitized manner - like stripping whitespace) and the third would be the place to read the response. But that's more special casing - maybe it's a purist in me. I could see it being a 3-7 day timer to trigger a text if you haven't updated the spreadsheet in some way.Īs for queries, I'd like to add queries to get the categories and query the amount left in a category. Well, I like the idea of timer to watch stuff. Any feedback is very much welcome.Įdit 3: If you don't want the manual import of transactions (but do want the freedom of a spreadsheet) then I'd suggest TillerHQ instead I haven't used em, but I came across them when doing research before launching BYOB. Mine can only record transactions and then send a response (which it reads calculated from the spreadsheet based on the last transaction, which I'm very proud of for the level of customization it provides), but I've been noodling over how to add custom commands.įTR, I shameless stole my idea from an earlier HN comment sometime last year if you're considering implementing a SMS/spreadsheet system yourself, I'd check it out Įdit: I really am happy with my solution because it basically lets you take any google sheets based transaction you have and add SMS as an input method.Įdit 2: Sorry if you encounter any rough edges if you go to use BYOB - I haven't marketed it widely, but my wife and I do use it. That said, yours looks a lot more full-fledged than mine. Shameless plug - I wrote a SaaS that's pretty much just a SMS google spreadsheet mapper. The fact that it doesn't sync automatically with our bank accounts is actually a feature, because the ritual of having to text it whenever we spend money forces some mindfulness of our spending habits, and the regular reports (where it chides us if we're not saving much or exceeding our spending goals) add some gamification - we joke about how we want to make it proud of us. It also bugs us if it notices we haven't transferred anything to savings recently. It sends us nightly and weekly reports letting us know progress towards savings goals and warning us if we're about to run into a tight spot based on what it knows about our spend rate, and upcoming bills and big expenses. by paying with a credit card, and "pay " for payments). It has support for debts/loans (we can do "cc " for increasing debt, e.g. I added some minimal polish like an undo command, a minimal GUI accessible via a short-lived link it sends us on request where we can add and edit recurring bills, subscriptions, and upcoming one-time or yearly major expenses. The workflow is whenever we spend money we text it with "spend " or "sp ", and whenever we receive money we do "add ", and "save " whenever we move money to savings. A while ago I built a simple SMS bot for my partner and I to track finances like this, and it works fairly well.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |