Forums

Clan List Logger

Quick find code: 86-87-226-65189098

Ebram 72

Ebram 72

Posts: 10,770 Opal Posts by user Forum Profile RuneMetrics Profile
Thanks a lot man. Other than overloading the sheet with info, is there any other side effect to having it set to every min?

And one last request; I tried your code, but I've never worked with coding on sheets, so not sure how it'd work.
I tried, but it's not working.
Can you please tell me how to make the memberlist appear (with the function you had provided on page 27) on this sheet:
https://docs.google.com/spreadsheets/d/1E0mV5p1ls5GeqSkVmiIko3_qYwJtoZ5WPLmnaAhV3pk/edit?usp=sharing

Thanks :)
Founder of
¤'•,¸
72
¸,•'¤

Ebram 72

07-Dec-2014 16:00:48

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
Tools -> Script editor...

paste this:
Original message details are unavailable.
function getMembership(obj){
return [["Name","Rank","Member","Total XP","Kills","Online"]].concat(obj.map(function(a){return a.join("" )}).join("" ).split("membersListRow" ).slice(1).map(function(row){var col=function(cls){return row.match(RegExp('"'+cls+'">([^<]*)'))},name=col("name" ),member=/pro\.png/.test(row),rank=col("clanRank" ),totalxp=col("totalXP" ),kills=col("kills" ),world=col("world" );return [name[1],rank[1],member?"Member":"",parseInt(totalxp[1].replace(",","" )),parseInt(kills[1]),world[1].replace(/\ n/g,"" )]}))
}


then use getMembership(importData([url goes here]));

­­­­­­­­­­­­­­­­­­­­­­­­ .:
Blasty
the Blue
:.­­­­­­­­­­­­­­­­­­
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of Mine Nation

08-Dec-2014 00:38:30 - Last edited on 08-Dec-2014 02:15:46 by Blasty

Freud

Freud

Posts: 6,469 Rune Posts by user Forum Profile RuneMetrics Profile
Heya Blasty!

First of all seasonal greetings!

Is it possible to create a spreadsheet that automatically adds and removes clan members (if they join/leave)?

Thanks!
.......:::::::;;;;;;;;
¸.·°´¯`°·.¸
;;;;;;;:::::..
Freud
;;;;;;;:::::::....
¸.·°´¯`°·.¸
.......::::::;;;;;;
`°·.¸
Clueless Adventurers
¸.·°

24-Dec-2014 23:07:18

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
Heyy,

Do you mean make it so that when people leave or join, information in other columns also shift around to reflect changes in the name column?

It's been asked a lot but it's complicated because it'd require either a perfect ability to determine name changes (perfect isn't really possible without some help from an API), or the ability to manually make these changes (but with automation to help deal with information merges, undoing mistakes and other weird things that could happen).

Google sheets is free to use, customizable and easy to distribute but to get it to that point will take a lot of work.

Maybe I could try to make something separate specifically for storing information on clanmates, with name changes accounted for, and see how that goes.

­­­­ .:
Blasty
the Blue
:.­­­
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of Mine Nation

25-Dec-2014 02:47:34

Freud

Freud

Posts: 6,469 Rune Posts by user Forum Profile RuneMetrics Profile
Blasty said :
Heyy,

Do you mean make it so that when people leave or join, information in other columns also shift around to reflect changes in the name column?

It's been asked a lot but it's complicated because it'd require either a perfect ability to determine name changes (perfect isn't really possible without some help from an API), or the ability to manually make these changes (but with automation to help deal with information merges, undoing mistakes and other weird things that could happen).

Google sheets is free to use, customizable and easy to distribute but to get it to that point will take a lot of work.

Maybe I could try to make something separate specifically for storing information on clanmates, with name changes accounted for, and see how that goes.

­­­­ .:
Blasty
the Blue
:.­­­


Yep like that! Cause my clan is gonna switch to a point ranking system so it would be a pain to have to add and remove whenever somebody joins or leav3s
.......:::::::;;;;;;;;
¸.·°´¯`°·.¸
;;;;;;;:::::..
Freud
;;;;;;;:::::::....
¸.·°´¯`°·.¸
.......::::::;;;;;;
`°·.¸
Clueless Adventurers
¸.·°

25-Dec-2014 05:56:59

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
Hey Leaders,

Sorry for the lack of updates but my interests have changed so I don't think I'll be looking into adding any features in the near future.

If anyone would like some tips on learning how to make their own similar tools I'll gladly let you know how I came to this point self-taught.

The logger is still super handy for my clan and I hope other clans have found it as useful as I have :)

­­­­ .:
Blasty
the Blue
:.­­­
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of Mine Nation

14-Jan-2015 14:51:05

Quick find code: 86-87-226-65189098 Back to Top