Monday, June 20, 2011

yogi_Use Spreadsheet Data In A Web Page


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
hackernerd said:
Using Google Spreadsheet data on a website?
I use a Google Spreadsheet to keep track of a list of people and information about them (such as volunteer hours), and I was wondering if it was possible to use this information, that is being constantly updated by several people, on a website.
For example, someone could type their name and their number of hours would be displayed.
---------------------------------------------------------------------------
Here is a picture of Sheet1 which houses the database Table of  volunteers information and HoursWorked

Sheet1


and here is a picture of Sheet2 that captures the LastSubmitted volunteer UserName submitted via the website, and then runs a query to extracts the TotalHoursWorked by the volunteer


Sheet2

 Volunteer will have to SUBMIT his/her name via the following Form:

and the hours worked by the volunteer will be displayed as presented in the following:

No comments:

Post a Comment