我是否可以自动在Google表格列中记录其他Google表格由其他人编辑过的时间？ [英] Can I automatically Record in a google sheet column , the timings that other google sheets have been edited by others?

问题描述

我在Google文档中有超过50张表格，我已经与很多人分享过。我是否可以自动记录和输入每个人更新另一张表中特定列中的表格的时间？通知是好的，但不是手动输入每个人更新工作表的时间，可以自动进行？

PS1）如果是，可以我还会获得编辑下一列中工作表的人员的编号，以确定时间？

PS2）如果是，那么是否有可能获得更新列表，即1个用户进行5次编辑将有5个不同的时间，另一列将选择最后更新的时间。 p>

这样可以节省我的时间，并帮助我在用户（雇员）上保留一个选项卡，并给予改进的机会。

解决方案

您需要附加onEdit事件处理程序。如果您拥有Google Apps for Work帐户，则只能获取用户帐户信息。

您可能需要检查以下问题的答案：如何将附加单元格值事件/脚本附加到Google表格

- 只是意见 -

Google Drive / Apps for Work专为协作而设计，而微型管理不得不看每一个单独的编辑）类型打败了自己的目的。我的建议是使用内置的修订版追踪器，它可以为您提供更为紧凑（高效，管理方式）的编辑视图。您可以使用Google Apps脚本获取Google驱动器活动发送您的经理会定期更新哪些文件已更改，以便他们可以检查这些文件。

I have over 50 sheets in google docs that I have shared with many people. Can I automate the recording and entry of time that each person updates the sheet in a particular column in another sheet ? Notifications is fine but instead of manually entering the timing each person updates the sheet , can it be automated ?

P.S.1) If yes , can I also get the ID of the person who has edited the sheet in the next column to timing ?

P.S.2) If yes again , is it possible to get a list of updates i.e 1 user making 5 edits will have 5 different timing and another column which picks the last updated time .

This would universally save me time and help me keep a tab on my users ( employees ) and also give then a chance to improve .

解决方案

You need to attach an onEdit event handler.

You can only get user account info if you have a Google Apps for Work account.

You may want to check answer to this question: how to attach onChange cell value event/script to google sheet

-- just opinion --

Google Drive/Apps for Work is built for collaboration, and such micro-management (having to see every single edit) kind of defeat its very own purpose. My suggestion is just use the built-in revision tracker, which gives you a more compact (and efficient, management-wise) view of the edits. You can get Google drive activity using Google Apps Script to send your manager a periodic update on what files were changed so they can check on those.

这篇关于我是否可以自动在Google表格列中记录其他Google表格由其他人编辑过的时间？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！