是否可以使用Google App脚本在Google表格对话框中使用单选按钮并保存值? [英] Is there a way to use radio buttons in a Google Sheets Dialog and save the value, using Google App Scripts?

问题描述

简单地说，我的目标是在一个Google工作表(源")上突出显示一个单元格区域，然后将其移动到另一个不同的Google工作表文档(目标").目标有多个工作表(选项卡?)，并且经常添加新的工作表.

My goal, simply put, is to highlight a cell range on one google sheet (the 'source') and move it to another, different google sheet document (the 'target'). The Target has multiple sheets(tabs?) and new ones are added often.

重要提示:明确地说，我不是在同一文档中从一张纸复印到另一张纸.我正在从一个Google工作表文档复制到另一个复杂程度不同的Google工作表文档.

IMPORTANT: To be clear, I am NOT copying from one sheet to another sheet, in the same document. I am copying from one google sheet document, to a complexity different google sheet document.

当前，我有允许用户执行以下操作的代码:

Currently, I have code that allows users to:

1. 在SOURCE Google工作表中突出显示一个单元格区域.
2. 选择自定义菜单选项.
3. 选择自定义菜单选项后，突出显示的单元格区域中的数据将复制到TARGET谷歌表中.

当前，目标"已被硬编码.

Currently, the the "Target" is hardcoded.

我想做的是建立一个单选按钮列表. TARGET google工作表中存在的每个工作表都有一个单选按钮.允许用户选择一个，然后在按下确定"按钮时将数据移动到该特定工作表.

What I want to do is to build a Radio Button list. One Radio Button for every Sheet that exists in the TARGET google sheet. Allow the user to choose one, then move the data to that specific Sheet, when they press the "OK" button.

我已经搜索了一段时间，但是我什至找不到关于在Google表格对话框中放置单选按钮的任何信息，更不用说根据另一个Google表格文档中存在的表格构建单选按钮列表了.

I've searched for a while, but I'm unable to find anything about even putting radio buttons in a google sheets dialog, let alone build the radio button list based on sheets that exist in another google sheet document.

推荐答案

结束这个问题，因为我现在知道需要使用HTML.

Closing this question, as I now know HTML needs to be used.

这篇关于是否可以使用Google App脚本在Google表格对话框中使用单选按钮并保存值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！