Hello friends! I come bearing gifts in the form of a Hatchery Auto-BBCoder!
I was a teensy bit inspired by frillshark-fr (on tumblr) who made a lovely G1-selling auto-coder in a similar fashion, so I went ahead and picked up some Sheets knowledge after not touching Excel since the 8th grade ^^;
To be honest, they really don’t have to be just for hatchlings. The format is nice enough for any dragon you might want to sell on the forums! Oh, but be sure to read the little notes attached to some of the cells so you get a better understanding of what the absolute heck I’m talking about, or to better your code so your images don’t break or your post doesn’t get a little screwy! If for whatever reason you can’t read them on the document, I’ll leave them in a quote below. For now, here’s the link, as well as an example of what your end result may be! You’ll have to copy the sheet (under File, Make a copy…) as I have it on view-only to prevent any vandalism.
Link: https://docs.google.com/spreadsheets/d/1GHAoE__hNt-HR2w7iMJPwVTYFDZZ-lI0EZeh28NnTXQ/edit?usp=sharing
I was a teensy bit inspired by frillshark-fr (on tumblr) who made a lovely G1-selling auto-coder in a similar fashion, so I went ahead and picked up some Sheets knowledge after not touching Excel since the 8th grade ^^;
To be honest, they really don’t have to be just for hatchlings. The format is nice enough for any dragon you might want to sell on the forums! Oh, but be sure to read the little notes attached to some of the cells so you get a better understanding of what the absolute heck I’m talking about, or to better your code so your images don’t break or your post doesn’t get a little screwy! If for whatever reason you can’t read them on the document, I’ll leave them in a quote below. For now, here’s the link, as well as an example of what your end result may be! You’ll have to copy the sheet (under File, Make a copy…) as I have it on view-only to prevent any vandalism.
Link: https://docs.google.com/spreadsheets/d/1GHAoE__hNt-HR2w7iMJPwVTYFDZZ-lI0EZeh28NnTXQ/edit?usp=sharing
Cell Notes wrote:
ID Last 2 Rounded Up - For certain URLs. Take the last two numbers of your dragon’s ID, delete them, then add +1 to the new number. For example: take ID 41217772. Delete the last two numbers, 7 and 2, and you are left with 412177. Finally, add +1, and you have your new ID of 412178. Simple!
Image URL - Remove everything at the end until you reach “.png”, or the image will break!
Treasure Price - Gonna have to add the comma yourself in the final code if you want it. Silly sheets!
Gender - All lowercase, or the icon will break!
BBCode - When you copy/paste, there will be quotation marks at the beginning and end of the code. Just remove them and everything should be fine ^^
Image URL - Remove everything at the end until you reach “.png”, or the image will break!
Treasure Price - Gonna have to add the comma yourself in the final code if you want it. Silly sheets!
Gender - All lowercase, or the icon will break!
BBCode - When you copy/paste, there will be quotation marks at the beginning and end of the code. Just remove them and everything should be fine ^^
|
  
|
|
 
|
