Post has attachment
More Apps Script training resources appearing on

Paying for bugfixes

I've been having an interesting discussion with a client where they don't think they should pay my full hourly rate for bugfixes. I'd love to get the "Google Script" communities take on this as its a G Suite script (still getting used to the new names!):

Every software project is going to involve a degree of research and experimentation. We are bringing together a complex set of tools in a potentially infinite number of ways. We are designing and building a bespoke, custom product because an off the shelf solution does not already exist. Bugs (the software acting in an unexpected way) are an inevitable part of this process. The industry uses a R&D or “agile” approach to overcome this. For example I develop in small chunks, working with complete transparency through my journal and timesheet. Hopefully generating the trust that I have the skills to do the job and create something worth investing in.

So amongst other things, bugs can be due to:

Coding error – This is what could be construed as a developer’s “mistake”, an error in the way the coding language is used or simply making a typo. But with almost 25 years of programming experience under my belt and several years dedicated to JavaScript these will be minimal.

Limitations on what the technology will let you do – Google Apps imposes various quotas on things like execution time

How the technology is going to react in certain situations – the documentation may not describe our particular scenario and we have to try it out before we see how it actually works

New features breaking an existing one – In a complex system a change in one area may have unpredictable effects elsewhere

User Error – Making the code robust enough to cope with every user input has to be balanced against the time this would take, and if it would actually be possible. So the code may receive input that isn’t expected and act in an unwanted way.

I hope this helps explain how bug-fixing is an integral, equally valuable part of software development, along with designing, coding, testing etc.

If cost is an issue other things to keep in mind are:

Quantifying the savings – compare the actual cost savings the automation continuously generates through reduced admin man-hours, against your investment in software development.

Productising – there are a lot of industries that could find something like [your product] useful, so it could also be worth exploring productising it.

JavaScript has no "Block Scope".  If I ever heard this before, I didn't understand it until now.  I always knew that two or more "for" loops inside of a function can't have a counter variable that is the same name.  (A mistake that is often made)  But I just accepted it as "obvious", not having much experience with other languages.  The block (between the curly braces) in a "for" loop does not have it's own "scope".  The variables inside of one "for" loop, are available to other "for" loops in the same function.  For whatever reason, this "tidbit of information" seemed interesting to me.

Brainiacs - is there a script or add-on already written so that when a user submits a form, they are automatically added to a calendar event that I have set up ahead of time? When teachers sign up for PD, I want them to be added to the event so they can quickly get the video link and directions to the location. I know I'd probably have to create an array with the calendar event ID's for vlookup? Any help would be great! Workflow issue! +Andrew Stillman +Spencer Easton +Bjorn Behrendt  +John Calvert +Jay Atwood +Kory Hopkins 

Can anyone tell me what are the limits for the GAS execution API ? 
We have limits and quotas in the console for other apis but not this one. Also how will the quotas apply if I publish the project as API executable having access to anyone and it runs the app as the user accessing it ?

Google Spreadsheet Question: If we want to use a spreadsheet to keep track of inventory for a school store (positive reinforcement store), can you add a script for plus and minus buttons in the spreadsheet or is there an easier way to add plus and minus buttons to keep track of inventory? #googlespreadsheets   #googlescripts   #gafe  

Can you still use Pagemeister script? If not, is there any script with the same capabilities of making a copy of a google site template for every student?

Post has attachment
Great to see +Andrew Stillman​, who has made some wonderful contributions to the Google Apps Script and education community, get this recognition.

Looking for a script to take form responses and populate another tab on the spreadsheet, like if a student says they are in grade 6 all their info is then populated on the 6th grade sheet?

Is anyone aware of a jobs board for google script-writers for contract hire?  Looking for someone to script a google form from a spreadsheet which populates options depending on entries in  a spreadsheet and creating separate google docs with form responses for each user.
Wait while more posts are being loaded