Skip to content
TORNLIFE More

Calchas: forum

Calchas [2579182] Level 90

Forum posts (Torn's count)
23 observed
Archived posts
11
Threads started (archived)
2

Boards

From the 11 newest archived posts.

Threads started

Most-liked posts

Likes as archived at fetch time, adjusted for how long each post had been up. Scored posts only; the full score pass runs after the import.

Better API Key Storage in Google Sheets · · 7 likes

When writing a Google Sheet that uses the Torn API it's better to store the API key as a property of the sheet rather than in the sheet itself.

Some advantages of this technique are:
  • You don't show the API key anywhere
  • Making a copy of the sheet clears the properties, you don't have to worry about clearing old API Keys
  • You are prompted to enter your API Key, users cannot forget to do it
My getApi function is:


function getApiKey() {
  var scriptProperties = PropertiesService.getScriptProperties();

  var key = scriptProperties.getProperty("API_KEY");

  if ((key == null) || (key == '')) {
    var ui = SpreadsheetApp.getUi();
    var response = ui.prompt('Enter API Key');

    if (response.getSelectedButton() == ui.Button.OK) {
      key = response.getResponseText();
      scriptProperties.setProperty('API_KEY',key);
    }
  }
  return key;
}



More information about the Google Apps Property Service can be found at developers.google.com

Lost cash in Caymans due to database error · · 0 likes

I was putting cash in the Caymans Bank when the database crashed. It's not there now.

Recent archived posts

Looking for Work? Post your Stats here ·

Job found. Thanks evryone.

Looking for Work? Post your Stats here ·

Found - thanks everyone.

NUKE - 85% RW pay | PAs | Train | Revive · · 1 like

Bumper

NUKE - 85% RW pay | PAs | Train | Revive ·

bump

Christmas Lucky Dip Story · · 1 like

smelly

Better API Key Storage in Google Sheets · · 7 likes

When writing a Google Sheet that uses the Torn API it's better to store the API key as a property of the sheet rather than in the sheet itself.

Some advantages of this technique are:
  • You don't show the API key anywhere
  • Making a copy of the sheet clears the properties, you don't have to worry about clearing old API Keys
  • You are prompted to enter your API Key, users cannot forget to do it
My getApi function is:


function getApiKey() {
  var scriptProperties = PropertiesService.getScriptProperties();

  var key = scriptProperties.getProperty("API_KEY");

  if ((key == null) || (key == '')) {
    var ui = SpreadsheetApp.getUi();
    var response = ui.prompt('Enter API Key');

    if (response.getSelectedButton() == ui.Button.OK) {
      key = response.getResponseText();
      scriptProperties.setProperty('API_KEY',key);
    }
  }
  return key;
}



More information about the Google Apps Property Service can be found at developers.google.com

JLT SPRING 2021 [CONCLUDED] · · 1 like

League 1

Thank you very much


[image: i.imgur.com]

Lost cash in Caymans due to database error ·

Money received. Thanks for looking at this so promptly.

Lost cash in Caymans due to database error ·

I was putting cash in the Caymans Bank when the database crashed. It's not there now.

Home Screen bug ·

I think this is the same for me.

https://www.dropbox.com/s/dc3rgfxdfx0mst8/Screen%20Shot%202020-12-28%20at%2021.48.57.png

I deposited money in the Caymans Bank, then went to return home. When I click on the 'Return Home' button the error is shown.

I tried to log-out and log back in and I'm getting the same error.

Seems your database has crashed.

TRADE with KatKing! · · 1 like

great trader, fast and safe