スプレッドシートでフォームから書き込む仕様にしたくて、スプレッドシート上にshouhtmlでフォームを表示させているのですが、入力後際送信ボタンを押すとHTMLページに飛んでしまうのですが、classなどが間違っているのでしょうか
index.html
<!DOCTYPE html> <html lang="ja"> <head> <base target="_top"> </head> <body> <h2>webmaster管理</h2> <form method="post" action="https://script.google.com/macros/s/AKfycbxzYwMcEaofsHRoXnuTRuWHTVeKD_hK3VSudcfK5A/dev"> <div class="form-style-5"> <form> <fieldset> <legend><span class="number">1</span>webmaster追加</legend> <select id="job" name="field4"> <optgroup label="Indoors"> <option value="1">webmaster1</option> <option value="2">webmaster2</option> <option value="3">webmaster3</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> <option value="webmaster2">webmaster2</option> </optgroup> </select> <input type="text" name="field1" placeholder="URL *"> <input type="email" name="field2" placeholder="制作会社"> <textarea name="field3" placeholder="About yourself"></textarea> <label for="job">Interests:</label> </fieldset> <fieldset> <legend><span class="number">2</span> Additional Info</legend> <textarea name="field3" placeholder="About Your School"></textarea> </fieldset> <input type="submit" onclick="run_input()" value="送信する" /> </form> </div> </form> </body> <style> .form-style-5{ max-width: 500px; padding: 10px 20px; background: #f4f7f8; margin: 10px auto; padding: 20px; background: #f4f7f8; border-radius: 8px; font-family: Georgia, "Times New Roman", Times, serif; } .form-style-5 fieldset{ border: none; } .form-style-5 legend { font-size: 1.4em; margin-bottom: 10px; } .form-style-5 label { display: block; margin-bottom: 8px; } .form-style-5 input[type="text"], .form-style-5 input[type="date"], .form-style-5 input[type="datetime"], .form-style-5 input[type="email"], .form-style-5 input[type="number"], .form-style-5 input[type="search"], .form-style-5 input[type="time"], .form-style-5 input[type="url"], .form-style-5 textarea, .form-style-5 select { font-family: Georgia, "Times New Roman", Times, serif; background: rgba(255,255,255,.1); border: none; border-radius: 4px; font-size: 16px; margin: 0; outline: 0; padding: 7px; width: 100%; box-sizing: border-box; -webkit-box-sizing: border-box; -moz-box-sizing: border-box; background-color: #e8eeef; color:#8a97a0; -webkit-box-shadow: 0 1px 0 rgba(0,0,0,0.03) inset; box-shadow: 0 1px 0 rgba(0,0,0,0.03) inset; margin-bottom: 30px;}
.form-style-5 input[type="text"]:focus,
.form-style-5 input[type="date"]:focus,
.form-style-5 input[type="datetime"]:focus,
.form-style-5 input[type="email"]:focus,
.form-style-5 input[type="number"]:focus,
.form-style-5 input[type="search"]:focus,
.form-style-5 input[type="time"]:focus,
.form-style-5 input[type="url"]:focus,
.form-style-5 textarea:focus,
.form-style-5 select:focus{
background: #d2d9dd;
}
.form-style-5 select{
-webkit-appearance: menulist-button;
height:35px;
}
.form-style-5 .number {
background: #1abc9c;
color: #fff;
height: 30px;
width: 30px;
display: inline-block;
font-size: 0.8em;
margin-right: 4px;
line-height: 30px;
text-align: center;
text-shadow: 0 1px 0 rgba(255,255,255,0.2);
border-radius: 15px 15px 15px 0px;
}
.form-style-5 input[type="submit"],
.form-style-5 input[type="button"]
{
position: relative;
display: block;
padding: 19px 39px 18px 39px;
color: #FFF;
margin: 0 auto;
background: #1abc9c;
font-size: 18px;
text-align: center;
font-style: normal;
width: 100%;
border: 1px solid #16a085;
border-width: 1px 1px 3px;
margin-bottom: 10px;
}
.form-style-5 input[type="submit"]:hover,
.form-style-5 input[type="button"]:hover
{
background: #109177;
}
</style>
input.gs
function doPost(e){
//データを記録するスプレッドシート
var sheet =SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/jkhfdsfp:");
//データ取得
var name = e.parameter.name;
var food = e.parameter.food;
var field1 = e.parameter.field1;
var field2 = e.parameter.field2;
var date = new Date();
var field4 = e.parameter.field4;
//データ
var array = [field4,field1,field2];
sheet.appendRow(array);
return HtmlService.createHtmlOutputFromFile("index");}
あなたの回答
tips
プレビュー