blocks|key|182045|text|谷歌编辑：多亏了后续评论中的附加信息，这个问题已经被澄清了，并归结为：“当用户在表单中进行选择时，是否可以自定义该表单上其他问题中的选项？”|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|182046|答:没有。参见Dynamically+edit+multiple+choice+options+in+live+Google+Form+using+Apps+Script。|182047|Original+Answer+-这篇文章解释了在编辑选项的来源(电子表格)时，如何更改表单中显示的选项。|182048|如果您的数据在Google+Spreadhsheet中，源电子表格中的onEdit或onChange触发器将能够响应名称和等级列表中的更改。|CODE|182049|onChange触发器是“可安装的”，并且能够执行简单onEdit不能执行的操作，例如修改表单，因此在这种情况下它将是更好的选择。|182050|在触发器函数中，使用FormsApp.openById()或FormsApp.openByUrl()，然后使用item.setChoices()更新前面的项目选择，从电子表格中读取值，就像创建表单时一样。|182051|奖励分数..。而不是盲目地覆盖选择，您可以读取现有的选择，并仅在更改时才更新它们。|182052|注意-在频繁更改的工作表上，或使用长列表时，此触发器的计算开销会很大。你可能会发现你遇到了谷歌的处理限制。|182053|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/18645999/dynamically-edit-multiple-choice-options-in-live-google-form-using-apps-script^0|14|U|0|0|2E|7|26|0|0|0|1H|0|0|1Y|Z|6|16|8|0|0|1T|0|8|R|6|0|0|2U|A|J|U|K|1J|H|0|0|15|0|0|1H|0^^$0|@$1|2|3|4|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|15|8|@$9|16|A|17|B|C]]|D|@$9|18|A|19|1|1A]]|E|$]]|$1|H|3|I|5|6|7|1B|8|@$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|1E|8|@$9|1F|A|1G|B|C]|$9|1H|A|1I|B|L]|$9|1J|A|1K|B|L]]|D|@]|E|$]]|$1|M|3|N|5|6|7|1L|8|@$9|1M|A|1N|B|C]|$9|1O|A|1P|B|L]|$9|1Q|A|1R|B|L]]|D|@]|E|$]]|$1|O|3|P|5|6|7|1S|8|@$9|1T|A|1U|B|C]|$9|1V|A|1W|B|L]|$9|1X|A|1Y|B|L]|$9|1Z|A|20|B|L]]|D|@]|E|$]]|$1|Q|3|R|5|6|7|21|8|@$9|22|A|23|B|C]]|D|@]|E|$]]|$1|S|3|T|5|6|7|24|8|@$9|25|A|26|B|C]]|D|@]|E|$]]|$1|U|3|-4|5|6|7|27|8|@]|D|@]|E|$]]]|V|$W|$5|X|Y|Z|E|$10|11]]]]

Edit: Thanks to the additional information in follow up comments, the question has been clarified, and boils down to this: "As a user makes selections in a Google Form, is it possible to customize the options in other questions on that form?"

A: No. See <a href="https://stackoverflow.com/questions/18645999/dynamically-edit-multiple-choice-options-in-live-google-form-using-apps-script">Dynamically edit multiple choice options in live Google Form using Apps Script</a>.

Original Answer - this explains how one could change the options presented in a form when the source of those options (a spreadsheet) was edited.

If your data is in a Google Spreadhsheet, an <code>onEdit</code> or <code>onChange</code> trigger in the source spreadsheet would be able to respond to changes in the name and grade lists. 

The <code>onChange</code> trigger is "installable", and is able to perform actions that a simple <code>onEdit</code> can't, such as modify a form, so it would be the better choice in this case.

In the trigger function, use <code>FormsApp.openById()</code> or <code>FormsApp.openByUrl()</code>, then update the previous item choices with <code>item.setChoices()</code>, reading the values from the spreadsheet just as you did when creating the form.

For bonus marks... instead of blindly overwriting the choices, you could read the existing choices and update them only if changed.

Caveat - on a sheet that changes frequently, or with long lists, this trigger will be computationally expensive. You may find that you run into Google's processing limits.

blocks|key|620814|text|据我所知，Google+Forms中不存在这种类型的客户端事件。Google+Apps+Script的脚本机制是为创建表单和其他文档而设计的，但是对于客户端功能来说还不够深入。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|620815|我建议您将表单拆分为多个页面，并使用“根据答案转到页面”功能来实现您想要的功能。|620816|使用form.addPageBreakItem()创建页面，并使用item.createChoice(value,+PageBreakItem)导航到正确的页面。|offset|length|style|CODE|620817|参考文献：|620818|Google+Apps+Script+Forms+Service|620819|addPageBreakItem|620820|createChoice|620821|entityMap|0|LINK|mutability|MUTABLE|url|https://developers.google.com/apps-script/reference/forms/|1|https://developers.google.com/apps-script/reference/forms/form#addPageBreakItem%2528%2529|2|https://developers.google.com/apps-script/reference/forms/multiple-choice-item#createChoice%2528String,PageBreakItem%2529^0|0|0|2|N|X|13|0|0|0|W|0|0|0|G|1|0|0|C|2|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|15|8|@$F|16|G|17|H|I]|$F|18|G|19|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|1A|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1B|8|@]|9|@$F|1C|G|1D|1|1E]]|A|$]]|$1|N|3|O|5|6|7|1F|8|@]|9|@$F|1G|G|1H|1|1I]]|A|$]]|$1|P|3|Q|5|6|7|1J|8|@]|9|@$F|1K|G|1L|1|1M]]|A|$]]|$1|R|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y]]|Z|$5|U|V|W|A|$X|10]]|11|$5|U|V|W|A|$X|12]]]]

As far as I know, this type of client side event does not exist in Google Forms. The scripting mechanisms of Google Apps Script are designed for creating forms and other documents, but do not reach very far for client-side functionality.

What I suggest is that you split the form into multiple pages and use the "Go to page based on answer" feature to achieve your desired functionality.

Use <code>form.addPageBreakItem()</code> to create pages and use the <code>item.createChoice(value, PageBreakItem)</code> to navigate to the correct page.

References:

<a href="https://developers.google.com/apps-script/reference/forms/" rel="nofollow">Google Apps Script Forms Service</a>

<a href="https://developers.google.com/apps-script/reference/forms/form#addPageBreakItem%28%29" rel="nofollow">addPageBreakItem</a>

<a href="https://developers.google.com/apps-script/reference/forms/multiple-choice-item#createChoice%28String,PageBreakItem%29" rel="nofollow">createChoice</a>

I have <a href="https://docs.google.com/forms/d/1wVvo-rabq-xxXTnWVRDBIwmRCKOA09QAtbNfbRWEG6Y/viewform" rel="nofollow noreferrer">this form</a>:

<img src="https://i.stack.imgur.com/x6y6Q.png" alt="Screen Shot">

If you see List Items - Student Name and Grades are getting populated from a Google Sheet.

What I want to do now is upon selection of List Item Grade, show only those students that belong to that particular grade in the "Select Student" selection...

How can it be done, because form has only two triggers: onOpen and onEdit?

Dynamic selection options in Google Apps Script for forms

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有​​如果您看到列表项-学生姓名和成绩正在从Google工作表中填充。我现在想要做的是在选择列表项目成绩时，在“选择学生”选项中只显示属于该特定成绩的学生...因为form只有两个触发器: onOpen和onEdit，怎么做呢？

问表单的Google Apps脚本中的动态选择选项
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问表单的Google Apps脚本中的动态选择选项EN