After import - Need to delete columns on all sheets

13 views

Skip to first unread message

Nicole H

unread,

Sep 8, 2021, 7:54:59 AM9/8/21

to Google Apps Script Community

Once the import runs it's adding Columns L:O which I would need to manually delete on each sheet.

It adds Lunch 2(L), L2 Return(M), Break 3(N), B3 Return(O)

I can't find inside this import code where it's adding these on. I don't know if it can be removed or to add to the script for it to remove those columns after import happens?

function onOpen() {

var ui = SpreadsheetApp.getUi();

ui.createMenu('Break Aid Functions')

.addItem('Step 1. Authorize Google Account','SetMe')

.addItem('Step 2. Import WFC Google Sheet','showPicker')

.addItem('Step 3. Set breaks for entire schedule','SetBreakShifts')

//.addItem('Step 4. (Optional) Reassign All 6 hour shifts','ResetSixHourShift')

.addItem('(Optional) Set Breaks for Individual EE','ManualAdjOneEE')

//.addItem("Set Time to Time Zone", "insertTime")

//.addSubMenu(ui.createMenu('Triggers')

//.addItem('Create','createOnEditTrigger')

//.addItem('Remove','removeOnEditTrigger'))

.addToUi();

removeOnEditTrigger();

////<body onload='getOAuthToken()'>

}

function SetMe(){

Browser.msgBox("Authorization has already been completed.\\n "+

"Continue to Step 2 (Import WFC Google Sheet).",Browser.Buttons.OK);

}

function showPicker() {

var html = HtmlService.createHtmlOutputFromFile('Picker.html')

.setWidth(800)

.setHeight(600)

// .setSandboxMode(HtmlService.SandboxMode.IFRAME);

SpreadsheetApp.getUi().showModelessDialog(html,"File Selection")

}

//Passes Permissions from Google Drive into the script. So we know what drive to open and asks for access to all the files.

function getOAuthToken() {

DriveApp.getRootFolder();

return ScriptApp.getOAuthToken();

}

function me () {

var s ="12XI_IqgXhmr_MPx-y2WaG2IBcJrCCE8nzoaTviXZpbk"

var imp ="1_h9PTh7cpNajxE6ULNnxTzlrgAYx84LZSgWN1RCbxCM"

var imp1 ="1s-CjmsivIxCiv36jb4TV_vdil1Kacmk4rAfs8gIlVW0"

var imp2="18nEodq45LsrBG54WVr1UbnSsKbtZWh4-fvhRD8zNNsQ"

var imp3="1w9c9mnHI8pDslvDcuUxcPt0Jok_a4qwL_CwhwRd1I3o"

var imp4= "1pOO99991oV7nbPBYpMyFmDlGimM-UToyrWF7UKHEwWg" // 11/11 Fresno

var imp5="1PeDNyidUAhy9Vgu-fmAK_M3L1Wut5a_vXTpBMS-yMrM" //11/10 Fresno

var imp6="1FccWNRsMxQGpOrbnQhSMq3wxCmaZKeXpScxzDiRLb4g" // 11/10 Glendale

var imp7="1bYSPiY6ImMb2mGjrs5byInV3KlSnLsotFSzWIxzIo-o" //11/09 Fresno

var imp8='1YunTq2R_sMr99z12FgVGimC-SaASYpOO-BqqCDsQLDs'// 11/11 Glendale

var imp9="18GlwEcgNzzsO-SWDOLitUaFMgeYNkcPMyR7xcOFJ968" // 11/12 Glendale

var imp10="1ZipXBF0IHJsGGCmgROZXeygjC0mNBEwe_r70eLjz8pA" // 11/13 Fresno

var imp11="1XAaAjTT35-dPRG5iCeqR_4PS1eOrB79IkeRt-Hi4hvA" // 11/13 Glendale

var imp12="1SAQ9-TjR94NE5EXJtIXlLTxieUNcsG2WtgJoy6s-k6o" //04/07 Union Beltsville, MD (EC)

var imp13="1UqTluB9TxE4_3S1XRTnCpmpPLfyH7xX16A6UDxmTM1c"// 04/07 Union 483 - San Diego, CA (WC)

var imp14="1eh8lEbMPxovTIkvwJ_PtfWD8exxOzNrozcRJuYxktyk" //04/07 Union 464 - Sacramento, CA (WC)

var imp15="1AK8GEj5OhdltpT1O0PIMSnulcOdHJpwzuI6avtek8ik" //05/20 Union 464 - Sacramento, CA (WC)

var imp16="1tt_SSNCZULNA6B8kkVWqbRUJ7LoU__oBG64uVAYnN0w" //05/14 Union 464 - Sacramento, CA (WC)

var imp17="12sMwFzYW_1fv-VR3j7JrYRgUJPy0zE3wXvkBmSkEnVQ"

var imp18="157sWDQti6HaaB2JY7WMoy8QoaxWVx92o7dPYFpAsacc"

importWFC(imp18);

*/ 11, 16

SetThisSpreadSheet();

//SetBreakShifts();

//insertTime();

//var b = 5.00536

//var c = b.Round(3);

//console.log({message: b})

//user = user.getgivenName()

}

function createOnEditTrigger() {

ScriptApp.newTrigger('MOnEdit')

.forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())

.onEdit()

.create();

}

function removeOnEditTrigger() {

var bfound=false;

var r= ScriptApp.getProjectTriggers();

for (var i = 0; i < r.length; i++) {

if(r[i].getHandlerFunction()=="MOnEdit"){

ScriptApp.deleteTrigger(r[i]);

}

Clark Lind

unread,

Sep 8, 2021, 8:53:58 AM9/8/21

to Google Apps Script Community

Are the extra columns in the sheet you are importing? It looks like a file picker is opened for a file to be selected. So I assume there is also a javascript file that the Picker.html file may be referencing. Or there are other xxx.gs files in the project.

Examine the Picker.html file for any templated calls back to apps script like: <?!= something ?>, or references to other files that may contain the code: <?!= HtmlService.createHtmlOutputFromFile('JavaScript').getContent(); ?>, or