I've figured out how to make an embedded google spreadsheet sortable, but I can't get it to be searchable.
http://ybpdatabase.blogspot.com/ is my site, and I have no access to or knowledge of php. In the past I've used another piece of google code to achieve these results (see my table @ http://ybpdatabase.blogspot.com/2012/10/database-search.html), but I had to manually insert each entry, rather than use the simpler embedded spreadsheet. I've posted the current code below. Any help would be great. Thanks!
<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=0AmWD_Na4J_4BdDllczJiVHFibnYwd2FabjhiQmlmZmc');
query.setQuery('SELECT A, B, C, D, E, F, G, H, I, J, K order by A asc label A "Name", B "M/F", C "Class", D "State", E "Height", F "Weight", G "Wing", H "Vert", I "Speed", J "Shot", K "Last Insp."');
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
return;
}
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>