thanks for this video ... if want to do the same but not with Checkboxes .. with color .. say if any cell in row is blue than Delete all row .. how i do it please .. thanks
Is there a way to move the row you checked to a separate sheet while also deleting it from the sheet you initially checked then also being able to check it on the new sheet you moved it to and sending it back to the original sheet?
maybe something like ws.copyTo(target_range) inserted above the ws.deleteRow line where target range is the sheet that stores the deleted values. Also be good to add a timestamp and logged in user name fields to the moved row.
Could you make a web app that can search/filter based on two columns of data? Maybe how to change the design to like add colors, table designs, logos, etc.
I keep getting execution error when I run the console log for colAdata. The line error is on line 5 and says " TypeError: Cannot read property 'getRange' of null" Any help would be appreciated.
how can we do copy row to archive tab and then delete from the data sheet can u show me a way. I cannot figure out as how to last row each time function myFunction() { const ss = SpreadsheetApp.getActiveSpreadsheet(); const ws = ss.getSheetByName('VA05'); const ts = ss.getSheetByName('Manufactured Items'); const ColLdata = ws.getRange("BI:BI").getValues(); for (i = 1; i < ColLdata.length-1; i++){
The part about Macros is the best ;). It looks like a handy tool.
Too beautiful. God bless you!
thanks for this video ... if want to do the same but not with Checkboxes .. with color .. say if any cell in row is blue than Delete all row .. how i do it please .. thanks
Is there a way to move the row you checked to a separate sheet while also deleting it from the sheet you initially checked then also being able to check it on the new sheet you moved it to and sending it back to the original sheet?
maybe something like ws.copyTo(target_range) inserted above the ws.deleteRow line where target range is the sheet that stores the deleted values. Also be good to add a timestamp and logged in user name fields to the moved row.
@@nztitirangi I did attempt this but it didn’t function
This really helped me! Thanks! God bless you!
:)
Is it possible to send the deleted row to another sheet? Just like a history sheet to record the data
developers.google.com/apps-script/reference/spreadsheet/range#movetotarget
Hi, my check box is in column AO. How to apply this code. I tried to change the index to 40 but not working. The script work only for column A. Thanks
Hi, this can also be done with filter() method ?
thank you so much!!!!!
I just need to automatically delete all empty rows every time the sheet is opened...how can I do this?
Could you make a web app that can search/filter based on two columns of data? Maybe how to change the design to like add colors, table designs, logos, etc.
why not on edit pass the reference to the box being changed value, validate the data then use the same row refrence passed by on edit to hide the row
Interesting as always!! But did I see the time as 3.30AM? Boy no way I can record a video of this quality at that time of the day.
3.30AM sounds about right lol
Fantastic as usual
Thank you! Cheers!
Great Tutorial 👍👍
Is there a way to delete cells then automaticly shift up?
developers.google.com/apps-script/reference/spreadsheet/range#deleteCells(Dimension)
Thanks it's helpful
SpreadsheetApp....why display color Red? Is
SpreadsheetApp = spreadsheetApp ?
I keep getting execution error when I run the console log for colAdata. The line error is on line 5 and says " TypeError: Cannot read property 'getRange' of null" Any help would be appreciated.
check the previous time you set the variable before getRange
variable = something
variable.getRange()
Thank you that`s really help!)
:)
Best Nice Fantastic
Great!
how can we do copy row to archive tab and then delete from the data sheet can u show me a way.
I cannot figure out as how to last row each time
function myFunction() {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const ws = ss.getSheetByName('VA05');
const ts = ss.getSheetByName('Manufactured Items');
const ColLdata = ws.getRange("BI:BI").getValues();
for (i = 1; i < ColLdata.length-1; i++){
if(ColLdata[i][0] === true ){
const copyToItem = ws.getRange(i+1,1,1,60);
copyToItem.copyTo()
ws.deleteRow(i+1);
}
}
};
hello
thanks for video
is it possible to have the code
thanks
Teacher...do you think I could ever be a Programmer!?!?
The code should run as soon as the box is checked.
Yeah I think this could be done as an onEdit function. Could make for some dynamic insert and delete row options. Maybe a future video!
@@kyle943 It's right, but cause of some reasons, I get a auth-warning!
onEdit has to be an installed trigger in this case