Google Form输出到远程MySQL数据库 [英] Google Form output to remote MySQL database

问题描述

我有我创建的Google表单。我有一个远程MySQL数据库的网站。我想将Google表单嵌入到我的网站中（我想到了这一点），但是不是将表单提交的数据存储在Google电子表格中，而是希望将数据发送到我的MySQL数据库到预定义的表格，该表格旨在接受在Google表单中收集和验证的数据类型。

我研究并发现了Google Apps脚本（ https://developers.google.com/apps-script/guides/jdbc ）。我的问题是，我对Google Apps脚本没有经验，并且正在寻求指导。我拥有Google表单，可以访问我的Google Apps帐户以及具有管理员权限的连接字符串到我的远程MySQL数据库。我一直在寻找指导，一步一步，因为我还没有在网上找到任何教程。如果你能指导我学习一个教程，那也是值得赞赏的。

解决方案

最近，您可以在Google应用中使用数据库脚本。
使用JDBC Class的应用程序脚本支持（Google Cloud SQL，MySQL，Microsoft SQL Server和Oracle数据库）

执行： https://developers.google.com/apps-script/guides/jdbc

您可以在Google From中添加脚本。

I have a Google Form I created. I have a website with a remote MySQL database. I would like to embed the Google Form into my site (this I've figured out), however instead of the data from form submission being stored in a Google Spreadsheet(s), I'd like the data to be sent to my MySQL database, to a predefined table designed to accept the data types being collected and validated for in the Google Form.

I have researched and come across Google Apps Scripts (https://developers.google.com/apps-script/guides/jdbc). My issue is that I'm not experienced with Google Apps Scripts and am seeking guidance in setting this up. I have the Google Form, access to a my Google Apps account, and the connection string to my remote MySQL database with administrator privileges. I'm seeking guidance, step-by-step as I have not found any tutorials online yet. If you can guide me to a tutorial, that would be appreciated as well.

解决方案

Recently you can use a database in Google app script. App script support ( Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle databases ) with JDBC Class

DOcumentation : https://developers.google.com/apps-script/guides/jdbc

You can add script in Google From.

这篇关于Google Form输出到远程MySQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！