HOW TO USE:
- Make a copy! Go to File > Make a new Copy...
It'll give you a little yellow warning that 'Apps Script file and functionality will also be copied; please review the attached script' - this is fine.
- Once it's copied, go to extensions > app scripts.
- In Code.gs, get the ID (in the URL bar, between /d/ and /edit) and replace the value in .openbyID. Make sure to keep the single quotes!
- Save your progress.
- Go to Deploy > New Deployment. You can write a description if you want, but you don't need to!
- Click deploy. It'll come up with a warning saying you need to authorize access to your data. This is because the code doesn't quite know it can take stuff from the spreadsheet.
- You'll need to sign into your google account, and then! Press Advanced, and Go to Codes (unsafe). Press allow, and...
- You're done! You can now copy-paste from the bottom box into a DW entry.
I intentionally made the look simple. You can poke around pkmn.html to modify it! Or you can link me a code and I can try and modify it. Also, I've got credit to the Smogon Sprite project down there because those spriters make the pixel art of Pokemon which match the current sprites I have there. You should use them too! They're neat!
WHEN YOU NEED TO UPDATE:
After entering your new data, go back to extensions > app scripts. Click on deploy > manage deployments. Scroll down to Web App, and click the URL.
To get things like the drop-down for In Party or the auto-calculations of level, select and drag the corner of the box down.
TRAVEL TIMES SHEET:
The second sheet, travel times, is an auto calculator. Enter how many days your character spends in an area, and it'll spit out the date they arrive at the next one. Notes there can be used for whatever - maybe you have a thread you wanna link, perhaps there's an event reason - whatever!