Google Apps Script Add Timestamp On Edit

แชร์
ฝัง
  • เผยแพร่เมื่อ 21 ธ.ค. 2024
  • This video covers adding Date and Time Stamps to specific columns in Google Sheets using the Apps Script onEdit() Function. In the first example we look at adding a Date/Time Stamp to Column B based on a new value being added to the same row in Column A and also assuming the Value in Column B is empty. In other words, this is a "one-time" only Date/Time stamp that does not update again if the same row in Column A is edited. In the second example we look at adding a Date/Time Stamp that refreshes each time a corresponding row in an adjacent column is updated.
    Learn more about Google Apps Script with this Beginner's Guide Book at Amazon.
    amzn.to/3MMvDZs
    DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via this link below
    #GoogleAppsScriptOnEdit
    #GoogleAppsScriptAddTimeStamp
    #GoogleAppsScriptAddTimeStampOnEdit

ความคิดเห็น •