如何使用Google Apps脚本构建决策支持应用（带有子问题的表单）？ [英] How to build a decision support app with Google Apps Script (forms with subquestions)?

问题描述

我想创建一个应用程序，帮助新手雇主做出一些简单的决定。因此，使用他们对表单的回答，应用根据以前的回复提出新问题，类似于决策树。 Google Form是否是一个很好的替代方案来实现它？ （这里提供了这个，但有更多的问题：

是否有基于Google Apps Script的替代方案？

解决方案

您需要的是Google表单中包含很多问题，其答案可以重定向到表单中的不同页面。

您也可以使用Google Apps脚本表单服务通过代码创建表单（并且您可以在旧表单中使用以前的回复来生成动态地显示新表单的新内容）。

一个典型的例子是：
$ b

1. 创建Google表单，其中包含几个问题，并根据回答（决策树）重定向。


2. 请将表单的回复发送至回复电子表格。 b
3. 在t上运行脚本他响应Spreadsheet使用Google Apps脚本中的Forms Service生成新内容（或手动执行; ）


4. 通过电子邮件向员工发送新表单（您可以使用 Gmail服务即可完成此操作），或者您更喜欢。
并根据需要重复此过程。



在我的工作中，我使用带有重定向和脚本的Google表单来处理响应电子表格，以便使用Google Apps脚本处理教师请求。这是绝对有可能的！





---





不过，应该注意的是，Google Apps脚本不能用于在用户填写表单时为表单动态生成内容。 此处查看我的问题。




I want to create an app which helps newbie employers to take some simple decisions. So, using their answers to a form, the app asks new questions based on previous responses, something similar to a decision tree. Is Google Form a good alternative to implement this? (something like this suggested here, but with more questions:

Are there alternatives based on Google Apps Script?

解决方案

What you need is a Google Form with a lot of questions, whose answers redirect to different pages in the Form.

You can also use Google Apps Script Forms Service to create Forms through code (and you can use previous responses in old Forms to generate new content for new Forms dynamically).

A typical example of this would be:

1. Create a Google Form with several questions with redirects based on answers (decision trees).
2. Have the responses to that form go to a response Spreadsheet.
3. Run a script on the response Spreadsheet to generate new content using the Forms Service within Google Apps Script (or do this manually; both work).
4. Send out the new Form to employees by email (you can use Gmail Service to accomplish this) or however you prefer.

--> and repeat the process as needed.

At my work, I use Google Forms with redirects and scripts on the response Spreadsheets in order to process faculty requests using Google Apps Script, so this is definitely possible!

---

However, it should be noted that Google Apps Script cannot be used to dynamically generate content for Forms while the user is filling it out. See my question here.

这篇关于如何使用Google Apps脚本构建决策支持应用（带有子问题的表单）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！