/pokemon-trading-spreadsheet

Primary LanguageJavaScriptMIT LicenseMIT

Pokémon Trading Spreadsheet

A script made to display Pokémon trading information stored in Google Sheets

Features

  • Display breedables, valuable Pokémon (e.g., shinies or RNGs), or your NFT collection
  • Faster loading than sharing a Google Sheets document
  • Filter Pokémon by generation, gender ratio, Poké Ball, Egg Group, shinyness, etc.
  • Search for Pokémon by name (thanks to Armienn)
  • Generate a Reddit table to share just the Pokémon you want

How to Use

Preparation

  1. Create a copy of this spreadsheet (File > Make a Copy…).
  • Be careful with the 1st row (headers) of each sheet! Read the FAQ before renaming or removing any column.
  • Name your sheets in the following format "FT:Name of my sheet", "LF:Name of another sheet" or "NFT:Yet another sheet". They will be sorted by the script.
  • You may duplicate the "TEMPLATE" sheets (up to a maximum of 8 tabs).
  • Do not move or rename the "CONFIG" or "DB" sheets.
  1. Fill in "CONFIG" tab and start adding your Pokémon.
  2. Make your spreadsheet public (File > Publish to the web…).

See Demo below if you're unsure of how to fill the spreadsheet and read the FAQ to learn some cool tricks.

Method 1: Beginner

Find the ID of your spreadsheet and paste it at the end of this link: https://pokemon-trading-spreadsheet.tumblr.com/?spreadsheet-id

Example: https://pokemon-trading-spreadsheet.tumblr.com/?1P9wMb9e0YbhcOua9RQeRCJjllf_L77uV-7i4Q0Yor0o

That's it! Share the resulting link with your potential trade partners.

Method 2: Advanced

Use any of the following methods if you want a custom URL or want to make changes to the script/styling.

Method 2A: Tumblr

  1. Create a new Tumblr blog and go to Account > Edit Appearance > Edit theme > Edit HTML.
  2. Copy this and then click Update Preview followed by Save.
  3. Edit the Theme Options with your spreadsheet's ID and personal information.
  4. Go to Advanced Options and set Use default mobile theme to false.
  5. Click Exit and you're set to share your Tumblr link.

Do note that Tumblr's Preview does not work with this theme. You will not be able to see your Pokémon while the theme is being applied.

Method 2B: GitHub Pages

  1. Clone this repository.
  2. Edit config.js with your spreadsheet's ID and personal information.
  3. Publish or perish (go to Settings and set the Source to master branch under the GitHub Pages header).

Method 2: How to Update

This is only for those using Method 2. If you're using Mehtod 1, any changes here will be reflected automatically.

If there's been an update, you will need to replace files on your end with the new ones. For Tumblr users, this means copying again the theme. Those using GitHub Pages will have to download the files I have edited and upload them to their repository.

Demo

Google Document → Result

Changelog

  • 2017.2.3.0 Game marks (e.g., Blue Pentagon, Black Clover, Pokémon Go, and Virtual Console) are now supported. Feel free to update your spreadsheet accordingly.
  • 2017.1.27.0 EVs (if available) are now displayed below IVs. I have also added Previous/Next buttons when a Pokémon's additional is displayed. Arrow and HJKL keys may also be used for navigation. The "Notes" field may also hold links in the following format: [link text](http://github.com). Reddit usernames and subs are also automatically detected and converted into links.
  • 2017.1.20.0 Made compatible with Armienn's project. Added an Egg Group filter and the possibility of renaming some columns. Also, tabs for valuable Pokémon may now store Moves and Egg Moves.
  • 2017.1.15.0 Added Legend/Sub-Legend filter, Reddit table, and support for Hypertrained stats. Other undocumented changes I'm probably forgetting about right now were rolled in too.
  • 2017.1.6.0 Tabs without a prefix ("FT:", "LF:", or "NFT:") are now supported.
  • 2017.1.5.0 Added a search bar and support for NFT tabs (once again, thank you to Armienn). Fixed Alolan Raichu's model and added minor customization to Tumblr theme.
  • 2017.1.4.0 Added support for more than 3 tabs (thanks to Armienn). Added extra filters and fixed Hidden Abilities of Pokémon with an Alola Form.
  • 2017.1.3.0 Fixed Pokémon model for those with special characters in their name. Also added support for Pokémon with models with gender differences.
  • 2017.1.2.0 Initial release.

Pokémon is © of Nintendo, 1995-2017.