Bumping for help!!
On Monday, August 25, 2014 2:29:01 PM UTC-4, Erin Johnson wrote:
>
> So here it goes...my supervisor had me create a spread sheet that allows
> us to automatically calculate the times of different segments of our show.
> When someone updates the spreadsheet with a new time he wants something to
> show in the document who last updated it and when (date and time).
>
> There is a way to see who revised it by clicking "revision history," but
> he wants something that shows up in the actual spreadsheet; without having
> to click any extra buttons. I found two scripts that work (listed below)
> but for some strange reason when I (the creator of the spreadsheet) make
> edits it shows my email, the date and time of the update. But when someone
> else makes an edit it only shows the date and time. EVEN if the updater has
> a Gmail address, is using Chrome and the spreadsheet is shared with them
> under 'can edit.'
>
> I used the following scripts:
>
> function onEdit(event)
> {
> var r = event.source.getActiveRange();
> var comment = r.getComment().replace("Last modified by: ","previously
> modified by");
> r.setComment("Last modified by: "
> +Session.getEffectiveUser().getEmail()+" on: "+(new Date())+comment);
> }
>
> AND
>
> function onEdit(e)
>
> {
> // Get all information, Cell, Date, User
>
> var sheet = event.source.getActiveSheet();
>
> var cell = event.source.getActiveRange();
>
> var date = Utilities.formatDate(new Date(), "GMT", "dd-MM-yyyy");
>
> var user = Session.getActiveUser().getUserLoginId();
>
> //Write to Cell Comment
>
> cell.setComment(date + " User:" + user);
> var user = Session.getActiveUser().getEmail();
> sheet.getRange(index, (dateCol + 1)).setValue(user);
>
> }
>
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
