tengo este codigo:
var userProperties = PropertiesService.getUserProperties(); var units1 = userProperties.getProperty('name'); if (units1 = null){ var userProperties = PropertiesService.getUserProperties(); userProperties.setProperty('name', '000'); } var userProperties = PropertiesService.getUserProperties(); userProperties.setProperty('name', units1 + 1); var userProperties = PropertiesService.getUserProperties(); var units = userProperties.getProperty('name');El problema es que no suma 000 - 0.01 - 0.02. Solo suma 000 - 0.1 - 0.2.
Puedes simplificar tu script en este:
function myFunction() { var userProperties = PropertiesService.getUserProperties(); // since getProperty always returns string, parse it into float // if not instantiated, assign '000' var units1 = parseFloat(userProperties.getProperty('name')) || '000'; Logger.log(units1) // add parseFloat in case units1 is still '000' userProperties.setProperty('name', parseFloat(units1) + 0.01) var units = userProperties.getProperty('name'); Logger.log(units) } Esto debería incrementar cada ejecución en 0.01 .