Title: Pre-Sort Data
Last modified: March 9, 2018

---

# Pre-Sort Data

 *  Resolved [winterstreet](https://wordpress.org/support/users/winterstreet/)
 * (@winterstreet)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/pre-sort-data/)
 * I’m guessing this isn’t possible, but just checking. Data is coming in from a
   Google Sheet. Any way to have the data sort on one of the columns for the initial
   display? Love the plugin, super handy.

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/pre-sort-data/#post-10055362)
 * Use the `datatables_order` attribute, which maps to [`order` option](https://datatables.net/reference/option/order).
 *  Thread Starter [winterstreet](https://wordpress.org/support/users/winterstreet/)
 * (@winterstreet)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/pre-sort-data/#post-10055377)
 * This might be beyond me, not sure yet. Is this something I’d add to the shortcode
   somehow or to my functions file? (I’m not a developer)
 *  [mauinsons](https://wordpress.org/support/users/mauinsons/)
 * (@mauinsons)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/pre-sort-data/#post-10055438)
 * I was also searching for this option and upon reading Meitar’s reply I tried 
   this:
 *     ```
       {
           "searching": false,
           "paging": false,
           "order": [[ 2, 'asc' ]]
       }
       ```
   
 * as my DataTables defaults object. But the object won’t work once I add the “order”
   option. Did I do it wrongly?
 *  Thread Starter [winterstreet](https://wordpress.org/support/users/winterstreet/)
 * (@winterstreet)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/pre-sort-data/#post-10066534)
 * [@mauinsons](https://wordpress.org/support/users/mauinsons/) is that going in
   your functions.php file?
 *  [mauinsons](https://wordpress.org/support/users/mauinsons/)
 * (@mauinsons)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/pre-sort-data/#post-10068227)
 * [@winterstreet](https://wordpress.org/support/users/winterstreet/) it’s under
   Settings -> Inline Google Spreadsheet Viewer
 * in the “DataTables defaults object” text field.
 * it works fine with
 *     ```
       {
           "searching": false,
           "paging": false,
           "order": [[ 2, 'asc' ]]
       }
       ```
   
 * but not
 *     ```
       {
           "searching": false,
           "paging": false,
           "order": [[ 2, 'asc' ]]
       }
       ```
   
 * so I’m wondering where I can place the “order” code at
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/pre-sort-data/#post-10069197)
 * [JSON](https://json.org/) requires strings be double-quoted. Not `'asc'` but 
   rather `"asc"`.
 *  Thread Starter [winterstreet](https://wordpress.org/support/users/winterstreet/)
 * (@winterstreet)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/pre-sort-data/#post-10069932)
 * Thanks answers my question too, somehow missed the settings page, sorry for the
   trouble.
 *  [mauinsons](https://wordpress.org/support/users/mauinsons/)
 * (@mauinsons)
 * [8 years, 2 months ago](https://wordpress.org/support/topic/pre-sort-data/#post-10080755)
 * [@meitar](https://wordpress.org/support/users/meitar/), thank you so much, it’s
   now working. appreciate your time on helping me out in this

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Pre-Sort Data’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer.
   svg)
 * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/)
 * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/)

 * 8 replies
 * 3 participants
 * Last reply from: [mauinsons](https://wordpress.org/support/users/mauinsons/)
 * Last activity: [8 years, 2 months ago](https://wordpress.org/support/topic/pre-sort-data/#post-10080755)
 * Status: resolved