Community Wad Progress
Posted: 23 Sep 2016, 14:10
This isn't really a "programming" topic, but there's not a very good place for general discussion, so here's where it's going.
I did in fact work on a progress spreadsheet in Google Sheets. I even got it working pretty well after only about a day. However, I ran into a small snag. The issue was that the menu functions I made for it appear to try to run under the account of the person viewing the sheet rather than my account. This means that, even though it never tries to access personal or private files (it's hard-linked to the my folder with the folder's ID, so it doesn't even interact with my personal files), it still thinks that's what's going on. So, I asked for assistance on Google's forums, but I didn't get a helpful reply.
So, be warned that if you try to run the functions, then it'll ask for authorization, and there's nothing I can about that, except to say that if you don't like that, you can still view the sheet, you just can't run the functions that update the sheet.
I'm still planning to do a little bit more work on these, since currently the functions aren't helpful to anyone else anyway. That's because they rely on a certain set of files I've created which list out any and all cards for every set, and then mark those cards as done, not done, core cards (base game), or impossible. My Google Sheets script functions can parse all of this and turn it into a spreadsheet we can actually work with.
The things I'm currently planning to change are to create a link to the cards' gatherer entries, make my local files update as new cards are added through the Auto-Upload folder (so the spreadsheet can update daily, or hourly, or on command), and maybe add in some more information.
So, without further ado, here's the spreadsheet. Please have a look and let me know what needs altered.
https://docs.google.com/spreadsheets/d/ ... sp=sharing
Note that while only those with edit access to the CW can actually change the sheet, anyone can comment on it. So, let me know what you think.
I did in fact work on a progress spreadsheet in Google Sheets. I even got it working pretty well after only about a day. However, I ran into a small snag. The issue was that the menu functions I made for it appear to try to run under the account of the person viewing the sheet rather than my account. This means that, even though it never tries to access personal or private files (it's hard-linked to the my folder with the folder's ID, so it doesn't even interact with my personal files), it still thinks that's what's going on. So, I asked for assistance on Google's forums, but I didn't get a helpful reply.
So, be warned that if you try to run the functions, then it'll ask for authorization, and there's nothing I can about that, except to say that if you don't like that, you can still view the sheet, you just can't run the functions that update the sheet.
I'm still planning to do a little bit more work on these, since currently the functions aren't helpful to anyone else anyway. That's because they rely on a certain set of files I've created which list out any and all cards for every set, and then mark those cards as done, not done, core cards (base game), or impossible. My Google Sheets script functions can parse all of this and turn it into a spreadsheet we can actually work with.
The things I'm currently planning to change are to create a link to the cards' gatherer entries, make my local files update as new cards are added through the Auto-Upload folder (so the spreadsheet can update daily, or hourly, or on command), and maybe add in some more information.
So, without further ado, here's the spreadsheet. Please have a look and let me know what needs altered.
https://docs.google.com/spreadsheets/d/ ... sp=sharing
Note that while only those with edit access to the CW can actually change the sheet, anyone can comment on it. So, let me know what you think.