下拉验证列表动态创建(谷歌应用脚本) [英] Drop-down validation list created dynamically (google apps script)
问题描述
例如,在A1列表中包含:
B
$因此,如果用户从列表中选择A,则C1中的新列表包含:$ b)b $ b 1)令人讨厌的橙色b / b b
2)愤怒的小鸟
3)任意样本
如果用户选择B,则新列表包含:
<1> Bloated Code
<2>更好的左边未说明
3)错误的尝试
等
使用VBA很容易。但是在GAS中......我完全不知道如何开始:/ / $ / $>
用于数据验证的Apps脚本API刚发布:
http://googleappsdeveloper.blogspot.com/2013/08/answering-another-top-request-data.html
In range A1 I have a drop-down validation list. Based on the user's selection from that list I would like to dynamically create a new drop-down validation list in range C1. For instance, in A1 the list contains:
A
B
C
So if the user selects A from the list, the new list in C1 contains:
1) Annoying Orange
2) Angry Birds
3) Arbitrary Sample
If the user selects B, the new list contains:
1) Bloated Code
2) Better Left Unsaid
3) Bad Attempt
etc
Easy enough to do using VBA. But in GAS.... I have absolutely no idea of how to even start :/
The Apps Script API for data validation was just released: http://googleappsdeveloper.blogspot.com/2013/08/answering-another-top-request-data.html
这篇关于下拉验证列表动态创建(谷歌应用脚本)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!