+ Reply to Thread
Results 1 to 2 of 2

Add timestamp to appscript onEdit

  1. #1
    Registered User
    Join Date
    02-27-2009
    Location
    saco
    MS-Off Ver
    Google Docs
    Posts
    59

    Add timestamp to appscript onEdit

    I would like to have it that when a row is edited that it only copies the name phone and adds a timestamp of the edit on another tab in Google Sheets.

    Please Login or Register  to view this content.
    The above is working but i cannot figure out how to get the timestamp to show. It also creates a row no matter what tab I am in and I want it to only read edits from the main.

    The outcome should display the roadname, phone and then C:C should have timestamp of changed made.

    I have updated the below sheet to show expected outcome

    https://docs.google.com/spreadsheets...gid=1523701088

  2. #2
    Registered User
    Join Date
    04-07-2019
    Location
    Turkey-Ankara-Çubuk
    MS-Off Ver
    Office 2010
    Posts
    71

    Re: Add timestamp to appscript onEdit

    The Code will work after changes made in columns 1 and 3 on the MAIN page. I don't know English, I wrote with translate.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Exclude a specific sheet on onEdit function [Google Apps Script]
    By bhenlee in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 02-14-2023, 09:04 PM
  2. Exclude a specific sheet on onEdit function
    By bhenlee in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 02-09-2023, 11:21 PM
  3. [SOLVED] Google Sheets AppScript - Add custom link to retrieved value.
    By antonyx in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 04-28-2022, 09:19 AM
  4. Replies: 1
    Last Post: 04-19-2022, 01:42 PM
  5. Convert VBA" IF THEN" function into Google Appscript code
    By frnzy in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 12-19-2019, 01:52 AM
  6. Google Sheets onEdit Script Failing On Mobile
    By swordswinger710 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 10-11-2019, 12:21 PM
  7. Replies: 2
    Last Post: 11-09-2016, 02:23 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1