团队驱动器上的Google电子表格不运行脚本 [英] Google spreadsheet on team drive not running script

问题描述

我的团队云端硬盘上有一个Google表单，它在提交时将这些数据拉到电子表格中。我在该电子表格中使用了一个脚本，用于将唯一网址提供给特定的提交表单。我的团队成员可以提交表单并访问电子表格进行编辑，但脚本仅适用于我。我所有的团队成员都可以完全访问驱动器。尽管我知道如何解决这个问题，但我只搜索了潜在的答案。其中一个答案是将脚本作为Web应用程序或API可执行文件发布。这有点超出我的范围，但希望能够为我的团队工作，因为它非常有用。更不用说我可以将这些信息传递给其他项目，如果我能解决它。任何输入将不胜感激！

I have a google form on my Team Drive that when submitted pulls that data to a spreadsheet. I used a script within that spreadsheet that pulls the unique URL to that specific submitted form. My team members are able to submit the form and access the spreadsheet for editing, however the script only runs for me. All of my team members have full access to the drive. I have scoured as far as I know how to resolve this issue but have only come to potential answers. One of those answers was to publish the script as a web app or API executable. This is a little out of my scope but would love to get this working for my team as it is extremely useful. Not to mention I could relay this information to other projects if I can get it resolved. Any input would be greatly appreciated!

推荐答案

如果您已经创建了脚本，那么发布脚本并不困难。 请参阅此处的链接以了解如何操作（请参阅部署脚本作为一个web应用程序：六个简单的步骤！）
另外从文档：部署团队云端硬盘中的Web应用程序时，选择以您身份执行会导致Web应用程序在用户的权限下执行部署它（因为没有脚本所有者）。

If you have created a script then publishing the script is not that difficult. See the link here to see how to do it (See deploying a script as a web app: six simple steps!) Also from the documentation: When a web app in a Team Drive is deployed, choosing to "execute as you" causes the web app to execute under the authority of the user that deployed it (since there is no script owner).

这篇关于团队驱动器上的Google电子表格不运行脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！