Google 表单:将数据发送到电子表格

2022-01-10 00:00:00 google-drive-api forms html twitter-bootstrap

如何将数据从网络表单发送到 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?

推荐答案

这对我有用:

  1. 创建您的自定义表单
  2. 点击查看实时表单后创建您的 Google 表单并查看源代码
  3. 复制从<form>开始的html代码直到 </form>
  4. Google 表单中的每个输入字段都有 name 和 id 属性，需要将它们复制到您的个人表单中
  5. 在您的表单中使用 Google 表单的表单操作中的 URL.
  6. 确保即使是提交按钮也具有与 Google 表单源匹配的 ID 和名称属性.
  7. 如果您现在提交，它会将您带到 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.

相关文章