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.
---------------------------------------------------------------------------
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
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
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:
 |
| 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