5

I have a sheet with a lot of custom functions calls. I would like to cache results permanently. Until now, I've used cache service, but it is limited to six hours. Is there a way to cache results permanently ? I read in the comments here, that it could be possible to cache data in the user's browser. How should I achieve this ?

Thanks !

Edit : Thanks to Serge Hendrickx's suggestion, I was able to cache results permanently using the same approach as cache service :

var scriptProperties = PropertiesService.getScriptProperties();

if(getCachedVariable(variableName) == null){
 // Results aren't in cache, get them and save them
 scriptProperties.setProperty(variableName,value);
}
return getCachedVariable(variableName);

function getCachedVariable(variableName){
  return scriptProperties.getProperty(variableName);
}
Community
  • 1
  • 1
Standaa - Remember Monica
  • 1,878
  • 2
  • 28
  • 45

1 Answers1

7

This might not be exactly what you're looking for but why not store the results in the Properties Service? This storage is permanent. You could check if the result is already in storage, and potentially store the age of the 'cache' in there as well.

https://developers.google.com/apps-script/reference/properties/properties-service

Serge Hendrickx
  • 1,416
  • 9
  • 15