Read Understanding Triggers. This function is an Installable Trigger, so you need to set it up to run when a form is submitted. It’s easy – I would have thought a Forms tutorial would have walked through it. In the Script Editor: Choose Edit > Current project’s triggers. You see a panel with the message … Read more
If we make a copy of the file and trash the original, it would change the file URL and also the file sharing settings won’t be preserved. In Drive, it is possible to add a file to multiple folders with the .addFolder() method of DriveApp service. You can add the file to the target folder … Read more
I can suggest a simple solution without using a script !! Lets say you want to delete rows with empty text in column C. Sort the data (Data Menu -> Sort sheet by column C, A->Z) in the sheet w.r.t column C, so all your empty text rows will be available together. Just select those … Read more
Similar answer to caligari’s answer, but we can tidy it up by just specifying the full column range: =INDEX(G2:G, COUNT(G2:G))
If you’re trying to recursively iterate on a folder and want to use continuation tokens (as is probably required for large folders), you’ll need a data structure that can store multiple sets of continuation tokens. Both for files and folders, but also for each folder in the current hierarchy. The simplest data structure would be … Read more
One way you could accomplish this is by adding a script to both spreadsheets that copies it’s contents to the other spreadsheet on a change trigger. For example if you were to add something like the below to both spreadsheets, swapping the source and destination information around. var sourceSpreadsheetID = “ID HERE”; var sourceWorksheetName = … Read more
It looks like @Christiaan Westerbeek’s answer is spot on but its been a year now since his post and I think there needs to be a bit of a modification in the script he has given above. var url = file.exportLinks[MimeType.MICROSOFT_EXCEL]; There is something wrong with this line of code, maybe that exportLinks has now … Read more
I believe we can achieve your second objective without too much difficulty and modify the form, based on the current state of response. The approach is to Create the form and associate it with a response spreadsheet In that response spreadsheet, create a script with a function (updateForm for instance) Bind that function with the … Read more
In either a “stand alone” or bound Apps Script file add a doGet(e) function. Publish the Apps Script file as a Web App. Get the published URL of the Web App. Add a search string parameter to the end of the URL. You can add search string parameters to the URL of the published Wep … Read more
Have you looked here: https://developers.google.com/apps-script/reference/spreadsheet/sheet#copyTo(Spreadsheet) copyTo(spreadsheet) Copies the sheet to another spreadsheet. The destination spreadsheet can be the source. The new spreadsheet will have the name “Copy of [original spreadsheet name]”. var source = SpreadsheetApp.getActiveSpreadsheet(); var sheet = source.getSheets()[0]; var destination = SpreadsheetApp.openById(“ID_GOES HERE”); sheet.copyTo(destination);