如何从不是编辑者的协作者那里修改Google电子表格? [英] HOW TO modify a google spreadsheet from collaborators that aren't editors?

问题描述

我有一个硕士和一个客户google电子表格 客户是原版的副本 我只能在master ss中访问，而我的协作者仅在客户端ss中可以访问.我的合作者可以编辑客户的ss；然后单击菜单(称为注册")应将其修改内容写在Master ss上，并自动向我发送一封邮件.

I have a master and a client google spreadsheet Client is a copy of the master I only can access in master ss, my collaborator only in the client ss. My collaborator can edit the client ss; then clicking a menu (called "register") should write his modifications on the Master ss and send me automatically a mail.

好吧，如果我的协作者是母版上的编辑器，那一切都很好；否则注册脚本将无法执行.

Ok, all is ok if my collaborator is a editor on the master; otherwise the register script doesn't go.

我该怎么办?我已经找到了它，并且发现有一个AddEditor方法，但我不知道使用方法.

How can I do? I have looked for this and I have seen that there is an AddEditor method but I don't know use.

var tss = SpreadsheetApp.openById('SS.KEY')

var tss = SpreadsheetApp.openById('SS.KEY')

这里有一个错误；您没有权限...

here there is an error; You don't have permissions...

谢谢

推荐答案

使用网络应用.即使用您的帐户为主电子表格创建一个网络应用.您可以从URL触发Web应用程序，甚至可以传递参数. 使用能够调用Web应用程序的脚本来设置客户端电子表格.

Use a web app. i.e. create a web app for the master spreadsheet using your account. You can trigger the web app from a URL and even pass parameters. Setup the client spreadsheet with a script that is able to call the web app.

该网络应用将以您的所有权限按您的方式"运行.客户脚本将作为编辑客户电子表格的人员运行.

The webapp will run "As you", with all your rights. The client script will run as the person editing the client spreadsheet.

这篇关于如何从不是编辑者的协作者那里修改Google电子表格?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！