提交 Google 表单后显示自定义消息 [英] Display custom message after submitting a Google Form

问题描述

我有一个允许用户输入信息的 Google 表单.他们提交表单后，数据将作为新行插入到 Google 电子表格中.

I have a Google Form that allows user to enter their information. After they submit the form, the data is inserted to a Google spreadsheet as a new row.

但是，我想在提交表单后立即显示动态消息，覆盖原始的谢谢"消息.新消息会显示他们刚刚填写的信息，并为他分配一个号码.

However I want to show a dynamic message right after the form is submitted, overriding the original "thank you" message. The new message would display the information they just filled in, with an number assigned to him.

例如，玛丽填写了她的数据并提交了表单.由于玛丽是提交此表单的第 5 个人，因此消息将她的号码显示为 5.

有什么办法可以做到这一点吗?我一直在研究 Google App Script 和 HTML 服务，但我不确定这是否是正确的方法.

Is there any way to achieve this? I have been studying Google App Script and HTML service but I am not sure if this is the correct way.

请注意，我们已经使用电子邮件发送此消息好几年了，但是用户强烈建议在提交表单后立即显示他们的 ID 会使很多事情变得容易得多.

Please note that we have already using email to send out this message for several years however user strongly suggest that showing their ID right after form submission would make lots of things much easier.

非常感谢！

我一直在研究它，现在我可以制作一个网页，在电子表格中插入一个新行.但另一个问题:如何发布网页?当我打开/dev"链接时，它工作正常；但是，当我打开/exec"链接时，它说找不到Index.html"，我确定有一个名为 Index.html 的文件.

I have been working on it and now I am able to make a web page that inserts a new row to a spreadsheet. But another question: How to publish the web page? When I open the "/dev" link it works fine; However when I open the "/exec" link it says cannot find "Index.html" and I am sure there is a file called Index.html.

推荐答案

没有办法为的当前用户添加自定义确认消息当前打开表单.您可以运行代码来在提交表单时更改确认消息，但是在提交表单时更改确认消息将不会生效，直到打开 NEXT 表单，这为时已晚.所以下一个打开表单的人会收到前一个用户的确认信息.

There is no way to add a custom confirmation message for the current user of the currently open Form. You can run code to change the confirmation message when the Form is submitted, but changing the confirmation message when the Form is submitted won't take affect until the NEXT Form is opened, and that's too late. So the next person to open the Form would get the confirmation message of the previous user.

您需要将所有内容都转换为一个独立的 HTML 应用程序来实现类似的功能.

You would need to convert everything to a stand alone HTML App for something like that.

这篇关于提交 Google 表单后显示自定义消息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！