Today started with a minor UI issue but ended with a major backend crisis. I noticed that the new sidebar’s dropdown feature wasn’t functioning properly on mobile view. The menus were not expanding as expected, making navigation almost impossible on smaller devices. After some inspection, I realized that the event listeners for the dropdown were not triggering correctly under mobile screen conditions. I rewrote a few of the handlers and adjusted the CSS to ensure it was responsive across all breakpoints.
However, the bigger issue hit later in the day. My Google account, which was connected to our AppScript project, was suddenly suspended. Along with the suspension, our entire AppScript project was temporarily removed. A message from Google stated that we violated their Terms of Service due to an unusually high number of API requests. This unexpected termination caused a major disruption in our development flow.
I immediately escalated the issue to Sir Allen, and he quickly scheduled a meeting to assess the situation. We all brainstormed possible reasons for the spike in API calls and discussed potential alternatives to mitigate future risks.
The final decision was to transition away from AppScript and convert the entire backend to PHP. Despite this, we agreed to continue using Google Sheets as the main database, which meant we would need to connect PHP to Sheets through API integrations. This shift would require a significant amount of refactoring, but it offered more stability and control.
This day taught us a critical lesson about depending too heavily on a single platform and the importance of handling API rate limits and quotas properly.