链接Google电子表格和谷歌表格 [英] Linking between Google Spreadsheet and google Forms

问题描述

亲爱的技术人员，请给我一个解决我问题的方法。

我是谷歌电子表格和表格的新手。并且不知道ABCD的脚本编写或java脚本。

我创建了一个名为Scheme的电子表格和一个名称为 <的表单/ b>我的驱动器中的计划报告。任何人都可以在

中查看它 www.sonenet.blogspot.com

我需要的是这两个项目之间的联系。

如果访问者选择一个特定的办公室名称，方案名称在 计划报告中表格，分配和余额栏中注明的相应数字必须自动显示在表格中。与此同时，访问者输入的数量为金额消耗将存储在另一个谷歌电子表格中。

有没有办法或方法来解决这个要求？

更多示例，

如果选择 VD Avoly 作为办公室名称和定期实地考察被选为计划名称，然后 10000 必须自动显示为 分配基金和 250 必须自动显示为余额金额

输入的数字如果输入的数字低于余额金额，则 金额已消耗框中的访问者必须保存在另一个电子表格中。如果输入的数字大于余额金额框中显示的数字，则会显示一条自定义错误消息。

问候

索尼托马斯，印度

[e-mail]

www.sonenet.blogspot.com

Hi,
Dear tech guys, pls give me a solution to my problem.
I'm new to google spreadsheet and form. And don't know A B C D of script writing or java script.
I have created a spreadsheet with name "Scheme" and a form with name "Scheme Report" in my drive. Anyone can view it in
www.sonenet.blogspot.com
My need is the linking between these two items.
If a visitor select a particular name of office, name of scheme in "Scheme Report" Form, the corresponding figures noted in the "Allotted" and "Balance" columns has to be automatically displayed in form. Alongwith this the amount the visitor enters as "Amount Expended" is to be stored in one another google spreadsheet.
Is there any way or method to solve this requirement??
For more example,
If "VD Avoly" is selected as "Name of Office" and "Regular Field Visit" is selected as "Name of Scheme" then "10000" has to be automatically displayed as "Allotted Fund" and "250" has to be automatically displayed as "Balance Amount"
And the number, entered by visitor in "Amount Expended" box has to be saved in another spreadsheet if the entered number is lower than balance amount. If the entered number is greater than the number displayed in "Balance Amount" box, then a custom error message to be displayed.
Regards
Sony Thomas, India
[e-mail]
www.sonenet.blogspot.com

推荐答案

这篇关于链接Google电子表格和谷歌表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！