Nightmare on GoogleApps Script

Nightmare on GoogleApps Script

If it isn’t obvious by now, I often take projects that force me to learn new things. This was not one of those times. As part of some committee work, I agreed to help build a form for member submissions to a social media platforms run by the organization (e.g. submit your twitter or blog post here!).

It seemed straight forward, until I realized Google Forms doesn’t have an upload option on the free version. Ok. So I went on to search other options. I found that many people used a combo of Google’s Drive and GoogleApps Script to code a Google Forms-esque upload form. I copied the code to my personal drive, and womp! It would not run, even in its initial iteration. I would just get a blank screen.

To be completely honest with everyone, I’m still not completely sure why the code would not work for me. I was sure it was an ID10-T user error, but after sending my sysadmin friend a video of what I was doing, he was stumped as well. It was working for him. He could run it with no issues, and it seemed like I was doing all the same things he was doing. After about an hour of tinkering, which left me with a deep desire to flip my desk, I closed the window to revisit later.

Later has not quite come yet; I started this project only four days ago. This post is a testament that using tech is never all success without complication. It’s completely ok to fail or hit a set-back. This is why you start things a month before they are due (take that procrastination brain). I’m jumping back into it today, hopefully. Expect a follow-up post once I get the code to submit, but for now, happy tinkering!