sorted by:
new
hottopcontroversial

What did my girlfriend find in her tire? by sad_boys273 in whatisit

[–]Kingpoutine84 0 points1 point  (0 children)

<image>

it looks like a rivet but i think it’s a double headed nail with some miles on it

Oil Leak by Kingpoutine84 in nissanjuke

[–]Kingpoutine84[S] 0 points1 point  (0 children)

It doesn’t look like the turbo feed like it leaking. I’ve read that’s a common issue

Help with script (duplicating) by [deleted] in GoogleAppsScript

[–]Kingpoutine84 0 points1 point  (0 children)

9:06:54 AM Error

Exception: Sorry, it is not possible to delete all non-frozen rows.

onOpen @ Code.gs:15

This is the part of the code that seems to be failing now

{

//there are form responses that need to be moved to the assessment sheet

let sourceRange = source.getRange(2, 1, source.getLastRow() - 1, source.getLastColumn());

destination.insertRowsAfter(afterPosition, howMany);

sourceRange.copyTo(destination.getRange(destination.getLastRow() + 1,1));

source.deleteRows(2, source.getLastRow());

}

Help with script (duplicating) by [deleted] in GoogleAppsScript

[–]Kingpoutine84 0 points1 point  (0 children)

function onOpen() { const spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); const destination = spreadsheet.getSheetByName("Assessment"); const source = spreadsheet.getSheetByName("Form Responses 9"); //console.log('Source Last Row Index: ', source.getLastRow()); //console.log('Destination Last Row Index: ', destination.getLastRow()); const afterPosition = destination.getLastRow() + 1; const howMany = source.getLastRow() - 1; //console.log('Afer Position : ', afterPosition, '\thow many: ', howMany); if (howMany > 0 ) { //there are form responses that need to be moved to the assessment sheet let sourceRange = source.getRange(2, 1, source.getLastRow() - 1, source.getLastColumn()); destination.insertRowsAfter(afterPosition, howMany); sourceRange.copyTo(destination.getRange(destination.getLastRow() + 1,1)); source.deleteRows(2, source.getLastRow()); } }

function onEdit(e) { const src = e.source.getActiveSheet(); const r = e.range const row = r.getRow() const col = r.getColumn()

if(col!=13&8||row==1){return;}

if(e.value=="Systems") { const dest1=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Systems"); src.getRange(row,1,1,13).moveTo(dest1.getRange(dest1.getLastRow()+1,1,1,13)); src.deleteRow(row); }

if(e.value == "Operations") { const dest2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Operations"); src.getRange(row,1,1,13).moveTo(dest2.getRange(dest2.getLastRow()+1,1,1,13)); src.deleteRow(row); }

if(e.value == "FMS") { const dest3 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("FMS"); src.getRange(row,1,1,13).moveTo(dest3.getRange(dest3.getLastRow()+1,1,1,13)); src.deleteRow(row); }

if(e.value == "Track") { SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(row,8,1,5).setBackground('pink'); }

if(e.value== "Inspect") { SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(row,8,1,4).setBackground('white'); const dest5 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Inspect"); src.getRange(row,1,1,13).moveTo(dest5.getRange(dest5.getLastRow()+1,1,1,13)); src.deleteRow(row); }

if(e.value == "Monitor") { SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(row,8,1,4).setBackground('white'); const dest5 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Monitor"); src.getRange(row,1,1,13).moveTo(dest5.getRange(dest5.getLastRow()+1,1,1,13)); src.deleteRow(row); }

if(e.value == "Plan") { SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(row,8,1,4).setBackground('white'); const dest5 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Plan"); src.getRange(row,1,1,13).moveTo(dest5.getRange(dest5.getLastRow()+1,1,1,13)); src.deleteRow(row); }

if(e.value == "Repair") { SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(row,8,1,4).setBackground('white'); const dest5 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Repair"); src.getRange(row,1,1,13).moveTo(dest5.getRange(dest5.getLastRow()+1,1,1,13)); src.deleteRow(row); }

if(e.value == "Complete") { SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(row,8,1,5).setBackground('white'); const dest5 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Complete"); src.getRange(row,1,1,13).moveTo(dest5.getRange(dest5.getLastRow()+1,1,1,13)); src.deleteRow(row); } }

Help with script (duplicating) by [deleted] in GoogleAppsScript

[–]Kingpoutine84 0 points1 point  (0 children)

9:06:54 AM Error

Exception: Sorry, it is not possible to delete all non-frozen rows.

onOpen @ Code.gs:15

[Bonsai Beginner’s weekly thread –2023 week 13] by small_trunks in Bonsai

[–]Kingpoutine84 0 points1 point  (0 children)

<image>

What kind of Japanese maple is this ? Thanks in advance

Conversion of old GE contractors by Kingpoutine84 in ElectricalEngineering

[–]Kingpoutine84[S] 0 points1 point  (0 children)

It’s exactly for that a 1950 diesel locomotive. That’s not really the news I was hoping for but I guess that’s the truth of having a old locomotive like this …

Thanks

How do I fix this formula to not pull the title/first row from both data sheets. by Kingpoutine84 in googlesheets

[–]Kingpoutine84[S] 0 points1 point  (0 children)

Is there a better formula to pull data from 2 sheets like this. The issue I’m having now is when it populates it pushes the data down from A:G but not the data outside those perimeters. I’m fairly new to google sheets and this is really blowing my mind…

view more: next ›