管理システム

_css.html

<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
<link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.6-rc.0/css/select2.min.css" rel="stylesheet" />
<link href="https://cdnjs.cloudflare.com/ajax/libs/jquery.basictable/1.0.8/basictable.min.css" rel="stylesheet" />

<style type="text/css">
<!--
@import url(http://fonts.googleapis.com/earlyaccess/notosansjapanese.css);
@import url(https://use.fontawesome.com/releases/v5.3.1/css/all.css);
@font-face{font-family:"IonIcons";src:url("//code.ionicframework.com/ionicons/2.0.1/fonts/ionicons.eot?v=2.0.1");src:url("//code.ionicframework.com/ionicons/2.0.1/fonts/ionicons.eot?v=2.0.1#iefix") format("embedded-opentype"),url("//code.ionicframework.com/ionicons/2.0.1/fonts/ionicons.ttf?v=2.0.1") format("truetype"),url("//code.ionicframework.com/ionicons/2.0.1/fonts/ionicons.woff?v=2.0.1") format("woff"),url("//code.ionicframework.com/ionicons/2.0.1/fonts/ionicons.svg?v=2.0.1#Ionicons") format("svg");font-weight:normal;font-style:normal}

body {font-family: 'Noto Sans Japanese', "游ゴシック", YuGothic, "ヒラギノ角ゴ Pro W3", "Hiragino Kaku Gothic Pro", Verdana, "メイリオ", Meiryo, Osaka, "ＭＳ Ｐゴシック", "MS PGothic", sans-serif;width:100%;margin-bottom:50px;}

#header {padding-right:16px;padding-left:16px;background-color:#23282d;color:#ccc;}
#header a {color:#ccc;}
#header a.btn {color: #ccc;border: 1px solid #ccc;padding: 3px 10px;border-radius: 5px;font-size:12px;}
#header a:hover {color: #0073aa;}
#header-container {display: flex;align-items: center;justify-content: space-between;height: 56px;max-width: 100%;margin-left: auto;margin-right: auto;}
#header-start {display: flex;align-items: center;justify-content: center;height: 100%;position: relative;}
#header-end {display: flex;align-items: center;justify-content: center;}

table {margin:0 20px;}
td, th { font-size:0.8em;border: 1px solid #ccc;width: 200px !important;padding: 10px;}
td { background: #fff;}
th { background: #fcfcfc;}
#add th,#view th {height:75px;}

#add input,#view input { width:180px; }
input[readonly="readonly"],input[readonly] {border:none;}
input.btn { font-size:12px;margin-right:10px;border: 1px solid #ccc; }
input[type="submit"] { background: #0085ba;color: #fff;width:300px !important;padding:5px; }

select { outline:none;-moz-appearance: none;text-indent: 0.01px;text-overflow: '';background: none transparent;vertical-align: middle;font-size: inherit;color: inherit;-webkit-appearance: button;-moz-appearance: button;appearance: button;appearance: none;-webkit-appearance: none;-moz-appearance: none;height: 35px;padding: 8px 12px;border:1px solid #ddd;color:#333;width:100%;border-radius:3px;font-size:12px; }
select option { background-color: #fff;color: #333; }
select::-ms-expand { display: none; }
select:-moz-focusring { color: transparent;text-shadow: 0 0 0 #828c9a; }
.select { position: relative; }
.select:before { z-index: 1;position: absolute;right: 15px;top: 0;content: "\f123";font-family: "IonIcons";line-height: 33px;color: #7F878C;pointer-events: none; }

h3 { font-size:16px;margin-top:20px;margin-bottom:20px;padding: 10px;background: #f6f6f6;line-height: 1.7;letter-spacing: -0.02em; }

-->
</style>

_js.html

<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/js/bootstrap.bundle.min.js" integrity="sha384-zDnhMsjVZfS3hiP7oCBRmfjkQC4fzxVxFhBx8Hkz2aZX8gEvA/jsP3eXRCvzTofP" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.6-rc.0/js/select2.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.basictable/1.0.8/jquery.basictable.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.quicksearch/2.4.0/jquery.quicksearch.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.tablesorter/2.31.0/js/jquery.tablesorter.min.js"></script>

<script type="text/javascript">
//$(function(){$('.select').select2();});
//$(function(){$('table').basictable();});
$(function(){$('input#id_search').quicksearch('table tbody tr');});
$(function(){$(".result").tablesorter();});
//$(function() {$("#sec1").toggle();$("#btn10").click(function() {$("#sec10").toggle();});});
$(function() {$("#btn10").click(function() {$("#sec10").toggle();});});
$(function() {$("#btn20").click(function() {$("#sec20").toggle();});});
$(function() {$("#btn30").click(function() {$("#sec30").toggle();});});
$(function() {$("#btn40").click(function() {$("#sec40").toggle();});});
$(function() {$("#btn50").click(function() {$("#sec50").toggle();});});
$(function() {$("#btn60").click(function() {$("#sec60").toggle();});});
$(function() {$("#btn70").click(function() {$("#sec70").toggle();});});
$('#check').change(function() {
　　 if ( $(this).is(':checked') ){ $('input').prop('readonly', false); $('.readonly').prop('readonly', true);　$('option').prop('disabled', false);　} else { $('input').prop('readonly', true);　}　
});
$('#button').on('click', function() {
  var len=$('#result1 tr').filter(':visible').length-1;$("#count").text(len);
});
</script>

add.html

<!DOCTYPE html>
<html>
<head>
<base target="_top">
<?!= HtmlService.createHtmlOutputFromFile('_css').getContent(); ?>
</head>
<body id="add">

<div id="header">
<div id="header-container">
<div id="header-start">
  <div style="display: flex;align-items: center;width:150px;"><a href="<?=url?>">管理システム</a></div>
</div>
<div id="header-end">
  <div><? user = Session.getActiveUser().getEmail(); ?>ログインユーザー：<?=user?></div>
</div>
</div>
</div>

<h3>新規登録</h3>

<? var Data = sheet.getDataRange().getDisplayValues(); ?>

<form method="POST" action="<?=url?>?action=addData" target="_top">
<table>
<tr>
<th><?=Data[0][2]?></th><td><input type="text" name="data002"></td>
<th><?=Data[0][3]?></th><td><input type="text" name="data003"></td>
<th><?=Data[0][4]?></th><td><input type="text" name="data004"></td>
<th><?=Data[0][5]?></th><td><input type="text" name="data005"></td>
<th><?=Data[0][6]?></th><td><input type="text" name="data006"></td>
<th><?=Data[0][7]?></th><td>
<div class="select"><select name="data007" class="select">
<option value=""></option>
<option value="入社予定">入社予定</option>
<option value="在職中">在職中</option>
<option value="退職予定">退職予定</option>
<option value="退職済">退職済</option>
<option value="辞退">辞退</option>
</select></div>
</td>
</tr><tr>
<th><?=Data[0][8]?></th><td><input type="text" name="data008"></td>
<th><?=Data[0][9]?></th><td><input type="text" name="data009"></td>
<th><?=Data[0][10]?></th><td><input type="text" name="data010"></td>
<th><?=Data[0][11]?></th><td><input type="text" name="data011"></td>
<th><?=Data[0][12]?></th><td><input type="text" name="data012"></td>
<th><?=Data[0][13]?></th><td><input type="text" name="data013"></td>
</tr><tr>
<th><?=Data[0][14]?></th><td><input type="text" name="data014"></td>
<th><?=Data[0][15]?></th><td><input type="text" name="data015"></td>
<th><?=Data[0][16]?></th><td>
<div class="select"><select name="data016">
<option value=""></option>
<option value="男性">男性</option>
<option value="女性">女性</option>
<option value="その他">その他</option>
</select></div>
</td>
<th><?=Data[0][17]?></th><td><input type="text" name="data017"></td>
<th><?=Data[0][18]?></th><td><input type="text" name="data018"></td>
<th><?=Data[0][19]?></th><td><input type="text" name="data019"></td>
</tr><tr>
<th><?=Data[0][20]?></th><td><input type="text" name="data020"></td>
<th><?=Data[0][21]?></th><td><input type="text" name="data021"></td>
<th><?=Data[0][22]?></th><td><input type="text" name="data022"></td>
<th><?=Data[0][23]?></th><td><input type="text" name="data023"></td>
<th><?=Data[0][24]?></th><td><input type="text" name="data024"></td>
<th><?=Data[0][25]?></th><td><input type="text" name="data025"></td>
</tr><tr>
<th><?=Data[0][26]?></th><td><input type="text" name="data026"></td>
<th><?=Data[0][27]?></th><td><input type="text" name="data027"></td>
<th><?=Data[0][28]?></th><td><input type="text" name="data028"></td>
<th><?=Data[0][29]?></th><td><input type="text" name="data029"></td>
<th><?=Data[0][30]?></th><td><input type="text" name="data030"></td>
<th><?=Data[0][31]?></th><td><input type="text" name="data031"></td>
</tr><tr>
<th><?=Data[0][32]?></th><td><input type="text" name="data032"></td>
<th><?=Data[0][33]?></th><td><input type="text" name="data033"></td>
<th><?=Data[0][34]?></th><td><input type="text" name="data034"></td>
<th><?=Data[0][35]?></th><td><input type="text" name="data035"></td>
<th><?=Data[0][36]?></th><td><input type="text" name="data036"></td>
<th><?=Data[0][37]?></th><td><input type="text" name="data037"></td>
</tr><tr>
<th><?=Data[0][38]?></th><td><input type="text" name="data038"></td>
<th><?=Data[0][39]?></th><td><input type="text" name="data039"></td>
<th><?=Data[0][40]?></th><td><input type="text" name="data040"></td>
<th><?=Data[0][41]?></th><td><input type="text" name="data041"></td>
<th><?=Data[0][42]?></th><td><input type="text" name="data042"></td>
<th><?=Data[0][43]?></th><td><input type="text" name="data043"></td>
</tr><tr>
<th><?=Data[0][44]?></th><td><input type="text" name="data044"></td>
<th><?=Data[0][45]?></th><td><input type="text" name="data045"></td>
<th><?=Data[0][46]?></th><td><input type="text" name="data046"></td>
<th><?=Data[0][47]?></th><td><input type="text" name="data047"></td>
<th><?=Data[0][48]?></th><td><input type="text" name="data048"></td>
<th><?=Data[0][49]?></th><td><input type="text" name="data049"></td>
</tr><tr>
<th><?=Data[0][50]?></th><td><input type="text" name="data050"></td>
<th><?=Data[0][51]?></th><td><input type="text" name="data051"></td>
<th><?=Data[0][52]?></th><td><input type="text" name="data052"></td>
<th><?=Data[0][53]?></th><td><input type="text" name="data053"></td>
<th><?=Data[0][54]?></th><td><input type="text" name="data054"></td>
<th><?=Data[0][55]?></th><td><input type="text" name="data055"></td>
</tr><tr>
<th><?=Data[0][56]?></th><td><input type="text" name="data056"></td>
<th><?=Data[0][57]?></th><td><input type="text" name="data057"></td>
<th><?=Data[0][58]?></th><td><input type="text" name="data058"></td>
<th><?=Data[0][59]?></th><td><input type="text" name="data059"></td>
<th><?=Data[0][60]?></th><td><input type="text" name="data060"></td>
<th><?=Data[0][61]?></th><td><input type="text" name="data061"></td>
</tr><tr>
<th><?=Data[0][62]?></th><td><input type="text" name="data062"></td>
<th><?=Data[0][63]?></th><td><input type="text" name="data063"></td>
<th><?=Data[0][64]?></th><td><input type="text" name="data064"></td>
<th><?=Data[0][65]?></th><td><input type="text" name="data065"></td>
<th><?=Data[0][66]?></th><td><input type="text" name="data066"></td>
<th><?=Data[0][67]?></th><td><input type="text" name="data067"></td>
</tr><tr>
<th><?=Data[0][68]?></th><td><input type="text" name="data068"></td>
<th><?=Data[0][69]?></th><td><input type="text" name="data069"></td>
<th><?=Data[0][70]?></th><td><input type="text" name="data070"></td>
<th><?=Data[0][71]?></th><td><input type="text" name="data071"></td>
<th><?=Data[0][72]?></th><td><input type="text" name="data072"></td>
<th><?=Data[0][73]?></th><td><input type="text" name="data073"></td>
</tr><tr>
<th><?=Data[0][74]?></th><td><input type="text" name="data074"></td>
<th><?=Data[0][75]?></th><td><input type="text" name="data075"></td>
<th><?=Data[0][76]?></th><td><input type="text" name="data076"></td>
<th><?=Data[0][77]?></th><td><input type="text" name="data077"></td>
<th><?=Data[0][78]?></th><td><input type="text" name="data078"></td>
<th><?=Data[0][79]?></th><td><input type="text" name="data079"></td>
</tr><tr>
<th><?=Data[0][80]?></th><td><input type="text" name="data080"></td>
<th><?=Data[0][81]?></th><td><input type="text" name="data081"></td>
<th><?=Data[0][82]?></th><td><input type="text" name="data082"></td>
<th><?=Data[0][83]?></th><td><input type="text" name="data083"></td>
<th><?=Data[0][84]?></th><td><input type="text" name="data084"></td>
<th><?=Data[0][85]?></th><td><input type="text" name="data085"></td>
</tr><tr>
<th><?=Data[0][86]?></th><td><input type="text" name="data086"></td>
<th><?=Data[0][87]?></th><td><input type="text" name="data087"></td>
<th><?=Data[0][88]?></th><td><input type="text" name="data088"></td>
<th><?=Data[0][89]?></th><td><input type="text" name="data089"></td>
<th><?=Data[0][90]?></th><td><input type="text" name="data090"></td>
<th><?=Data[0][91]?></th><td><input type="text" name="data091"></td>
</tr><tr>
<th><?=Data[0][92]?></th><td><input type="text" name="data092"></td>
<th><?=Data[0][93]?></th><td><input type="text" name="data093"></td>
<th><?=Data[0][94]?></th><td><input type="text" name="data094"></td>
<th><?=Data[0][95]?></th><td><input type="text" name="data095"></td>
<th><?=Data[0][96]?></th><td><input type="text" name="data096"></td>
<th><?=Data[0][97]?></th><td><input type="text" name="data097"></td>
</tr><tr>
<th><?=Data[0][98]?></th><td><input type="text" name="data098"></td>
<th><?=Data[0][99]?></th><td><input type="text" name="data099"></td>
<th><?=Data[0][100]?></th><td><input type="text" name="data100"></td>
<th><?=Data[0][101]?></th><td><input type="text" name="data101"></td>
<th><?=Data[0][102]?></th><td><input type="text" name="data102"></td>
<th><?=Data[0][103]?></th><td><input type="text" name="data103"></td>
</tr><tr>
<th><?=Data[0][104]?></th><td><input type="text" name="data104"></td>
<th><?=Data[0][105]?></th><td><input type="text" name="data105"></td>
<th><?=Data[0][106]?></th><td><input type="text" name="data106"></td>
<th><?=Data[0][107]?></th><td><input type="text" name="data107"></td>
<th><?=Data[0][108]?></th><td><input type="text" name="data108"></td>
<th><?=Data[0][109]?></th><td><input type="text" name="data109"></td>
</tr><tr>
<th><?=Data[0][110]?></th><td><input type="text" name="data110"></td>
<th><?=Data[0][111]?></th><td><input type="text" name="data111"></td>
<th><?=Data[0][112]?></th><td><input type="text" name="data112"></td>
<th><?=Data[0][113]?></th><td><input type="text" name="data113"></td>
<th><?=Data[0][114]?></th><td><input type="text" name="data114"></td>
<th><?=Data[0][115]?></th><td><input type="text" name="data115"></td>
</tr><tr>
<th><?=Data[0][116]?></th><td><input type="text" name="data116"></td>
<th><?=Data[0][117]?></th><td><input type="text" name="data117"></td>
<th><?=Data[0][118]?></th><td><input type="text" name="data118"></td>
<th><?=Data[0][119]?></th><td><input type="text" name="data119"></td>
<th><?=Data[0][120]?></th><td><input type="text" name="data120"></td>
<th><?=Data[0][121]?></th><td><input type="text" name="data121"></td>
</tr><tr>
<th><?=Data[0][122]?></th><td><input type="text" name="data122"></td>
<th><?=Data[0][123]?></th><td><input type="text" name="data123"></td>
<th><?=Data[0][124]?></th><td><input type="text" name="data124"></td>
<th><?=Data[0][125]?></th><td><input type="text" name="data125"></td>
<th><?=Data[0][126]?></th><td><input type="text" name="data126"></td>
<th><?=Data[0][127]?></th><td><input type="text" name="data127"></td>
</tr><tr>
<th><?=Data[0][128]?></th><td><input type="text" name="data128"></td>
<th><?=Data[0][129]?></th><td><input type="text" name="data129"></td>
<th><?=Data[0][130]?></th><td><input type="text" name="data130"></td>
</tr>
</table>
<div style="margin:20px auto;text-align:center;"><input type="submit" value="新規登録"></div>
</form>

<?!= HtmlService.createHtmlOutputFromFile('_js').getContent(); ?>
</body>
</html>

code.gs

var sheet_id  = "******************";
var folder_id = "******************";
var sheet  = SpreadsheetApp.openById(sheet_id).getSheetByName("マスタ");
var sheet2 = SpreadsheetApp.openById(sheet_id).getSheetByName("異動等");
var sheet3 = SpreadsheetApp.openById(sheet_id).getSheetByName("役員");
var sheet4 = SpreadsheetApp.openById(sheet_id).getSheetByName("産休育休");
var sheet5 = SpreadsheetApp.openById(sheet_id).getSheetByName("給与");
var sheet6 = SpreadsheetApp.openById(sheet_id).getSheetByName("賞与");
var sheet7 = SpreadsheetApp.openById(sheet_id).getSheetByName("研修");
var url   = "https://script.google.com/******************/exec";
//var url   = "https://script.google.com/******************/dev";

function doPost(e){
  doGet(e);
  return HtmlService.createTemplateFromFile("index").evaluate(); 
}

function doGet(e){
  data001 = e.parameter.data002 + e.parameter.data003;
  data002 = e.parameter.data002;　　
  data003 = e.parameter.data003;
  data004 = e.parameter.data004;
  data005 = e.parameter.data005;
  data006 = e.parameter.data006;
  data007 = e.parameter.data007;
  data008 = e.parameter.data008;
  data009 = e.parameter.data009;
  data010 = e.parameter.data010;
  data011 = e.parameter.data011;
  data012 = e.parameter.data012;
  data013 = e.parameter.data013;
  data014 = e.parameter.data014;
  data015 = e.parameter.data015;
  data016 = e.parameter.data016;
  data017 = e.parameter.data017;
  data018 = e.parameter.data018;
  data019 = e.parameter.data019;
  data020 = e.parameter.data020;
  data021 = e.parameter.data021;
  data022 = e.parameter.data022;
  data023 = e.parameter.data023;
  data024 = e.parameter.data024;
  data025 = e.parameter.data025;
  data026 = e.parameter.data026;
  data027 = e.parameter.data027;
  data028 = e.parameter.data028;
  data029 = e.parameter.data029;
  data030 = e.parameter.data030;
  data031 = e.parameter.data031;
  data032 = e.parameter.data032;
  data033 = e.parameter.data033;
  data034 = e.parameter.data034;
  data035 = e.parameter.data035;
  data036 = e.parameter.data036;
  data037 = e.parameter.data037;
  data038 = e.parameter.data038;
  data039 = e.parameter.data039;
  data040 = e.parameter.data040;
  data041 = e.parameter.data041;
  data042 = e.parameter.data042;
  data043 = e.parameter.data043;
  data044 = e.parameter.data044;
  data045 = e.parameter.data045;
  data046 = e.parameter.data046;
  data047 = e.parameter.data047;
  data048 = e.parameter.data048;
  data049 = e.parameter.data049;
  data050 = e.parameter.data050;
  data051 = e.parameter.data051;
  data052 = e.parameter.data052;
  data053 = e.parameter.data053;
  data054 = e.parameter.data054;
  data055 = e.parameter.data055;
  data056 = e.parameter.data056;
  data057 = e.parameter.data057;
  data058 = e.parameter.data058;
  data059 = e.parameter.data059;
  data060 = e.parameter.data060;
  data061 = e.parameter.data061;
  data062 = e.parameter.data062;
  data063 = e.parameter.data063;
  data064 = e.parameter.data064;
  data065 = e.parameter.data065;
  data066 = e.parameter.data066;
  data067 = e.parameter.data067;
  data068 = e.parameter.data068;
  data069 = e.parameter.data069;
  data070 = e.parameter.data070;
  data071 = e.parameter.data071;
  data072 = e.parameter.data072;
  data073 = e.parameter.data073;
  data074 = e.parameter.data074;
  data075 = e.parameter.data075;
  data076 = e.parameter.data076;
  data077 = e.parameter.data077;
  data078 = e.parameter.data078;
  data079 = e.parameter.data079;
  data080 = e.parameter.data080;
  data081 = e.parameter.data081;
  data082 = e.parameter.data082;
  data083 = e.parameter.data083;
  data084 = e.parameter.data084;
  data085 = e.parameter.data085;
  data086 = e.parameter.data086;
  data087 = e.parameter.data087;
  data088 = e.parameter.data088;
  data089 = e.parameter.data089;
  data090 = e.parameter.data090;
  data091 = e.parameter.data091;
  data092 = e.parameter.data092;
  data093 = e.parameter.data093;
  data094 = e.parameter.data094;
  data095 = e.parameter.data095;
  data096 = e.parameter.data096;
  data097 = e.parameter.data097;
  data098 = e.parameter.data098;
  data099 = e.parameter.data099;
  data100 = e.parameter.data100;
  data101 = e.parameter.data101;
  data102 = e.parameter.data102;
  data103 = e.parameter.data103;
  data104 = e.parameter.data104;
  data105 = e.parameter.data105;
  data106 = e.parameter.data106;
  data107 = e.parameter.data107;
  data108 = e.parameter.data108;
  data109 = e.parameter.data109;
  data110 = e.parameter.data110;
  data111 = e.parameter.data111;
  data112 = e.parameter.data112;
  data113 = e.parameter.data113;
  data114 = e.parameter.data114;
  data115 = e.parameter.data115;
  data116 = e.parameter.data116;
  data117 = e.parameter.data117;
  data118 = e.parameter.data118;
  data119 = e.parameter.data119;
  data120 = e.parameter.data120;
  data121 = e.parameter.data121;
  data122 = e.parameter.data122;
  data123 = e.parameter.data123;
  data124 = e.parameter.data124;
  data125 = e.parameter.data125;
  data126 = e.parameter.data126;
  data127 = e.parameter.data127;
  data128 = e.parameter.data128;
  data129 = e.parameter.data129;
  data130 = e.parameter.data130;  
  
  if (e.parameter.action == undefined) {
    return HtmlService.createTemplateFromFile("index").evaluate().setTitle('管理システム'); 
  } else if (e.parameter.action == 'add'){
    return HtmlService.createTemplateFromFile("add").evaluate().setTitle('管理システム'); 
  } else if (e.parameter.action == 'view'){
    no = e.parameter.no;
    return HtmlService.createTemplateFromFile("view").evaluate().setTitle('管理システム'); 
  } else if (e.parameter.action == 'addData'){
    no     = sheet.getLastRow();
    var array = 
        [ no,
         data001,data002,data003,data004,data005,data006,data007,data008,data009,data010,
         data011,data012,data013,data014,data015,data016,data017,data018,data019,data020,
         data021,data022,data023,data024,data025,data026,data027,data028,data029,data030,
         data031,data032,data033,data034,data035,data036,data037,data038,data039,data040,
         data041,data042,data043,data044,data045,data046,data047,data048,data049,data050,
         data051,data052,data053,data054,data055,data056,data057,data058,data059,data060,
         data061,data062,data063,data064,data065,data066,data067,data068,data069,data070,
         data071,data072,data073,data074,data075,data076,data077,data078,data079,data080,
         data081,data082,data083,data084,data085,data086,data087,data088,data089,data090,
         data091,data092,data093,data094,data095,data096,data097,data098,data099,data100,
         data101,data102,data103,data104,data105,data106,data107,data108,data109,data110,
         data111,data112,data113,data114,data115,data116,data117,data118,data119,data120,
         data121,data122,data123,data124,data125,data126,data127,data128,data129,data130
         ];
    sheet.appendRow(array);
    return HtmlService.createTemplateFromFile("index").evaluate().setTitle('管理システム'); 
  } else if (e.parameter.action == 'updateData'){
    no     = e.parameter.no;
    var array = 
        [[ no,
         data001,data002,data003,data004,data005,data006,data007,data008,data009,data010,
         data011,data012,data013,data014,data015,data016,data017,data018,data019,data020,
         data021,data022,data023,data024,data025,data026,data027,data028,data029,data030,
         data031,data032,data033,data034,data035,data036,data037,data038,data039,data040,
         data041,data042,data043,data044,data045,data046,data047,data048,data049,data050,
         data051,data052,data053,data054,data055,data056,data057,data058,data059,data060,
         data061,data062,data063,data064,data065,data066,data067,data068,data069,data070,
         data071,data072,data073,data074,data075,data076,data077,data078,data079,data080,
         data081,data082,data083,data084,data085,data086,data087,data088,data089,data090,
         data091,data092,data093,data094,data095,data096,data097,data098,data099,data100,
         data101,data102,data103,data104,data105,data106,data107,data108,data109,data110,
         data111,data112,data113,data114,data115,data116,data117,data118,data119,data120,
         data121,data122,data123,data124,data125,data126,data127,data128,data129,data130
         ]];
    var i = parseInt(no) + 1;
    sheet.getRange(i,1,1,array[0].length).setValues(array);
    return HtmlService.createTemplateFromFile("index").evaluate().setTitle('管理システム'); 
  }
}

function linkViewUrl (no, name) {
  var viewUrl = url + "?action=view&no=" + no;
  return '<a href="' + viewUrl + '" target="_top">' + name + '</a>';
}

//表示用日付を返す関数
function getDate(date) {
  if(date==""){
    return "";
  }else{
    return Utilities.formatDate(new Date(date), 'Asia/Tokyo', 'yyyy/MM/dd');
  }
}
  
//URLリンクを埋め込む関数
function linkURL(stringUrl) {
  var pattern = 'http';
  if(stringUrl.indexOf(pattern) === 0){
    return '<a href="' + stringUrl + '" target="_blank">' + stringUrl + '</a>';
  }else{
    return stringUrl;
  }
}
  
//メールリンクを埋め込む関数
function linkMail(stringMail) {
  if(stringMail.indexOf('@') != -1){
    return '<a href="mailto:' + stringMail + '">' + stringMail + '</a>';
  }else{
    return stringMail;
  }
}

function getData(id,sheetname){
  ss = SpreadsheetApp.openById(id);
  var values = ss.getSheetByName(sheetname).getDataRange().getDisplayValues();
  return values;
}

function include(filename) {
  return HtmlService.createHtmlOutputFromFile(filename).getContent();
}

function Backup() {  
  var file = DriveApp.getFileById(sheet_id);
  var folder = DriveApp.getFolderById(folder_id);
  file.makeCopy(file.getName()+'-'+Utilities.formatDate(new Date(), 'JST', 'yyyy-MM-dd-HH'),folder);   
}

function Formula() {
  var lastRow = sheet.getLastRow()
  for (i=2; i<=lastRow; i++) {
//N2 =if(K2="","",if(L2="",DATEDIF(K2,today(),"y")&"年"&DATEDIF(K2,today(),"ym")&"ケ月",DATEDIF(K2,L2,"y")&"年"&DATEDIF(K2,L2,"ym")&"ケ月"))
    var strformula = "=if(K" + i + "=\"\",\"\",if(L" + i + "=\"\",DATEDIF(K" + i + ",today(),\"y\")&\"年\"&DATEDIF(K" + i + ",today(),\"ym\")&\"ケ月\",DATEDIF(K" + i + ",L" + i + ",\"y\")&\"年\"&DATEDIF(K" + i + ",L" + i + ",\"ym\")&\"ケ月\"))"
    sheet.getRange(i, 14).setValue(strformula) 
//P2 =if(O2="",,datedif(O2,today(),"Y"))
    var strformula = "=if(O" + i + "=\"\",,datedif(O" + i + ",today(),\"Y\"))"
    sheet.getRange(i, 16).setValue(strformula) 
  }
}

index.html

<!DOCTYPE html>
<html>
<head>
<base target="_top">
<?!= HtmlService.createHtmlOutputFromFile('_css').getContent(); ?>
</head>
<body id="top">

<div id="header">
<div id="header-container">
<div id="header-start">
  <div style="display: flex;align-items: center;width:150px;"><a href="<?=url?>">管理システム</a></div>
  <div style="display: flex;align-items: center;width:150px;"><a href="<?=url?>?action=add" class="btn">新規登録</a></div>
  <div style="display: flex;align-items: center;width:250px;">検索：<form action="#"><input type="text" name="search" value="" id="id_search" /></form></div>
</div>
<div id="header-end">
  <div><? user = Session.getActiveUser().getEmail(); ?>ログインユーザー：<?=user?></div>
</div>
</div>
</div>

<?
var arr = ["","",""];
//if (arr.indexOf(user) >= 0){
?>

<? var Data  = sheet.getRange(1,1,sheet.getLastRow(),sheet.getLastColumn()).getDisplayValues(); ?>
<? var Data2 = sheet2.getRange(1,1,sheet2.getLastRow(),sheet2.getLastColumn()).getDisplayValues(); ?>
<? var Data3 = sheet3.getRange(1,1,sheet3.getLastRow(),sheet3.getLastColumn()).getDisplayValues(); ?>
<? var Data4 = sheet4.getRange(1,1,sheet4.getLastRow(),sheet4.getLastColumn()).getDisplayValues(); ?>
<? var Data5 = sheet5.getRange(1,1,sheet5.getLastRow(),sheet5.getLastColumn()).getDisplayValues(); ?>
<? var Data6 = sheet6.getRange(1,1,sheet6.getLastRow(),sheet6.getLastColumn()).getDisplayValues(); ?>
<? var Data7 = sheet7.getRange(1,1,sheet7.getLastRow(),sheet7.getLastColumn()).getDisplayValues(); ?>

<h3><input type="button" id="btn10" value="開閉" class="btn" />基本情報</h3>
<div style="margin:0 20px;"><button id="button">カウント</button><div id="count"></div></div>
<section id="sec10">
<table id="result1" class="result">
<thead><tr>
<th><?=Data[0][0]?></th>
<th><?=Data[0][1]?></th>
<th><?=Data[0][6]?></th>
<th><?=Data[0][7]?></th>
<th><?=Data[0][8]?></th>
<th><?=Data[0][9]?></th>
<th><?=Data[0][10]?></th>
<th><?=Data[0][11]?></th>
<th><?=Data[0][13]?></th>
<th><?=Data[0][14]?></th>
<th><?=Data[0][15]?></th>
</tr></thead>
<tbody>
<?
for(var i=1; i<Data.length; i++){
  output.append('<tr>');
  output.append('<td>' + Data[i][0] + '</td>');
  output.append('<td>' + linkViewUrl(Data[i][0],Data[i][1]) + '</td>');
  output.append('<td>' + Data[i][6] + '</td>');
  output.append('<td>' + Data[i][7] + '</td>');
  output.append('<td>' + Data[i][8] + '</td>');
  output.append('<td>' + Data[i][9] + '</td>');
  output.append('<td>' + Data[i][10] + '</td>');
  output.append('<td>' + Data[i][11] + '</td>');
  output.append('<td>' + Data[i][13] + '</td>');
  output.append('<td>' + Data[i][14] + '</td>');
  output.append('<td>' + Data[i][15] + '</td>');
  output.append('</tr>');
}
?>
</tbody>
</table>
</section>

<h3><input type="button" id="btn20" value="開閉" class="btn" />異動等</h3>
<section id="sec20">
<table id="result" class="result">
<thead>
<tr>
<th><?=Data2[0][0]?></th>
<th><?=Data2[0][1]?></th>
<th><?=Data2[0][2]?></th>
<th><?=Data2[0][3]?></th>
<th><?=Data2[0][4]?></th>
<th><?=Data2[0][5]?></th>
<th><?=Data2[0][6]?></th>
<th><?=Data2[0][7]?></th>
</tr>
</thead>
<tbody>
<?
for(var i=1; i<Data2.length; i++){
  output.append('<tr>');
  output.append('<td>' + Data2[i][0] + '</td>');
  output.append('<td>' + Data2[i][1] + '</td>');
  output.append('<td>' + Data2[i][2] + '</td>');
  output.append('<td>' + Data2[i][3] + '</td>');
  output.append('<td>' + Data2[i][4] + '</td>');
  output.append('<td>' + Data2[i][5] + '</td>');
  output.append('<td>' + Data2[i][6] + '</td>');
  output.append('<td>' + Data2[i][7] + '</td>');
  output.append('</tr>');
}
?>
</tbody>
</table>
</section>

<h3><input type="button" id="btn30" value="開閉" class="btn" />役員</h3>
<section id="sec30">
<table id="result" class="result">
<thead>
<tr>
<th><?=Data3[0][0]?></th>
<th><?=Data3[0][1]?></th>
<th><?=Data3[0][2]?></th>
<th><?=Data3[0][3]?></th>
<th><?=Data3[0][4]?></th>
<th><?=Data3[0][5]?></th>
<th><?=Data3[0][6]?></th>
<th><?=Data3[0][7]?></th>
<th><?=Data3[0][8]?></th>
</tr>
</thead>
<tbody>
<?
for(var i=1; i<Data3.length; i++){
  output.append('<tr>');
  output.append('<td>' + Data3[i][0] + '</td>');
  output.append('<td>' + Data3[i][1] + '</td>');
  output.append('<td>' + Data3[i][2] + '</td>');
  output.append('<td>' + Data3[i][3] + '</td>');
  output.append('<td>' + Data3[i][4] + '</td>');
  output.append('<td>' + Data3[i][5] + '</td>');
  output.append('<td>' + Data3[i][6] + '</td>');
  output.append('<td>' + Data3[i][7] + '</td>');
  output.append('<td>' + Data3[i][8] + '</td>');
  output.append('</tr>');
}
?>
</tbody>
</table>
</section>

<h3><input type="button" id="btn40" value="開閉" class="btn" />産休・育休</h3>
<section id="sec40">
<table id="result" class="result">
<thead>
<tr>
<th><?=Data4[0][0]?></th>
<th><?=Data4[0][1]?></th>
<th><?=Data4[0][2]?></th>
<th><?=Data4[0][3]?></th>
<th><?=Data4[0][4]?></th>
<th><?=Data4[0][5]?></th>
<th><?=Data4[0][6]?></th>
<th><?=Data4[0][7]?></th>
<th><?=Data4[0][8]?></th>
</tr>
</thead>
<tbody>
<?
for(var i=1; i<Data4.length; i++){
  output.append('<tr>');
  output.append('<td>' + Data4[i][0] + '</td>');
  output.append('<td>' + Data4[i][1] + '</td>');
  output.append('<td>' + Data4[i][2] + '</td>');
  output.append('<td>' + Data4[i][3] + '</td>');
  output.append('<td>' + Data4[i][4] + '</td>');
  output.append('<td>' + Data4[i][5] + '</td>');
  output.append('<td>' + Data4[i][6] + '</td>');
  output.append('<td>' + Data4[i][7] + '</td>');
  output.append('<td>' + Data4[i][8] + '</td>');
  output.append('</tr>');
}
?>
</tbody>
</table>
</section>

<h3><input type="button" id="btn50" value="開閉" class="btn" />給与</h3>
<section id="sec50">
<table id="result" class="result">
<thead>
<tr>
<th><?=Data5[0][0]?></th>
<th><?=Data5[0][1]?></th>
<th><?=Data5[0][2]?></th>
<th><?=Data5[0][3]?></th>
<th><?=Data5[0][4]?></th>
<th><?=Data5[0][5]?></th>
<th><?=Data5[0][6]?></th>
<th><?=Data5[0][7]?></th>
<th><?=Data5[0][8]?></th>
<th><?=Data5[0][9]?></th>
<th><?=Data5[0][10]?></th>
<th><?=Data5[0][11]?></th>
<th><?=Data5[0][12]?></th>
</tr>
</thead>
<tbody>
<?
for(var i=1; i<Data5.length; i++){
  output.append('<tr>');
  output.append('<td>' + Data5[i][0] + '</td>');
  output.append('<td>' + Data5[i][1] + '</td>');
  output.append('<td>' + Data5[i][2] + '</td>');
  output.append('<td>' + Data5[i][3] + '</td>');
  output.append('<td>' + Data5[i][4] + '</td>');
  output.append('<td>' + Data5[i][5] + '</td>');
  output.append('<td>' + Data5[i][6] + '</td>');
  output.append('<td>' + Data5[i][7] + '</td>');
  output.append('<td>' + Data5[i][8] + '</td>');
  output.append('<td>' + Data5[i][9] + '</td>');
  output.append('<td>' + Data5[i][10] + '</td>');
  output.append('<td>' + Data5[i][11] + '</td>');
  output.append('<td>' + Data5[i][12] + '</td>');
  output.append('</tr>');
}
?>
</tbody>
</table>
</section>

<h3><input type="button" id="btn60" value="開閉" class="btn" />賞与</h3>
<section id="sec60">
<table id="result" class="result">
<thead>
<tr>
<th><?=Data6[0][0]?></th>
<th><?=Data6[0][1]?></th>
<th><?=Data6[0][2]?></th>
<th><?=Data6[0][3]?></th>
<th><?=Data6[0][4]?></th>
<th><?=Data6[0][5]?></th>
<th><?=Data6[0][6]?></th>
<th><?=Data6[0][7]?></th>
<th><?=Data6[0][8]?></th>
</tr>
</thead>
<tbody>
<?
for(var i=1; i<Data6.length; i++){
  output.append('<tr>');
  output.append('<td>' + Data6[i][0] + '</td>');
  output.append('<td>' + Data6[i][1] + '</td>');
  output.append('<td>' + Data6[i][2] + '</td>');
  output.append('<td>' + Data6[i][3] + '</td>');
  output.append('<td>' + Data6[i][4] + '</td>');
  output.append('<td>' + Data6[i][5] + '</td>');
  output.append('<td>' + Data6[i][6] + '</td>');
  output.append('<td>' + Data6[i][7] + '</td>');
  output.append('<td>' + Data6[i][8] + '</td>');
  output.append('</tr>');
}
?>
</tbody>
</table>
</section>

<h3><input type="button" id="btn70" value="開閉" class="btn" />研修</h3>
<section id="sec70">
<table id="result" class="result">
<thead>
<tr>
<th><?=Data7[0][0]?></th>
<th><?=Data7[0][1]?></th>
<th><?=Data7[0][2]?></th>
<th><?=Data7[0][3]?></th>
<th><?=Data7[0][4]?></th>
<th><?=Data7[0][5]?></th>
<th><?=Data7[0][6]?></th>
</tr>
</thead>
<tbody>
<?
for(var i=1; i<Data7.length; i++){
  output.append('<tr>');
  output.append('<td>' + Data7[i][0] + '</td>');
  output.append('<td>' + Data7[i][1] + '</td>');
  output.append('<td>' + Data7[i][2] + '</td>');
  output.append('<td>' + Data7[i][3] + '</td>');
  output.append('<td>' + Data7[i][4] + '</td>');
  output.append('<td>' + Data7[i][5] + '</td>');
  output.append('<td>' + Data7[i][6] + '</td>');
  output.append('</tr>');
}
?>
</tbody>
</table>
</section>

<? //} ?>

<?!= HtmlService.createHtmlOutputFromFile('_js').getContent(); ?>
</body>
</html>

view.html

<!DOCTYPE html>
<html>
<Data[0][>
<base target="_top">
<?!= HtmlService.createHtmlOutputFromFile('_css').getContent(); ?>
</Data[0][>
<body id="view">

<div id="header">
<div id="header-container">
<div id="header-start">
  <div style="display: flex;align-items: center;width:150px;"><a href="<?=url?>">管理システム</a></div>
</div>
<div id="header-end">
  <div><? user = Session.getActiveUser().getEmail(); ?>ログインユーザー：<?=user?></div>
</div>
</div>
</div>


<h3>閲覧・編集  (編集<input id="check" type="checkbox" style="width:20px;" />)</h3>

<?
var Data = sheet.getDataRange().getDisplayValues();

for(var i=0; i<Data.length; i++){
if(no == Data[i][0]){
no      = Data[i][0];
data000  = Data[i][0];
data001  = Data[i][1]; 
data002  = Data[i][2]; 
data003  = Data[i][3]; 
data004  = Data[i][4]; 
data005  = Data[i][5]; 
data006  = Data[i][6]; 
data007  = Data[i][7]; 
data008  = Data[i][8]; 
data009  = Data[i][9]; 
data010  = Data[i][10]; 
data011  = Data[i][11]; 
data012  = Data[i][12]; 
data013  = Data[i][13]; 
data014  = Data[i][14]; 
data015  = Data[i][15]; 
data016  = Data[i][16]; 
data017  = Data[i][17]; 
data018  = Data[i][18]; 
data019  = Data[i][19]; 
data020  = Data[i][20]; 
data021  = Data[i][21]; 
data022  = Data[i][22]; 
data023  = Data[i][23]; 
data024  = Data[i][24]; 
data025  = Data[i][25]; 
data026  = Data[i][26]; 
data027  = Data[i][27]; 
data028  = Data[i][28]; 
data029  = Data[i][29]; 
data030  = Data[i][30]; 
data031  = Data[i][31]; 
data032  = Data[i][32]; 
data033  = Data[i][33]; 
data034  = Data[i][34]; 
data035  = Data[i][35]; 
data036  = Data[i][36]; 
data037  = Data[i][37]; 
data038  = Data[i][38]; 
data039  = Data[i][39]; 
data040  = Data[i][40]; 
data041  = Data[i][41]; 
data042  = Data[i][42]; 
data043  = Data[i][43]; 
data044  = Data[i][44]; 
data045  = Data[i][45]; 
data046  = Data[i][46]; 
data047  = Data[i][47]; 
data048  = Data[i][48]; 
data049  = Data[i][49]; 
data050  = Data[i][50]; 
data051  = Data[i][51]; 
data052  = Data[i][52]; 
data053  = Data[i][53]; 
data054  = Data[i][54]; 
data055  = Data[i][55]; 
data056  = Data[i][56]; 
data057  = Data[i][57]; 
data058  = Data[i][58]; 
data059  = Data[i][59]; 
data060  = Data[i][60]; 
data061  = Data[i][61]; 
data062  = Data[i][62]; 
data063  = Data[i][63]; 
data064  = Data[i][64]; 
data065  = Data[i][65]; 
data066  = Data[i][66]; 
data067  = Data[i][67]; 
data068  = Data[i][68]; 
data069  = Data[i][69]; 
data070  = Data[i][70]; 
data071  = Data[i][71]; 
data072  = Data[i][72]; 
data073  = Data[i][73]; 
data074  = Data[i][74]; 
data075  = Data[i][75]; 
data076  = Data[i][76]; 
data077  = Data[i][77]; 
data078  = Data[i][78]; 
data079  = Data[i][79]; 
data080  = Data[i][80]; 
data081  = Data[i][81]; 
data082  = Data[i][82]; 
data083  = Data[i][83]; 
data084  = Data[i][84]; 
data085  = Data[i][85]; 
data086  = Data[i][86]; 
data087  = Data[i][87]; 
data088  = Data[i][88]; 
data089  = Data[i][89]; 
data090  = Data[i][90]; 
data091  = Data[i][91]; 
data092  = Data[i][92]; 
data093  = Data[i][93]; 
data094  = Data[i][94]; 
data095  = Data[i][95]; 
data096  = Data[i][96]; 
data097  = Data[i][97]; 
data098  = Data[i][98]; 
data099  = Data[i][99]; 
data100  = Data[i][100]; 
data101  = Data[i][101]; 
data102  = Data[i][102]; 
data103  = Data[i][103]; 
data104  = Data[i][104]; 
data105  = Data[i][105]; 
data106  = Data[i][106]; 
data107  = Data[i][107]; 
data108  = Data[i][108]; 
data109  = Data[i][109]; 
data110  = Data[i][110]; 
data111  = Data[i][111]; 
data112  = Data[i][112]; 
data113  = Data[i][113]; 
data114  = Data[i][114]; 
data115  = Data[i][115]; 
data116  = Data[i][116]; 
data117  = Data[i][117]; 
data118  = Data[i][118]; 
data119  = Data[i][119]; 
data120  = Data[i][120]; 
data121  = Data[i][121]; 
data122  = Data[i][122]; 
data123  = Data[i][123]; 
data124  = Data[i][124]; 
data125  = Data[i][125]; 
data126  = Data[i][126]; 
data127  = Data[i][127]; 
data128  = Data[i][128]; 
data129  = Data[i][129]; 
data130  = Data[i][130];
break;
}
}
?>

<?
user = Session.getActiveUser().getEmail();
var arr = ["","",""];
//if (arr.indexOf(user) >= 0 || user == data010){
?>


<form method="POST" action="<?=url?>?action=updateData" target="_top">
<table>
<tr>
<th><?=Data[0][0]?></th><td><input type="text" name="no" value="<?=no?>" readonly="readonly" class="readonly"></td>
<th><?=Data[0][1]?></th><td><input type="text" name="data001" value="<?=data001?>" readonly="readonly" class="readonly"></td>
</tr><tr>
<th><?=Data[0][2]?></th><td><input type="text" name="data002" value="<?=data002?>" readonly="readonly"></td>
<th><?=Data[0][3]?></th><td><input type="text" name="data003" value="<?=data003?>" readonly="readonly"></td>
<th><?=Data[0][4]?></th><td><input type="text" name="data004" value="<?=data004?>" readonly="readonly"></td>
<th><?=Data[0][5]?></th><td><input type="text" name="data005" value="<?=data005?>" readonly="readonly"></td>
<th><?=Data[0][6]?></th><td><input type="text" name="data006" value="<?=data006?>" readonly="readonly"></td>
<th><?=Data[0][7]?></th><td>
<div class="select"><select name="data007" readonly="readonly">
<?
  if(data007==""){output.append('<option value="" selected></option>');}else{output.append('<option value="" disabled=""></option>');}
  if(data007=="入社予定"){output.append('<option value="入社予定" selected>入社予定</option>');}else{output.append('<option value="入社予定" disabled="">入社予定</option>');}
  if(data007=="在職中"){output.append('<option value="在職中" selected>在職中</option>');}else{output.append('<option value="在職中" disabled="">在職中</option>');}
  if(data007=="退職予定"){output.append('<option value="退職予定" selected>退職予定</option>');}else{output.append('<option value="退職予定" disabled="">退職予定</option>');}
  if(data007=="退職済"){output.append('<option value="退職済" selected>退職済</option>');}else{output.append('<option value="退職済" disabled="">退職済</option>');}
  if(data007=="辞退"){output.append('<option value="辞退" selected>辞退</option>');}else{output.append('<option value="辞退" disabled="">辞退</option>');}
?>
</select></div>
</td>
</tr><tr>
<th><?=Data[0][8]?></th><td><input type="text" name="data008" value="<?=data008?>" readonly="readonly"></td>
<th><?=Data[0][9]?></th><td><input type="text" name="data009" value="<?=data009?>" readonly="readonly"></td>
<th><?=Data[0][10]?></th><td><input type="text" name="data010" value="<?=data010?>" readonly="readonly"></td>
<th><?=Data[0][11]?></th><td><input type="text" name="data011" value="<?=data011?>" readonly="readonly"></td>
<th><?=Data[0][12]?></th><td><input type="text" name="data012" value="<?=data012?>" readonly="readonly"></td>
<th><?=Data[0][13]?></th><td><input type="text" name="data013" value="<?=data013?>" readonly="readonly" class="readonly"></td>
</tr><tr>
<th><?=Data[0][14]?></th><td><input type="text" name="data014" value="<?=data014?>" readonly="readonly"></td>
<th><?=Data[0][15]?></th><td><input type="text" name="data015" value="<?=data015?>" readonly="readonly" class="readonly"></td>
<th><?=Data[0][16]?></th><td>
<div class="select"><select name="data016" readonly="readonly">
<?
  if(data016==""){output.append('<option value="" selected></option>');}else{output.append('<option value="" disabled=""></option>');}
  if(data016=="男性"){output.append('<option value="男性" selected>男性</option>');}else{output.append('<option value="男性" disabled="">男性</option>');}
  if(data016=="女性"){output.append('<option value="女性" selected>女性</option>');}else{output.append('<option value="女性" disabled="">女性</option>');}
  if(data016=="その他"){output.append('<option value="その他" selected>その他</option>');}else{output.append('<option value="その他" disabled="">その他</option>');}
?>
</select></div>
</td>
<th><?=Data[0][17]?></th><td><input type="text" name="data017" value="<?=data017?>" readonly="readonly"></td>
<th><?=Data[0][18]?></th><td><input type="text" name="data018" value="<?=data018?>" readonly="readonly"></td>
<th><?=Data[0][19]?></th><td><input type="text" name="data019" value="<?=data019?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][20]?></th><td><input type="text" name="data020" value="<?=data020?>" readonly="readonly"></td>
<th><?=Data[0][21]?></th><td><input type="text" name="data021" value="<?=data021?>" readonly="readonly"></td>
<th><?=Data[0][22]?></th><td><input type="text" name="data022" value="<?=data022?>" readonly="readonly"></td>
<th><?=Data[0][23]?></th><td><input type="text" name="data023" value="<?=data023?>" readonly="readonly"></td>
<th><?=Data[0][24]?></th><td><input type="text" name="data024" value="<?=data024?>" readonly="readonly"></td>
<th><?=Data[0][25]?></th><td><input type="text" name="data025" value="<?=data025?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][26]?></th><td><input type="text" name="data026" value="<?=data026?>" readonly="readonly"></td>
<th><?=Data[0][27]?></th><td><input type="text" name="data027" value="<?=data027?>" readonly="readonly"></td>
<th><?=Data[0][28]?></th><td><input type="text" name="data028" value="<?=data028?>" readonly="readonly"></td>
<th><?=Data[0][29]?></th><td><input type="text" name="data029" value="<?=data029?>" readonly="readonly"></td>
<th><?=Data[0][30]?></th><td><input type="text" name="data030" value="<?=data030?>" readonly="readonly"></td>
<th><?=Data[0][31]?></th><td><input type="text" name="data031" value="<?=data031?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][32]?></th><td><input type="text" name="data032" value="<?=data032?>" readonly="readonly"></td>
<th><?=Data[0][33]?></th><td><input type="text" name="data033" value="<?=data033?>" readonly="readonly"></td>
<th><?=Data[0][34]?></th><td><input type="text" name="data034" value="<?=data034?>" readonly="readonly"></td>
<th><?=Data[0][35]?></th><td><input type="text" name="data035" value="<?=data035?>" readonly="readonly"></td>
<th><?=Data[0][36]?></th><td><input type="text" name="data036" value="<?=data036?>" readonly="readonly"></td>
<th><?=Data[0][37]?></th><td><input type="text" name="data037" value="<?=data037?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][38]?></th><td><input type="text" name="data038" value="<?=data038?>" readonly="readonly"></td>
<th><?=Data[0][39]?></th><td><input type="text" name="data039" value="<?=data039?>" readonly="readonly"></td>
<th><?=Data[0][40]?></th><td><input type="text" name="data040" value="<?=data040?>" readonly="readonly"></td>
<th><?=Data[0][41]?></th><td><input type="text" name="data041" value="<?=data041?>" readonly="readonly"></td>
<th><?=Data[0][42]?></th><td><input type="text" name="data042" value="<?=data042?>" readonly="readonly"></td>
<th><?=Data[0][43]?></th><td><input type="text" name="data043" value="<?=data043?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][44]?></th><td><input type="text" name="data044" value="<?=data044?>" readonly="readonly"></td>
<th><?=Data[0][45]?></th><td><input type="text" name="data045" value="<?=data045?>" readonly="readonly"></td>
<th><?=Data[0][46]?></th><td><input type="text" name="data046" value="<?=data046?>" readonly="readonly"></td>
<th><?=Data[0][47]?></th><td><input type="text" name="data047" value="<?=data047?>" readonly="readonly"></td>
<th><?=Data[0][48]?></th><td><input type="text" name="data048" value="<?=data048?>" readonly="readonly"></td>
<th><?=Data[0][49]?></th><td><input type="text" name="data049" value="<?=data049?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][50]?></th><td><input type="text" name="data050" value="<?=data050?>" readonly="readonly"></td>
<th><?=Data[0][51]?></th><td><input type="text" name="data051" value="<?=data051?>" readonly="readonly"></td>
<th><?=Data[0][52]?></th><td><input type="text" name="data052" value="<?=data052?>" readonly="readonly"></td>
<th><?=Data[0][53]?></th><td><input type="text" name="data053" value="<?=data053?>" readonly="readonly"></td>
<th><?=Data[0][54]?></th><td><input type="text" name="data054" value="<?=data054?>" readonly="readonly"></td>
<th><?=Data[0][55]?></th><td><input type="text" name="data055" value="<?=data055?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][56]?></th><td><input type="text" name="data056" value="<?=data056?>" readonly="readonly"></td>
<th><?=Data[0][57]?></th><td><input type="text" name="data057" value="<?=data057?>" readonly="readonly"></td>
<th><?=Data[0][58]?></th><td><input type="text" name="data058" value="<?=data058?>" readonly="readonly"></td>
<th><?=Data[0][59]?></th><td><input type="text" name="data059" value="<?=data059?>" readonly="readonly"></td>
<th><?=Data[0][60]?></th><td><input type="text" name="data060" value="<?=data060?>" readonly="readonly"></td>
<th><?=Data[0][61]?></th><td><input type="text" name="data061" value="<?=data061?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][62]?></th><td><input type="text" name="data062" value="<?=data062?>" readonly="readonly"></td>
<th><?=Data[0][63]?></th><td><input type="text" name="data063" value="<?=data063?>" readonly="readonly"></td>
<th><?=Data[0][64]?></th><td><input type="text" name="data064" value="<?=data064?>" readonly="readonly"></td>
<th><?=Data[0][65]?></th><td><input type="text" name="data065" value="<?=data065?>" readonly="readonly"></td>
<th><?=Data[0][66]?></th><td><input type="text" name="data066" value="<?=data066?>" readonly="readonly"></td>
<th><?=Data[0][67]?></th><td><input type="text" name="data067" value="<?=data067?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][68]?></th><td><input type="text" name="data068" value="<?=data068?>" readonly="readonly"></td>
<th><?=Data[0][69]?></th><td><input type="text" name="data069" value="<?=data069?>" readonly="readonly"></td>
<th><?=Data[0][70]?></th><td><input type="text" name="data070" value="<?=data070?>" readonly="readonly"></td>
<th><?=Data[0][71]?></th><td><input type="text" name="data071" value="<?=data071?>" readonly="readonly"></td>
<th><?=Data[0][72]?></th><td><input type="text" name="data072" value="<?=data072?>" readonly="readonly"></td>
<th><?=Data[0][73]?></th><td><input type="text" name="data073" value="<?=data073?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][74]?></th><td><input type="text" name="data074" value="<?=data074?>" readonly="readonly"></td>
<th><?=Data[0][75]?></th><td><input type="text" name="data075" value="<?=data075?>" readonly="readonly"></td>
<th><?=Data[0][76]?></th><td><input type="text" name="data076" value="<?=data076?>" readonly="readonly"></td>
<th><?=Data[0][77]?></th><td><input type="text" name="data077" value="<?=data077?>" readonly="readonly"></td>
<th><?=Data[0][78]?></th><td><input type="text" name="data078" value="<?=data078?>" readonly="readonly"></td>
<th><?=Data[0][79]?></th><td><input type="text" name="data079" value="<?=data079?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][80]?></th><td><input type="text" name="data080" value="<?=data080?>" readonly="readonly"></td>
<th><?=Data[0][81]?></th><td><input type="text" name="data081" value="<?=data081?>" readonly="readonly"></td>
<th><?=Data[0][82]?></th><td><input type="text" name="data082" value="<?=data082?>" readonly="readonly"></td>
<th><?=Data[0][83]?></th><td><input type="text" name="data083" value="<?=data083?>" readonly="readonly"></td>
<th><?=Data[0][84]?></th><td><input type="text" name="data084" value="<?=data084?>" readonly="readonly"></td>
<th><?=Data[0][85]?></th><td><input type="text" name="data085" value="<?=data085?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][86]?></th><td><input type="text" name="data086" value="<?=data086?>" readonly="readonly"></td>
<th><?=Data[0][87]?></th><td><input type="text" name="data087" value="<?=data087?>" readonly="readonly"></td>
<th><?=Data[0][88]?></th><td><input type="text" name="data088" value="<?=data088?>" readonly="readonly"></td>
<th><?=Data[0][89]?></th><td><input type="text" name="data089" value="<?=data089?>" readonly="readonly"></td>
<th><?=Data[0][90]?></th><td><input type="text" name="data090" value="<?=data090?>" readonly="readonly"></td>
<th><?=Data[0][91]?></th><td><input type="text" name="data091" value="<?=data091?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][92]?></th><td><input type="text" name="data092" value="<?=data092?>" readonly="readonly"></td>
<th><?=Data[0][93]?></th><td><input type="text" name="data093" value="<?=data093?>" readonly="readonly"></td>
<th><?=Data[0][94]?></th><td><input type="text" name="data094" value="<?=data094?>" readonly="readonly"></td>
<th><?=Data[0][95]?></th><td><input type="text" name="data095" value="<?=data095?>" readonly="readonly"></td>
<th><?=Data[0][96]?></th><td><input type="text" name="data096" value="<?=data096?>" readonly="readonly"></td>
<th><?=Data[0][97]?></th><td><input type="text" name="data097" value="<?=data097?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][98]?></th><td><input type="text" name="data098" value="<?=data098?>" readonly="readonly"></td>
<th><?=Data[0][99]?></th><td><input type="text" name="data099" value="<?=data099?>" readonly="readonly"></td>
<th><?=Data[0][100]?></th><td><input type="text" name="data100" value="<?=data100?>" readonly="readonly"></td>
<th><?=Data[0][101]?></th><td><input type="text" name="data101" value="<?=data101?>" readonly="readonly"></td>
<th><?=Data[0][102]?></th><td><input type="text" name="data102" value="<?=data102?>" readonly="readonly"></td>
<th><?=Data[0][103]?></th><td><input type="text" name="data103" value="<?=data103?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][104]?></th><td><input type="text" name="data104" value="<?=data104?>" readonly="readonly"></td>
<th><?=Data[0][105]?></th><td><input type="text" name="data105" value="<?=data105?>" readonly="readonly"></td>
<th><?=Data[0][106]?></th><td><input type="text" name="data106" value="<?=data106?>" readonly="readonly"></td>
<th><?=Data[0][107]?></th><td><input type="text" name="data107" value="<?=data107?>" readonly="readonly"></td>
<th><?=Data[0][108]?></th><td><input type="text" name="data108" value="<?=data108?>" readonly="readonly"></td>
<th><?=Data[0][109]?></th><td><input type="text" name="data109" value="<?=data109?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][110]?></th><td><input type="text" name="data110" value="<?=data110?>" readonly="readonly"></td>
<th><?=Data[0][111]?></th><td><input type="text" name="data111" value="<?=data111?>" readonly="readonly"></td>
<th><?=Data[0][112]?></th><td><input type="text" name="data112" value="<?=data112?>" readonly="readonly"></td>
<th><?=Data[0][113]?></th><td><input type="text" name="data113" value="<?=data113?>" readonly="readonly"></td>
<th><?=Data[0][114]?></th><td><input type="text" name="data114" value="<?=data114?>" readonly="readonly"></td>
<th><?=Data[0][115]?></th><td><input type="text" name="data115" value="<?=data115?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][116]?></th><td><input type="text" name="data116" value="<?=data116?>" readonly="readonly"></td>
<th><?=Data[0][117]?></th><td><input type="text" name="data117" value="<?=data117?>" readonly="readonly"></td>
<th><?=Data[0][118]?></th><td><input type="text" name="data118" value="<?=data118?>" readonly="readonly"></td>
<th><?=Data[0][119]?></th><td><input type="text" name="data119" value="<?=data119?>" readonly="readonly"></td>
<th><?=Data[0][120]?></th><td><input type="text" name="data120" value="<?=data120?>" readonly="readonly"></td>
<th><?=Data[0][121]?></th><td><input type="text" name="data121" value="<?=data121?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][122]?></th><td><input type="text" name="data122" value="<?=data122?>" readonly="readonly"></td>
<th><?=Data[0][123]?></th><td><input type="text" name="data123" value="<?=data123?>" readonly="readonly"></td>
<th><?=Data[0][124]?></th><td><input type="text" name="data124" value="<?=data124?>" readonly="readonly"></td>
<th><?=Data[0][125]?></th><td><input type="text" name="data125" value="<?=data125?>" readonly="readonly"></td>
<th><?=Data[0][126]?></th><td><input type="text" name="data126" value="<?=data126?>" readonly="readonly"></td>
<th><?=Data[0][127]?></th><td><input type="text" name="data127" value="<?=data127?>" readonly="readonly"></td>
</tr><tr>
<th><?=Data[0][128]?></th><td><input type="text" name="data128" value="<?=data128?>" readonly="readonly"></td>
<th><?=Data[0][129]?></th><td><input type="text" name="data129" value="<?=data129?>" readonly="readonly"></td>
<th><?=Data[0][130]?></th><td><input type="text" name="data130" value="<?=data130?>" readonly="readonly"></td>
</tr>
</table>
<div style="margin:20px auto;text-align:center;"><input type="submit" value="更新"></div>
</form>

<? //} ?>

<?!= HtmlService.createHtmlOutputFromFile('_js').getContent(); ?>
</body>
</html>