めｓｔｔ - 経済統計練習帳

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
 
<script>
 
function sample(){
 
 $("#memo").click(function () {
 
google.script.run
       .withSuccessHandler(function(y) {
 
 
 $("#memo").html(y);
 
          })
       .withFailureHandler(function(msg) {
        $("#memo").html("failx");
       })
       .plus();
 
 });
 
 
  google.script.run
       .withSuccessHandler(function(x) {
 
 a=x;
 
 $("#memo").html(a);
          })
       .withFailureHandler(function(msg) {
        $("#memo").html("fail");
       })
       .sigma();
 
}
 
</script>
 
function doGet(e) {
  var template = HtmlService.createTemplateFromFile('index');
 
 
  return template.evaluate()
      .setTitle('モノポリー')
      .setSandboxMode(HtmlService.SandboxMode.IFRAME);
}
 
function sigma(){
 
 
  var id="1K0f8WZeRKJ7E4XRxMws4G05Blu58deEEbua42ayE5uk"; 
 ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data"); 
 
 
x=sheet.getRange(1,1).getValue();  
 
return x;
 
}
 function plus(){
 
 
 var id="1K0f8WZeRKJ7E4XRxMws4G05Blu58deEEbua42ayE5uk"; 
 var ex1 = SpreadsheetApp.openById(id);
 var sheet = ex1.getSheetByName("data"); 
 y=sheet.getRange(1,1).getValue();
 
 y=y+1;
 
   sheet.getRange(1,1).setValue(y);  
 
return y; 
}