I'm currently exploring different integrations that can be done between Google App Script and Git. This is part of a bigger attempt to integrate Git data into my project management system. I'll post more on that later. GitHub supports a number of very nice sub-systems. One of them is the GitHub Issues ticket tracking system. It's fairly robust and comes with GitHub - which means it's highly integrated out-of-the-box. Integration with Google's App Script is done via the fetchURL command and JSON object manipulation. After a good bit of experimentation, I've settled on querying GitHub Issues with an "on open spreadsheet event" to avoid issues with Google's quota system. Essentially, Google prevents you from calling the fetchURL command more than X times (see the quota limits ) per day. That's not great if you have people actively working and changing data in a spreadsheet. Some of my other App Script routines are running thousands of times per d
This is my first attempt to create a blog of my thoughts on coding and technology. I've been developing software for many years now and have an interest in many of the current (and not so current) languages and technologies. I primarily develop with CodeGear's Delphi and have used its predecessors all the way back to Turbo Pascal 3.0. I have specialized in health care technology so some of my posts may be about that industry in specific, while others will discuss various techniques I find either interesting or useful. Hopefully, the reader will find the information either relevant or useful. With a touch of luck, perhaps even both.