how it could work: we are making largest countriest quiz (for 2025 only)!
so for example maybe in the population column we put
infopage=countrypop2025:datarank=2
(since we must specify the year and if we put 1, we would get the world population)
so this pulls 1,457,435,000 as the number in second place. then for the answer cell we could put infopage=countrypop2025:answerrank=2 and we would get India since india is in rank 2 on that page, behind the world.
Now say next year a billion people move to China, no matter, as China will now be in answerrank=2, and datarank=2 will have the new population, so the quiz will be updated. and if instead of using the 2025 infopage but the real time infopage, it willl be satisfying for the player to see the number increase when they reload the page! and further it will never need to be updated there
(all code shown is an artist's depiction of code, i cant code)
(or whatever the country pop infopage says is it's code)
or instead of code, maybe the quizmaker could click a "link cell to infopage cell" button on the right side, when in a cell. then they can click thru the list of info pages, click to the right year, then click on the correct cell, the population of the most populous country, and set the cell as a normal cell. do it again, click the country at rank one now, and set the cell as answer cell.
this could also make quizmaking much faster (and the convertion of old quizzes to this would be fast too) as you would just copy and paste the code and change the number rank you are looking for
so for example maybe in the population column we put
infopage=countrypop2025:datarank=2
(since we must specify the year and if we put 1, we would get the world population)
so this pulls 1,457,435,000 as the number in second place. then for the answer cell we could put infopage=countrypop2025:answerrank=2 and we would get India since india is in rank 2 on that page, behind the world.
Now say next year a billion people move to China, no matter, as China will now be in answerrank=2, and datarank=2 will have the new population, so the quiz will be updated. and if instead of using the 2025 infopage but the real time infopage, it willl be satisfying for the player to see the number increase when they reload the page! and further it will never need to be updated there
(all code shown is an artist's depiction of code, i cant code)
(or whatever the country pop infopage says is it's code)
this could also make quizmaking much faster (and the convertion of old quizzes to this would be fast too) as you would just copy and paste the code and change the number rank you are looking for