問題描述
如何將數據從網絡表單發送到 Google 電子表格?我使用 Google Drive 制作了一個表單，但要運行自定義 CSS，我需要復制表單標簽.
How can I send the data from a webform to a google spreadsheet? I made a form with Google Drive, but to get custom CSS running, I need to copy the form tag.
就我而言，這就是谷歌為發送按鈕行為生成的內容
In my case, that is what google generated for the send button behavior
<form action="https://docs.google.com/forms/d/113H_71nd98TWE0bByjHYNpnC-
oVA6OBDWtppU30rBrU/formResponse" method="POST" id="ss-form" target="_self" onsubmit="">
但是，我想將我自己設計的表單中的數據發布到上述 Google 表單響應電子表格中.這是我的表單代碼(使用 Bootstrap 3):
However, I want to post data from my own designed form to the above Google Form Response spreadsheet. Here is my form code (using Bootstrap 3):
<form class="form-horizontal" role="form" id="ftk-contact">
<h4>Get in touch with us now</h4>
<div class="form-group">
<label for="inputType" class="col-lg-2 control-label">Type of Inquiry</label>
<div class="col-lg-10">
<select class="form-control" id="inputType">
<option>Request a Quotation</option>
<option>Request a Bluebook</option>
<option>General Inquiry</option>
</select>
</div>
</div>
<div class="form-group">
<label for="inputName" class="col-lg-2 control-label">Name *</label>
<div class="col-lg-10">
<input type="text" class="form-control" id="inputName" placeholder="Your Name">
</div>
</div>
<div class="form-group">
<label for="inputEmail" class="col-lg-2 control-label">Email *</label>
<div class="col-lg-10">
<input type="email" class="form-control" id="inputEmail" placeholder="Your Email">
</div>
</div>
<div class="form-group">
<label for="inputCompany" class="col-lg-2 control-label">Company</label>
<div class="col-lg-10">
<input type="text" class="form-control" id="inputCompany" placeholder="Your Company Name">
</div>
</div>
<div class="form-group">
<label for="message" class="col-lg-2 control-label">Message *</label>
<div class="col-lg-10">
<textarea class="form-control" rows="5" placeholder="Your Message"></textarea>
</div>
</div>
<div class="form-group">
<label for="inputPhone" class="col-lg-2 control-label">Phone</label>
<div class="col-lg-10">
<input type="tel" class="form-control" id="inputPhone" placeholder="Your Phone Number">
</div>
</div>
<div class="form-group">
<label for="inputWeb" class="col-lg-2 control-label">URL</label>
<div class="col-lg-10">
<input type="url" class="form-control" id="inputWeb" placeholder="Your Website URL">
</div>
</div>
<div class="form-group">
<div class="col-lg-offset-2 col-lg-10">
<button type="submit" class="btn btn-primary btn-lg">Send your Inquiry now</button>
</div>
</div>
</form>
當使用上述 Google 表單操作時=...按發送時，我會轉到原始 Google 表單，而不是將表單條目復制到電子表格中.
When using the above Google form action=... I am taken to the original Google Form when pressing send, instead of the form entries being copied to the spreadsheet.
如果上述方法不起作用，我還能如何將表單數據發送到電子郵件或 Google Drive?
If the above approach wont work, how else can I send the form data to email or Google Drive?
推薦答案
這對我有用:
- 創建您的自定義表單
- 點擊查看實時表單后創建您的 Google 表單并查看源代碼
- 復制從<form>開始的html代碼直到 </form>
- Google 表單中的每個輸入字段都有 name 和 id 屬性，需要將它們復制到您的個人表單中
- 在您的表單中使用 Google 表單的表單操作中的 URL.
- 確保即使是提交按鈕也具有與 Google 表單源匹配的 ID 和名稱屬性.
- 如果您現在提交，它會將您帶到 Google 表單響應頁面.您可以通過提交 ajax 表單來避免這種情況.
如果您的自定義表單未驗證 Google 表單必填元素，那么您將再次被重定向到 Google 表單頁面.
If your custom form does not validate a Google form mandatory element, then you will again be redirected to the Google form page.
這篇關于Google 表單:將數據發送到電子表格的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！