Category: Google Sheets

Google Apps Script: Lite Contacts Directory for Sites or as a Service

A while back I came across a guest post on the Google Apps Developer blog by Steve Webster at Dito which demonstrated an Autocomplete Email Addresses in Apps Script. Not only was this a great demonstration of what you can do with the Apps Script UI but Steve and the guys at Dito had made […]

35 Comments

Protovis Twitter Community Visualizations from a Google Spreadsheet (eAssessment Scotland delegate network)

If you are reading this post on my blog (with a browser other than Internet Explorer) here is a Twitter network diagram for eAssessment Scotland 2011: This is a slight variation on my previous post (Ported: Tony Hirst’s Using Protovis to Visualise Twitter Connections to Google Spreadsheet with Embeddable Gadget) in that instead of using […]

One Comment

Ported: Tony Hirst’s Using Protovis to Visualise Twitter Connections to Google Spreadsheet with Embeddable Gadget

Update: The Social Graph API has been deprecated by Google and Protovis is no longer being developed. I’ve revisited this recipe using new tools in Deprecated Bye-bye Protovis Twitter Community Visualizer: Hello D3 Twitter Community Visualizer with EDGESExplorer Gadget RT @psychemedia: How do folk who send you twitter messages connect? http://bit.ly/dNoKGK < see address bar […]

16 Comments

How it was made: eAssessment Scotland Google Spreadsheet booking form with website and Twitter integration

Even though our RSC is toast after this July we’ve continued our support for the eAssessment Scotland Conference until that time. Our involvement with eAS goes back to the very beginning with 2009’s Strategies across sectors and since then this event has continued to grow becoming the largest UK conference dedicated to e-assessment. For this […]

One Comment

App, App and Away: Workshop Handout #open4ed #GAS

Friday (20th May) was our Open for Education event. There was a real buzz as over 100 delegates squeezed into the NeSC to absorb a packed programme of open and free stuff. Once we get the videos from the event up I should do a separate post to highlight some of the best bits. In the […]

[Work in Progress] Creating a framework for custom form interfaces using Google Apps Script

Over the last couple of weeks in some spare moments I’ve been chipping away at a flexible event form booking system based in Google Spreadsheet. It all started with a need to find a way to take event bookings for some of our bigger events which include parallel session selections. Previously I’d come up with […]

19 Comments

Google Spreadsheets and floating point errors aka when is 65078736491511804 + 1 = 65078736491511808 (and automatically archiving your Twitter Status Updates)

Update: You can ignore most of this post as I noticed the Twitter API can return ids as a string. Here is the updated Export/Archive Twitter Status Updates Spreadsheet I used to use my TwitterPad wordpress plugin to archive everything I said on Twitter. The main reason was often I find myself trying to remember […]

13 Comments

Collect/backup tweets in a Google Spreadsheet on one sheet

A quick recap in June 2010 I hastily threw together a way to archive tweets using Google Spreadsheets. This was okay but a bit flaky. In February (2011) having learned a lot more about Google Spreadsheets and Google Apps Script I reworked the solution producing version 2 Collect/backup tweets in a Google Spreadsheet. I would […]

13 Comments

Export Twitter Followers and Friends using a Google Spreadsheet

Note: Twitter recently wrote to me reminding me that methods of obtaining and exporting Twitter content obtained via the Twitter API is prohibited by section I.4.A of our API Terms of Service (https://dev.twitter.com/terms/api-terms ), specifically: You will not attempt or encourage others to sell, rent, lease, sublicense, redistribute, or syndicate access to the Twitter API or […]

288 Comments

Turning Google Spreadsheets into a personal or group bookmarking service

Recently Yahoo announced that it was going discontinue/sell their Delicious bookmarking service. This led to a swath of messages in my networks by people looking for alternatives and strategies for getting their stuff out. This isn’t a post about how you can get your Delicious bookmarks into something different (most of the other bookmarky sites […]

19 Comments
« Previous Page — Next Page »
css.php