开发者

When a user submits a Google Form, can an email be generated with the submitted data?

开发者 https://www.devze.com 2023-01-25 08:24 出处:网络
I have a Google Form where users开发者_如何转开发 enter the data, is there anyway I could get the data in email when the user has submitted data?

I have a Google Form where users开发者_如何转开发 enter the data, is there anyway I could get the data in email when the user has submitted data?

If that doesn't work I want to create my own form using(PHP or JavaScript), is there a way where i could send the data from my form to Google Form.

Thank you


Have you looked at http://code.google.com/googleapps/appsscript/guide_events.html#Installable

section titled "More Detailed Events" ?


Regarding your second paragraph about sending the data to your Google Form, you could do it by making the post url (action=) attribute of your form the same where the the Google Form posts its data. As long as your form input's have the same name it won't know where that the data isn't coming from the Google Form but rather from your site.


Yes, you can do this with an installable trigger from Google Apps Script (using JavaScript). Here is a code sample you can start with. Here's another example but less relevant as it's based on certain values in a cell, not a Google Forms submission.

If you end up creating your own web form, you would submit it directly to Google Sheets (where all Forms submissions go) and not Google Forms. (There's no need for both a web form and Google Forms.) Also in this case, instead of using Apps Script, you'd be using the Google Sheets API from your web app. Here are API quickstarts for PHP and Node.js to get started with.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号