Hi Mc Theman, Ok well if your trying to create yourself a sheet for personal use, I'm happy to assist you in getting the basic data for you to manipulate. I will knock up a very basic google sheet, with the formula and downloads that you will need. How you use and set up the data will be up to you. Have fun and I hope this gets you on your way to a helpful sheet. Remember to look at the Runescape API on wiki for clarification on the downloaded data. Let me know if you need any more info, or if I have not explained something correctly.
I will add the sheet to the bottom of my links on our off site, "serenityisleclan" forum in the "Help/Advice" section. As a temperary link.
(I may have a play around with this sheet too myself, if I get time. But its not a priority for me, more a curiosity.)
sheet to work off the recent adventure log update. I have created a beta version for us to check out, its basic at the moment as I expect some tweaks maybe in the future. Plus it's been a few days before any citadel results appeared on the adventure log.
Resent updates forum post about this data Quick find code: 15-16-596-65949167
Hi, i'm having trouble with my google spreadsheet, the script is not automatically updating anything and been like it for past month. I get emails from google for notifications and when i click on link it brings me settings etc for time change and i changed everything in between, however i went to our website spreadsheet and when i manually update spreadsheet i get a error saying getrange
So any help be much appreciated because i would love to get spreadsheet updating like it always has been for past year.
Endless Realm ,
Weekly Prizes ,
Capping Always Appreciated ,
OffSite Website: 1endlessrealmclan
- Last edited on 24-Oct-2017 05:11:52 by MrDiscerning
@ Owner McCoy, ok the best thing to do then is open up one of my demo sheets. And request access to it, it does not matter which one. That will auto send me a request email from you. Then I can reply to the correct email. Or pm in game and we can sort it out there. Or post a comment on my reaction feedback poll.
@Owner McCoy Hi and no message to me, Ive never had such a problem getting in touch with someone before.
Any way, I chose to get to the sheet another way. I looked at your clans web site, and noticed you have a template of your google sheet there. So I took a copy
(I won't tell you how I did that!)
But it did allow me to have a look at your script. The good news is that the script is fine from what I can see
(its not one of mine)
, but the sheet is missing a tab, so you need to insert another tab sheet called "
" (Make sure of a capital S at the beginning). It may have been removed, thinking it was not doing any thing, or renamed for better clarity by someone. Other sheets that must not be renamed are :- "Current Clan List" and "Clan Log"
I have no idea if you need or have auto script triggers set up, but I'm sure you can reply if there is a problem.
I did contact members in your clan to post my gmail into a post on your clan forum for you to pick up. Not sure if that happened?
So in short, add a new tab called "Settings" and call the script. It will probably prompt you for the clan name on the first run. (You can right click the tabs name and select 'hide sheet' if you just don't want to see it, or for it to be removed again by mistake.) Hope this sorts out your problem.