如何在提交之前从Google表单中提取数据并显示结果? [英] How to pull data from Google Form and display result before submission?

问题描述

说我在这里有一个Google表单: https://docs.google. com/forms/d/1HnATawk6ioE7_EVKrtszxvScjmUSF7_ma0_9XhBZ-hw/viewform

Say I have a google form here: https://docs.google.com/forms/d/1HnATawk6ioE7_EVKrtszxvScjmUSF7_ma0_9XhBZ-hw/viewform

用户将输入数字.

作为确认，在他们提交表单之前，我想使用这些数字来显示他们可以在提交之前验证的数据分析. (确切地说，我想显示前4个数字的总和，然后显示后4个数字的总和，然后说明哪个和更大，再加上多少)

As a confirmation before they submit the form, I'd like to use those numbers to display the analysis of the data which they can verify before submission. (To be precise, I'd like to display the sum of the first 4 numbers, then the sum of the next 4 numbers, then state which sum is bigger, and by how much)

有没有办法做到这一点?

Is there any way to do this?

推荐答案

您要的是在Google表单中创建动态数据，而无需单击提交按钮.

What you are asking for is to create dynamic data in Google Forms without clicking the submit button.

在Google表单中无法实现.请查看可用触发器.

由于在加载表单后无法激活任何触发器，因此在填充过程中以及提交表单之前不能进行任何交互.甚至不使用脚本.

Since there can be no triggers activated after the form is loaded, there can be no interaction while filling and before submitting the form. Not even using a script.

说过，您的另一选择是改为使用HtmlService或UiServise并构建自己的Web应用程序.

Having said that your other choice would be to use the HtmlService or the UiServise instead and build your own web app.

这篇关于如何在提交之前从Google表单中提取数据并显示结果?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！