I have a spreadsheet which I want only to be modifiable when the user is using custom menu functions (using the .addMenu function). If I set the sheet's sharing permissions so that only I can edit, but everyone else can view, the custom menu is greyed out for anyone logging in.
我有一个电子表格，我只想在用户使用自定义菜单函数(使用。addmenu函数)时修改它。如果我设置了该表的共享权限，以便只有我可以编辑，但其他人都可以查看，那么自定义菜单将为任何登录者设置灰色。
I tried to work around this by giving the users access rights to the spreadsheet, but then protecting each sheet but the same issue occurs.
我试图通过给用户访问电子表格的权限来解决这个问题，但是保护每个表，但是同样的问题发生了。
Basically I want the user to be able to add data to the spreadsheet but only when using the custom functions. For example when one of my employees wants to place a new order, he must get authorisation from the Chief Accountant to do so. I have made it so that this order request is entered into a form by the user, which then populates the spreadsheet and alerts via email the accountant that there is a new order pending approval. I want the accountant to then open the sheet, and use the menu item 'approve/deny', which will mark the approval column of the specific request as 'approved/denied'. I do NOT want him to be able to edit this column manually.
基本上，我希望用户能够将数据添加到电子表格中，但只有在使用定制函数时才可以。例如，当我的一个雇员想要下一个新订单时，他必须得到总会计师的授权。我这样做是为了让用户将这个订单请求输入到一个表单中，然后该表单将填充电子表格，并通过电子邮件通知会计师有一个新的订单正在等待批准。我想让会计打开表格，使用菜单项“approve/deny”，将具体请求的approval列标记为“approved/denied”。我不希望他能够手动编辑这个专栏。
Basically I think I need the script to be able to be called by the user, but run as myself. Is this possible?
基本上，我认为我需要脚本能够被用户调用，但是我自己运行。这是可能的吗?
Thanks for any assistance.
感谢任何帮助。
1 个解决方案
#1
0
You cannot do it by controlling access to the spreadsheet. The best solution for you is to have your accountant NOT opening the spreadsheet at all ! You can embed a HTML form in the email that is sent to the accountant from where he/she can approve/reject the request. To see how you can build such a system, see this video from I/O 2011 http://www.youtube.com/watch?v=96URE_-aj-8
您不能通过控制对电子表格的访问来实现这一点。对你来说，最好的解决办法就是让你的会计师完全不打开电子表格!您可以在发送给会计的电子邮件中嵌入一个HTML表单，从那里他/她可以批准/拒绝该请求。要了解如何构建这样的系统，请参见下面的视频:I/O 2011 http://www.youtube.com/watch? v=96ure_aj-8。
It demonstrates a use case very similar to yours.
它演示了一个与您的用例非常相似的用例。
#1
0
You cannot do it by controlling access to the spreadsheet. The best solution for you is to have your accountant NOT opening the spreadsheet at all ! You can embed a HTML form in the email that is sent to the accountant from where he/she can approve/reject the request. To see how you can build such a system, see this video from I/O 2011 http://www.youtube.com/watch?v=96URE_-aj-8
您不能通过控制对电子表格的访问来实现这一点。对你来说，最好的解决办法就是让你的会计师完全不打开电子表格!您可以在发送给会计的电子邮件中嵌入一个HTML表单，从那里他/她可以批准/拒绝该请求。要了解如何构建这样的系统，请参见下面的视频:I/O 2011 http://www.youtube.com/watch? v=96ure_aj-8。
It demonstrates a use case very similar to yours.
它演示了一个与您的用例非常相似的用例。