I’m co-working with Katie today in a Brooklyn Cafe. An old friend Pablo ran into us and we got to talking about our upcoming trip to Spain and what each of us are working on. Pablo revealed that he is working on relief work for Puerto Rico and that they needed a map. I’ve gotten really good at setting up maps recently, you can read more about how I do it here.
Pablo called up his contact, shared a Google spreadsheet and in a few minutes I had this map setup based on a spreadsheet of donation drop off locations across the US maintained by Pablo’s team. See it after the jump. Read more
In this tutorial you’ll learn how to take the Awesome Table from we created in Part 2 and embed it on a WordPress website. Of course this will work with any Awesome Table, no matter what. Read more
In this tutorial we will learn how to create an online Google Form that feeds data into a Google Spreadsheet which will then be attached to an Awesome Table which will be configured to display the form entries as points on a map. These map markers will have popup tool tips that display other data from the spreadsheet. All of this will be dynamic, updating every time a new entry is submitted. Read more
In this example we will play with our list of US Senators so that it has a number of filter options and displays their picture in the row. All the data will be managed through our Google Spreadsheet, when the spreadsheet is updated so too will the list, no matter where it is online! You’ll need a spreadsheet with data already setup, which we did in Part 1: Setting up your Awesome Table. Read more
Have you ever needed to share a body of dynamic data with the world? Maybe a list of local representatives and how they pledge to vote on an upcoming piece of legislation. Perhaps you are trying to organize distributed activities across the city and need a way to display them on a map. When it comes down to it, most data can be expressed in a spreadsheet, and you’ve probably worked on plenty of spreadsheets. Have you ever wished you could just share the data on a spreadsheet with your collaborators or the whole world? Have you ever wished you could share all the updates you make as they happen?
Well you can. With Google Spreadsheets and Awesome Tables you have the power to create rich dynamic displays based off spreadsheet which can be added to directly or via online forms. All the data in one place, displayed anywhere on the web, updated in real time!