[Hydra]

This really is meant for group leaders so if you are one and use Google Spreadsheets for your group(s), this is for you.

I coded a script that you can add to any spreadsheet by going to Tools > Script Editor and paste the code below in.

This code will look for a HF profile link and parse it automatically and right away. Grabs UID at the end and hyperlinks it to the full link. It ignores all other links, text, etc.

Code

//Created by iHydra (561239) for Hack Forums
//Parses profile links to UID w/ hyperlink
//Version 0.1

function onEdit() {
  var sh = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var oldLink = sh.getActiveCell().getValue();
  if (oldLink.indexOf("https://hackforums.net/member.php?action=profile&uid=") == 0 || oldLink.indexOf("hackforums.net/member.php?action=profile&uid=") == 0) {
    var uid = oldLink.split('=')[2];
    var newLink = sh.getActiveCell().setValue('=HYPERLINK("' + oldLink + '", "' + uid + '")');
  } else if (oldLink.length == 0) {
    sh.getActiveCell().setValue("");
  }
}

Wasn't sure if this would be useful but wouldn't hurt to share it so why not? Hope it does help some of you out.

Oh, and if you need any small customizations done, let me know.

Demo (Click to View)

[Remix]

Grabbing the username would be better
Anyways, good job

[Gary]

hey thats a pretty neat script for group management

[Music ♫]

hey thats a pretty neat script for group management

vouch for this comment.

[Hydra]

Grabbing the username would be better
Anyways, good job

Could be abused and not willing to make something like that to be honest.