forums.rs

Forums

Clan List Logger

Quick find code: 86-87-226-65189098

of 36
E Bom

E Bom

Posts: 740 Steel Posts by user Forum Profile RuneMetrics Profile
RaisinDebtor said :
I had a look through but I can barely follow what causes what, especially since I'm not familiar with the language (in the scripts). I'd really like to see an xp tracker added to detect inactive members and figure out how long they have been inactive. It would work similar to the current log method but I can see how it is a slightly different principle.

This is just a wish list, but if anyone made it I would be so happy :P

u can do that urself so easily. just log the exp once a month and sort through 0 exp gainers. If you have to deal with f2p, then it's pretty much manual labor logging their stats, and I'm not going to even get into name changers lol

06-Dec-2013 06:25:32 - Last edited on 06-Dec-2013 06:28:54 by E Bom

RaisinDebtor

RaisinDebtor

Posts: 1,310 Mithril Posts by user Forum Profile RuneMetrics Profile
E Bom said :
RaisinDebtor said :
I had a look through but I can barely follow what causes what, especially since I'm not familiar with the language (in the scripts). I'd really like to see an xp tracker added to detect inactive members and figure out how long they have been inactive. It would work similar to the current log method but I can see how it is a slightly different principle.

This is just a wish list, but if anyone made it I would be so happy :P

u can do that urself so easily. just log the exp once a month and sort through 0 exp gainers. If you have to deal with f2p, then it's pretty much manual labor logging their stats, and I'm not going to even get into name changers lol

Fair point but that only gives me a one month "resolution". I'd find something that's automated more useful, because once I notice a problem I can look back and see how long it's been going on with more accuracy. Yes, the script would have to update the member list each time, so changing your name would effectively reset your exp gain each time you did it, but inactives are unlikely to do that.

In any case I think I'd find it useful. Tips on the current function would help me a lot in making it happen but otherwise I'll just have to slog through the scripts without context.

06-Dec-2013 06:57:10

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
If you're interested in how it works, google has really good documentation and tutorials. Apps script is a language based on javascript with server-side features and interaction with google services such as documents, spreadsheets, calender and much more.

For a tutorial on javascript,
http://www.w3schools.com/js/

For more information about apps script,
https://developers.google.com/apps-script/

For more information about apps script for spreadsheets,
https://developers.google.com/apps-script/guides/sheets

For the ClanLogger library source,
https://script.google.com/d/1jA5ecB4C9zrVw8Ym0rdcmwU_u0VxKSVFhZ7plitZQtpdaFwQIaEeTGJh/edit?usp=sharing

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

06-Dec-2013 09:55:50 - Last edited on 06-Dec-2013 09:56:49 by Blasty

Morilinde

Morilinde

Posts: 18,003 Opal Posts by user Forum Profile RuneMetrics Profile
Blasty,

I wanted to find the join date of a clanmate so I hit Ctrl+F and typ the name. But then it displays the search results of the hidden raw data too. Any way I can exclude that column from searching? Thranduil | King of the Elves of the Wood

06-Dec-2013 20:58:22

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
Morilinde said :
Blasty,

I wanted to find the join date of a clanmate so I hit Ctrl+F and typ the name. But then it displays the search results of the hidden raw data too. Any way I can exclude that column from searching?

I'll see what I can do
Blasty
// @BlastytheBlue // Blasty#5167
| Co-owner of Mine Nation

06-Dec-2013 21:10:52

Blasty
Feb Member 2017

Blasty

Posts: 9,319 Rune Posts by user Forum Profile RuneMetrics Profile
Added a mini UI which lets you view the history of a username in your clan log.
Due to the name limitation, this may not be entirely useful for much at the moment, but it should be an easier way to check when a specific player joined your clan.

How to update:
1. Open the spreadsheet.
2. Click on Tools - Script editor...
3. Click on Resources - Manage libraries...
4. Change the version of ClanLogger to the latest version (26).
5. Refresh the spreadsheet.

To use the new feature:
1. Open the spreadsheet.
2. Click on Admin Tools - Open UI
3. Give it a second to load.
4. Select a username from the drop down list (clicking it then typing should also work).

It should then show a simple list of the history of the specific player in your clan.

Sorry about the name limitation, I do plan on improving it in future along with the other changes mentioned in the first few posts.

If you have any small suggestions for now I'll try to get it in quickly, and any larger suggestions will be added to my to-do list :)

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

07-Dec-2013 14:09:55

Becca Lynn

Becca Lynn

Posts: 3,887 Adamant Posts by user Forum Profile RuneMetrics Profile
do we have to start a whole new logger to have the updated version or can we just copy the script?

edit: thanks for all the work you've put into this :)
Modest Skillers
-
Now on world 22!

08-Dec-2013 03:36:49 - Last edited on 08-Dec-2013 03:37:06 by Becca Lynn

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