Sorting with column headers
-
Hey guys, after racking my brain trying to figure this out for the better half of my Sunday morning I’m coming to you in desperate need for some fresh brain cells.
I’m embedding the following google sheet into my fathers work website. He basically wants to be able to show clients where they stand in the work queue.
Link to google spreadsheet:
https://docs.google.com/spreadsheets/d/12_4PVWLQHjeh4eraPT8IF1O7FpjlPBN06n4JkKSAIqs/edit?fbclid=IwAR3N4ZkDVkVFloEaOg5iIj48u0-h1MCNLDlz694zGsWtrJDcIkolS-atNTs#gid=1386834576
I was able to embed the spreadsheet with the following
shortcode:
[gdoc key=”https://docs.google.com/spreadsheets/d/12_4PVWLQHjeh4eraPT8IF1O7FpjlPBN06n4JkKSAIqs/edit?fbclid=IwAR3N4ZkDVkVFloEaOg5iIj48u0-h1MCNLDlz694zGsWtrJDcIkolS-atNTs#gid=1386834576″ class=”no-responsive stripe cell-border”]
The issue I’m having is that it appears to be sorting the data in an odd way. I did attempt to sort the data using the shortcode documentation provided on the plugin homepage but it sorted the entire table…
Any help would be greatly appreciated. Thank you -NathanielThe page I need help with: [log in to see the link]
-
I think I may have figured out a simple solution, which is to have him remove the “project list” name and make that the title of the data table. The sorting should then put the first row (indoor/outdoor work) as the theaders and I’m fairly certain I can figure out the data sorting (see documentation for those reading this) to get it to sort by the same column as the spreadsheet itself.
Thank you for your time -Nathaniel
Edit: No I lied, I could still use a fresh set of eyes. Thanks.
- The topic ‘Sorting with column headers’ is closed to new replies.
