Forums

Clan google assist sheets

Quick find code: 135-136-898-65701593

of 8
II XP II
Jun Gold Premier Club Member 2011

II XP II

Posts: 1,001Mithril Posts by user Forum Profile RuneMetrics Profile
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.)
Serenity Isle Clan. - - -
Google assist sheets link here

08-Sep-2017 20:35:46 - Last edited on 08-Sep-2017 20:43:44 by II XP II

II XP II
Jun Gold Premier Club Member 2011

II XP II

Posts: 1,001Mithril Posts by user Forum Profile RuneMetrics Profile
Just an update about the asked for
Citadel capping scanner
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.

:P

Resent updates forum post about this data
Quick find code: 15-16-596-65949167
Serenity Isle Clan. - - -
Google assist sheets link here

13-Sep-2017 15:51:50 - Last edited on 14-Sep-2017 13:03:56 by II XP II

MrDiscerning
Nov Gold Premier Club Member 2015

MrDiscerning

Posts: 824Gold Posts by user Forum Profile RuneMetrics Profile
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.
Leader Of
Endless Realm ,
Weekly Prizes ,
Capping Always Appreciated ,
OffSite Website: 1endlessrealmclan

22-Oct-2017 21:15:16 - Last edited on 24-Oct-2017 05:11:52 by MrDiscerning

MrDiscerning
Nov Gold Premier Club Member 2015

MrDiscerning

Posts: 824Gold Posts by user Forum Profile RuneMetrics Profile
Hi, i didnt receive nothing so idk unless in my junk i check there lol umm nope nothing in my email box nothing at all so,,,,,,
Leader Of
Endless Realm ,
Weekly Prizes ,
Capping Always Appreciated ,
OffSite Website: 1endlessrealmclan

24-Oct-2017 05:12:20 - Last edited on 24-Oct-2017 05:18:11 by MrDiscerning

II XP II
Jun Gold Premier Club Member 2011

II XP II

Posts: 1,001Mithril Posts by user Forum Profile RuneMetrics Profile
@ 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.
Serenity Isle Clan. - - -
Google assist sheets link here

24-Oct-2017 09:39:41 - Last edited on 24-Oct-2017 20:22:40 by II XP II

MrDiscerning
Nov Gold Premier Club Member 2015

MrDiscerning

Posts: 824Gold Posts by user Forum Profile RuneMetrics Profile
@ ll xp ll, hi i requested access hopefully i went to right clan looks like i did, and hopefully you can help me fix this google spreadsheet for me, thanks cheers
Leader Of
Endless Realm ,
Weekly Prizes ,
Capping Always Appreciated ,
OffSite Website: 1endlessrealmclan

25-Oct-2017 00:36:33

II XP II
Jun Gold Premier Club Member 2011

II XP II

Posts: 1,001Mithril Posts by user Forum Profile RuneMetrics Profile
@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 "
Settings
" (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.
:P
Serenity Isle Clan. - - -
Google assist sheets link here

25-Oct-2017 14:05:42

MrDiscerning
Nov Gold Premier Club Member 2015

MrDiscerning

Posts: 824Gold Posts by user Forum Profile RuneMetrics Profile
Hi i don't know if you did anything but it's fixed?? idk thanks if you fixed it, and ya i couldn't remember if the script was yours or the someone else's lol

anyways thanks, much appreciated
Leader Of
Endless Realm ,
Weekly Prizes ,
Capping Always Appreciated ,
OffSite Website: 1endlessrealmclan

26-Oct-2017 02:58:30

Quick find code: 135-136-898-65701593Back to Top