I have been working on this for a few days and haven't been able to get it to work with online tutorials.
I am trying to recreate our Team Board that we use in our department. Right now we walk over to the wall and write with a dry erase marker our issues and wait for them to be reviewed by the supervisor at the morning meeting. I wanted to make an online version of this, but using Google Docs Spreadsheet rather then MySQL.
I learned how to retrieve data from a Google Docs Spreadsheet, but not writing to it in a way I understand.
Here is my form and code for retrieval, what JavaScript/php code will get the form data entered into the spreadsheet. I would also like to be able to update lines after they have been listed, so I was thinking of a radio button check box option for new/update would be good.
Code:
<h2>Team Board, Top Issues</h2>
        <form id="form2" method="post" action ="team_board.php"> 
	<p><label for="date">Today's Date:
    <input id="date" name="date" type="date" />
    </label></p>
    <p><label for="issue">Issue: <input id="issue" name="issue" type="text" /></label></p>
    <p><label for="action">Action: <input id="action name="action" type="text" /></label></p>
    <p><label for="contact">Contact: <input id="contact" name="contact" type="text" /></label></p>
    <p><label for="status">Status: <input id="status" name="status" type="text" /></label></p>
    <input type="submit" />
    </label>
    
    </form>
    <script type="text/javascript" src="http://www.google.com/jsapi"></script>
    <script type="text/javascript">
    google.load('visualization', '1', {packages: ['table']});
    </script>
    <script type="text/javascript">
    var visualization;
    
    function drawVisualization() {
    
    var query = new google.visualization.Query(
    'https://docs.google.com/spreadsheet/ccc?key=0Aq2gYU6C_M2jdEVmWnVuLVdqNDZZdnlYeGd2ZXBCdkE&usp=sharing');
    
    query.setQuery('SELECT A, B, C, D, E, F ORDER by A ASC LABEL A "ISSUE #", B "DATE", C "ISSUE", D "ACTION", E "CONTACT", F "STATUS"');
    
    query.send(handleQueryResponse);
    }
    
    function handleQueryResponse(response) {
    if (response.isError()) {
    alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
    return;
    }
    else {
    var data = response.getDataTable();
    
    visualization = new google.visualization.Table(document.getElementById('table'));
    visualization.draw(data, {legend: 'bottom'});
	}
    }
    
    google.setOnLoadCallback(drawVisualization);
    </script>
    
    <div id="table"></div>
Josh