Nice video, thank you so much bro. Although I'm a beginner and I don't understand everything you say. I just don't want to copy all your code and use it, I want to understand it so I can use it on my own sheets.
Can you please help me make a google script onedit for old value, every time the column cell is edited will get the value of change cell. For example column A is price and column B is date. Everytime the price will change it well get the old value of the price and get the old value of date, and set the oldvalue to the other C previous price column D previous Date. Thank you in advance hope you can help me.
Thanks Sheets Ninja, I've been looking for a solution like this for a long time! Looking forward to trying it out. I couldn't find the "How to Authorize Script" tab. Could you please double check that it's in the sample data set?
Thank you Sheets Ninja! Is there a way to add a "Row Label" to this script? For example, I'd want the Edit Log to also have a column that shows me which customer (row label) was edited.
so you already have the row and column reference in the onEdit object, so you can grab the row label, say it's in column A, like this: let rowLabel = sheet.getRange(row,1).getValue(); And then you can just paste that value in with the rest of the data
Nice video, thank you so much bro. Although I'm a beginner and I don't understand everything you say. I just don't want to copy all your code and use it, I want to understand it so I can use it on my own sheets.
Awesome, keep it up, and you'll keep learning!
Thank you for the video. Is there a way to return the edited cells range with an onEdit(e) trigger when a filter is applied to the sheet?
Unfortunately, there isn't any way to trigger a script when you are using the filter tool.
Can you please help me make a google script onedit for old value, every time the column cell is edited will get the value of change cell. For example column A is price and column B is date. Everytime the price will change it well get the old value of the price and get the old value of date, and set the oldvalue to the other C previous price column D previous Date. Thank you in advance hope you can help me.
Thanks Sheets Ninja, I've been looking for a solution like this for a long time! Looking forward to trying it out.
I couldn't find the "How to Authorize Script" tab. Could you please double check that it's in the sample data set?
Yeah, for some reason it got deleted from there, I just added it, so if you redownload the sample, you will see it on there now.
@@SheetsNinja I ended up figuring it out from the info you provided. Thank you again legend!
Thank you Sheets Ninja! Is there a way to add a "Row Label" to this script? For example, I'd want the Edit Log to also have a column that shows me which customer (row label) was edited.
so you already have the row and column reference in the onEdit object, so you can grab the row label, say it's in column A, like this:
let rowLabel = sheet.getRange(row,1).getValue();
And then you can just paste that value in with the rest of the data
can't access the sheet
I just reset the visibility, you can make a copy of it now.