Skip to content

Instantly share code, notes, and snippets.

@mhawksey
Last active May 24, 2018 13:36
Show Gist options
  • Save mhawksey/3683e086c3c089977e569f17dc3bcde0 to your computer and use it in GitHub Desktop.
Save mhawksey/3683e086c3c089977e569f17dc3bcde0 to your computer and use it in GitHub Desktop.
function doGet(e) {
var html = HtmlService.createTemplateFromFile('index');
html.e = e.parameter;
return html.evaluate().setTitle('Opening a row...');
}
function setCache(parameter){
var values = {
'row': parameter.row,
'header':parameter.header,
'sheet':parameter.sheet,
'id': parameter.id
};
// tried CacheService but seemed unreliabe
// CacheService.getUserCache().putAll(values, 10000); // expires in 10 seconds
PropertiesService.getUserProperties().setProperties(values)
return "https://docs.google.com/spreadsheets/d/"+parameter.id+"/edit";
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment