• 3 Posts
  • 166 Comments
Joined 4 months ago
cake
Cake day: October 7th, 2024

help-circle



















  • Company schedule entirely written in Google Sheets. When I originally took the position over, the owner wouldn’t settle for an alternative solution.

    The previous IT person worked there previously for about 10 years and had been compulsively adding features with AppScript the entire time. It was auto sending emails, handling inventory, maintaining project files, you name it. I briefly looked at how it worked and there were easily a dozen script files, a few of which were thousands of lines.

    I was able to replicate most of the important parts of the system that he wanted to replicate in about two weeks in between other work with one script file and something like 50 lines.

    I eventually left for reasons unrelated to the place and only ever had to fix issues once every 6 months or so, which I consider pretty decent for an unattended Google Sheet shared by 5 users.

    I’ve since returned and rebuilt the schedule a second time with a proper database and the whole thing run 10x smoother and more reliably.