codeforkansascity / codeforkansascity.github.io

Code for Kansas City Website
http://codeforkc.org
8 stars 18 forks source link

Fix parsing from multi-worksheet workbook #35

Closed johnkary closed 6 years ago

johnkary commented 6 years ago

This PR fixes #34, which I believe was caused by the target Google Sheets Workbook having multiple worksheets instead of one worksheet. The "NEW" CodeForKC Workbook has multiple sheets, where as the "LIVE" Workbook only had one.

The code was using the TableTop flag simpleSheet:true when switching to the new Worksheet. This PR flips that flag to false, and explicitly asks for Worksheet "Project Information".

This PR also updates the "key" to use the "NEW" Worksheet from Google Drive to power content on the website. So any future changes to the live site should be made on the NEW sheet. (Perhaps renaming this worksheet is in order.)

🚀

zmon commented 6 years ago

Thank you John.