HTML输入字段以谷歌电子表格(HTML input field to Google Spreads

2019-11-03 16:41发布

看来我得几乎工作,但由于某些原因,当我试图从输入字段数据提交到谷歌的电子表格,它添加数据,但不是被inputed数据。 因此,在谷歌电子表格我看到时间戳的新条目,而不是在输入的数据。

下面的代码:

<script>
$('#emailForm').one('submit',function(){
    var inputField = encodeURIComponent($('#emailForm').val());
var baseURL = 'http://docs.google.com/forms/d/1vl7imylKoya3y8bnboD7WTQ5VsdVw1YmDA1-3_66Apo/formResponse?entry.1017875735=';
var submitRef = '&submit=Submit';
var submitURL = (baseURL + emailAddress + submitRef);
$(this)[0].action=submitURL;
$('#email').addClass('active').val('Thank You!');
setTimeout(function(){
  $('#form-container').hide();
  $('#update-form').animate({'width': '0px'},300,function(){
    $('#get-updates-link').hide();
      $('#email').addClass('active').val('Thank You!');
  });
},1000); 
</script>



<form action="https://docs.google.com/forms/d/1vl7imylKoya3y8bnboD7WTQ5VsdVw1YmDA1-3_66Apo/formResponse?entry.1017875735="

<form id="emailForm" action="" method="POST" target="no-target">
  <input id="email" type="email" placeholder="enter email" name="email">
  <button id="email-submit" type="submit"></button>
</form> 

Answer 1:

您已经定义了var inputField ,但后来提交过程中,你已经使用emailAddress在submitURL代码行。



文章来源: HTML input field to Google Spreadsheet