forums.rs

Forums

Clan google assist sheets

Quick find code: 135-136-898-65701593

of 10
II XP II
Jun Member 2011

II XP II

Posts: 1,038 Mithril Posts by user Forum Profile RuneMetrics Profile
Hi ZBUG, of course you can scrape data from a google sheet, but I think you may need to make the data into a table format, as thats what most of the web code uses for data transfer.
Or better still download the data directly from the runescape API.

However, I'm not an HTML coder so I'm not the right person to ask.
I'm sure there are data scraping apps that might be useful?
Personally I think I would use another google sheet, or a google website to import the data I needed. But I find the shared sheets give the info in a format I like.
Let me know if you have any success in this area.
:)
Serenity Isle Clan. - - -
Google assist sheets link here

21-Jun-2017 09:12:46

Werewolf
May Member 2022

Werewolf

Posts: 20,258 Opal Posts by user Forum Profile RuneMetrics Profile
Just found your points sheet which looks very useful it says its by XP to earn points but we use citadel caps recruitment bumping thread etc... For points to there a way to do this with that sheet
•*º*•‹•*º*•
When the Full Moon Rises
•*º*•›•*º*•
¸,.›°ˆº•-,._.,-•ºˆ
Blood will rain down
ˆº•-,._.,-•ºˆ°•.¸
•*º*•‹•*º*•
Beware the Wolves Howl, This will be your final sound
•*º*•›•*º*•

13-Aug-2017 00:03:13

II XP II
Jun Member 2011

II XP II

Posts: 1,038 Mithril Posts by user Forum Profile RuneMetrics Profile
Hi Werewolf, If you copy yourself the sheet named
"
Runescape demo of clan ranks by points PLUS (With Script)
"
for example you could set the '
base points from xp
' to zero, (on the "
settings manual input
" tab.)
Then you could assign points for capping etc on the "
added points"
sheet.

This would cause a Div by zero error on columns G - H - Q - R on the "
Current tab
", but you could just overmark those columns, right click and hide them I guess. I case you decide to add the clan xp at some later date.
Any problems or suggestions, please post here or pm in game.
All these sheets are basic starter sheets to get you going, many folk add and change things about to suit their clan.

Addition
: there was also a clan
"event tracker"
tab added to the following sheet that might be of interest too.
"
Runescape demo of clan changes and events (With Script)
"
Serenity Isle Clan. - - -
Google assist sheets link here

13-Aug-2017 08:42:49 - Last edited on 13-Aug-2017 11:12:13 by II XP II

II XP II
Jun Member 2011

II XP II

Posts: 1,038 Mithril Posts by user Forum Profile RuneMetrics Profile
Hi Mc Theman,
We used to be able too several years ago, there was a true or false flag. But that data was removed from the query results. The only additional data added to the query string data, was who had the jack of trades title. Kindoff useles and pointless.
But I agree and understand from many clan leaders that this ftp feature would be useful.
The only way at the moment is to physically look at the clan mates on the clanmates list via the rs website.

Many clan leaders now use the inactive recorder sheet, together with the dead account sheet to determin who may have left the game. But there seems to be no other way to tell who maybe ftp automatically any more.

Apart from one clever leader insisting that all new members have an avatar picture taken, instead of the std starting ftp grey helmet. This was to dig out any starting ftp, but is not a complete fix if a player was a member and then went ftp later.
Serenity Isle Clan. - - -
Google assist sheets link here

26-Aug-2017 08:09:44

II XP II
Jun Member 2011

II XP II

Posts: 1,038 Mithril Posts by user Forum Profile RuneMetrics Profile
HI Mc Theman,
There is some data that you can download from the runescape API, such as quests started, completed or not started as a number.
Plus a players quest data, list of quests, quest status, difficulty and points rewards and eligibility to start a quest.

So in essance YES there is the capability, but as the data is
not available if the players view status is set to private
, I see little point in providing something that runemetrics already supplies. Unless you have something specific in mind?
Serenity Isle Clan. - - -
Google assist sheets link here

06-Sep-2017 19:40:29 - Last edited on 06-Sep-2017 19:50:48 by II XP II

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