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.
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.
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++){
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.
Too beautiful. God bless you!
very much helped me. thank you.
The part about Macros is the best ;). It looks like a handy tool.
Thanks it's helpful
This really helped me! Thanks! God bless you!
:)
Great!
Best Nice Fantastic
thank you so much!!!!!
Fantastic as usual
Thank you! Cheers!
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.
Thank you that`s really help!)
:)
Hi, this can also be done with filter() method ?
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
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
Great Tutorial 👍👍
Is there a way to delete cells then automaticly shift up?
developers.google.com/apps-script/reference/spreadsheet/range#deleteCells(Dimension)
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
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
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
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
I just need to automatically delete all empty rows every time the sheet is opened...how can I do this?
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
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()
SpreadsheetApp....why display color Red? Is
SpreadsheetApp = spreadsheetApp ?
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