Google Apps Script - Create a Timestamp Using onEdit() 🕑

Поділитися
Вставка
  • Опубліковано 11 гру 2024

КОМЕНТАРІ • 9

  • @Brakken99
    @Brakken99 3 роки тому +1

    This code might appear to not be functioning in the end but please note that I found a pair of curly brackets that were clipped off of the right side of the video at min 9:13 starting here: ua-cam.com/video/yahnz7yME9E/v-deo.html. I hope this helps someone. Great vid!
    Full code:
    function onEdit(e) {

    let sheet = e.source.getActiveSheet();
    let = thisRow = e.range.getRow(),
    thisColumn = e.range.getColumn();
    let statusColumn = {
    top:3, //third row from the top
    bottom:12, //12th row from top
    col:3, //third col from the left
    };
    if(thisRow >= statusColumn.top && thisRow = statusColumn.top && thisRow

  • @mohamed.montaser
    @mohamed.montaser 4 роки тому

    you are awesome man, don't stop posting these videos

  • @kevinspaeth5895
    @kevinspaeth5895 3 роки тому

    Worked like a champ! Thanks!

  • @alvarohuaman2141
    @alvarohuaman2141 4 роки тому +2

    Hi, thx for the video, but i have some issues when i copy a range of cells (edit cells), the script is not working, for example if you select the cell C3 with the value Hired then you copy that cell (C3) then paste in the range (C4:C8) thats when the script its not working, plss help

  • @maherm.7966
    @maherm.7966 3 роки тому

    I like the script, how we can add username or user email after last edit column?

  • @anurudhhtiwari3793
    @anurudhhtiwari3793 4 роки тому

    Is timestamp for defined values(Number or word ) possible?

  • @josuejuannogueiralui9473
    @josuejuannogueiralui9473 4 роки тому

    It worked for some time. Now, it's not working anymore. Even so, thank you very much for the video!

  • @BusinessBananaShikhe
    @BusinessBananaShikhe 3 роки тому

    Some script share u

  • @darrenfontanilla8555
    @darrenfontanilla8555 3 роки тому

    HOW ABOUT TIME STAMP IN NEW SHEET