Google Spreadsheet and DataTables

davidbarczak

I came upon a post on "Data for Radicals" on making google spreadsheets searchable. This started me in the right direction. But I have a question regarding the post. Is there a way to alter the default "ascending" order of the first column of the table to be "descending"?

I have the original post listed below is where I have gotten my information: "http://dataforradicals.com/the-absurdly-illustrated-guide-to-sortable-searchable-online-data-tables/"

The page I am working on is : "http://www.udel.edu/gradoffice/academics/dissdefense-test4.html".

I would like the "date" column to be the most current to least current, basically "descending order". If you could help I would appreciate it. Thanks again for your wonderful work.

By the way I am very new to this so any help would be appreciated. Here is a link to the original tabletopfeed.js file that has a lot in there: "http://www.udel.edu/gradoffice/academics/scripts/tabletop-feed.js"

David Barczak
Communication Manager
University of Delaware

davidbarczak

By the way, since google has updated its spreadsheet around August 22 the code that is listed in a number of examples really doesn't work anymore. Can anyone ahead some light on how to use the new embed code?

Example:
Old:

$(document).ready(function() { $('#example').dataTable( { "bServerSide":false, "bProcessing":true, "sAjaxDataProp": "feed.entry", "sAjaxSource": "https://spreadsheets.google.com/feeds/list/0Ah5i4flVQwqEdHVRU0ZFWnVDSjVIaXdyNjJQR2ZtbEE/od6/public/values?alt=json", "aoColumns": [ { "mDataProp": "gsx$carmake.$t" }, { "mDataProp": "gsx$model.$t" }, { "mDataProp": "gsx$year.$t" }, ] } ); } );

New Google Spreadsheet Embed Code:

https://docs.google.com/spreadsheets/d/1P7TAS2OZ-1DBEV9qGnpEu-GArezAUuFkqgFhnQdOnJI/pubhtml