Google Apps Script
I was talking with a potential customer who had need to manage a complex system for employee scheduling and timecards. It got me researching the topic to find possible solutions. I discovered a nice TimeKeeper project over at github. The TimeKeeper example creates a simple (mobile) web site form to add simple data. Data is stored in google sheet named “timeSheet”. It will add events to google calendar and email you every saturday a digest to help you keep track of time.
For anyone not familiar with Google Script Apps, there is a lot of information available online.
To run this sample: (reference)
- Open up your browser to google.com
- Ensure you are logged in to Google. (check upper right hand corner of the page.)
- Click on the 3×3 box icon, then select Google Drive.
- Select New –> More –> Google Apps Script
- Copy the contents of code.gs file from this repository to your script.
- In the script editor tool, choose File –> New –> HTML file. This will create a new tab in your editor.
- Copy the contents of index.html from this repository to your new html file.
- Save all files, give your project a name.
- “Once that basic framework is in place, all you have to do is save a version of your script, then deploy your script as a web app.” See instructions at https://developers.google.com/apps-script/guides/html/
(Note: I’ve suggested the instructions above be added to the README.md file on the github repository, but that doesn’t seem to be there yet…)