SHEETS dragon image w/ only ID | Guides

HELLO i've figured out how to add a dragon's image with only an ID, so instead of copy pasting both the dragon's ID and the image url into a spreadsheet, you can input the ID and have it add the dragon's image for you. [code] =IMAGE(CONCATENATE("https://www1.flightrising.com/rendern/350/",(LEFT(A1,((LEN(A1))-2))+1),"/",A1,"_350.png")) [/code] The reason this is annoying to automate is because each dragon has a "mystery number" in all of their image links. The "mystery number" is what i had difficulty with, but it seems to just be the id, 2 digits less, then +1. So if the dragon's id is 123456789, the "mystery number" would be 1234568 [url=https://docs.google.com/spreadsheets/d/1kwo4E8ENMvTdlA3pYlf5f1McbHBWP8bhWAfd1r4WvVQ/edit?usp=sharing]Here's the google sheets with some more examples, and if you'd like to copy/paste/modify[/url] [sub]mostly posting this to hopefully save someone else from googling trouble[/sub]. and if there's any errors, or if you have any advice, let me know please!

Greem

393

277

709

194

December 30, 2023 22:58:58

HELLO i've figured out how to add a dragon's image with only an ID, so instead of copy pasting both the dragon's ID and the image url into a spreadsheet, you can input the ID and have it add the dragon's image for you.

Code:

=IMAGE(CONCATENATE("https://www1.flightrising.com/rendern/350/",(LEFT(A1,((LEN(A1))-2))+1),"/",A1,"_350.png"))

The reason this is annoying to automate is because each dragon has a "mystery number" in all of their image links.
The "mystery number" is what i had difficulty with, but it seems to just be the id, 2 digits less, then +1. So if the dragon's id is 123456789, the "mystery number" would be 1234568

Here's the google sheets with some more examples, and if you'd like to copy/paste/modify

_{mostly posting this to hopefully save someone else from googling trouble}. and if there's any errors, or if you have any advice, let me know please!