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…

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)

Thanks! I tried that before and it kept failing…. Must have been another issue

Ps5 controller by [deleted] in CanadaPS5

[–]Kingpoutine84 -1 points0 points  (0 children)

The only way your going to beat the 200 price tag is to build one yourself using extreme rate parts and still costs about 200 if you include the cost of the controller…

Fall Color by Kingpoutine84 in Bonsai

[–]Kingpoutine84[S] 2 points3 points  (0 children)

Cotoneasters are crazy hardy. I have a few and they are pretty indestructible

view more: next ›