3. THE DRAGONOMICS TIME-SENSITIVE REMINDER PINGLISTS
PING VOLUNTEERS
Just head to the sheet and copy the contents of the green cell, and then paste it as a reply to this forum topic. It will only ping people who have volunteered for the
next three hours (not the current hour), and only when the sheets are short of data.
This is good if you want to help out and you notice the graphs are looking threadbare, but you are about to leave the house or go to sleep or something.
~*~
BE A VOLUNTEER, GET PINGED
There are three tabs you can add yourself to: treasure fodder, gem fodder, and exchange rate.
If you're up for filling in the form for any of those, click to the appropriate tab along the bottom, and then add your username to the hours of the day (Flight Rising server time!) that you are usually online.
Now people can copy and paste the contents of the green cell into this forum thread, and you'll be pinged and directed to the sheets.
You will only be pinged if you're likely to be online and if the spreadsheets are short of data - but of course, filling in the form is always helpful whether you've been pinged or not!
~*~
STOP PINGING ME DAMNIT
Just go back to the tabs and remove your username! Ctrl+F can help you to find yourself.
~*~
EMBED COPY-PASTE CODE INTO ANOTHER SPREADSHEET
If, like me, you have a spreadsheet to keep track of all your FR junk, you can paste the following into a Google Sheet cell and it will gather the code from the Reminder Pinglist sheet.
Code:
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1k7B3BGvG5hX-y2NDUYLdLdzgmL1hk2VwcwTSedbaGxE","INTRO!F12")
It might take a few moments!
Important: If your Google Sheet has default settings, it will only update that cell automatically when you edit something elsewhere on the sheet ("on change"). So go to
File > Spreadsheet settings... > Calculation > Recalculation and choose "On change and every minute". That'll ensure that the contents of your IMPORTRANGE are always up-to-date.
If it ever breaks, it's probably because I have moved the copy-paste from INTRO!F12, so you might need to go to the original sheet and see where I've moved it to and then update your formula's INTRO!F12 part accordingly. Ping me here if you need help troubleshooting!