Questions tagged as 'google-apps-script'

Tagged questions
1
answer

onEdit several sheets

How do I make the onEdit function work independently on different sheets? You will see I made this script that works perfectly on the active sheet (Col Y). I have 8 sheets (different names) in which when modifying a specific column I stamp the d...
asked by 30.05.2018 / 17:12
1
answer

Form answers

I have made a form in Google but I need the url of the individual response of the form as it is sent to be stored in a specific column in order to consult it later or send the link by email. . I can not use add-ons. I tried to mount a script...
asked by 20.05.2018 / 15:47
1
answer

How to copy data from the answer sheet of the form to another spreadsheet or additional send the answers directly to another spreadsheet

Good morning, I hope someone can help me with my doubt, I'm new to this from Google spreadsheets and I start to automate some things. I have a script that validates the answers of a form, my problem is that I have not been able to copy data from...
asked by 26.03.2018 / 18:19
1
answer

Capture data in Spreadsheet using button onclick and redirect to another page with button onclick "Appscript"

I am currently trying to capture information in a spreadsheet with button onclick but it has not been possible to generate the following error:    Uncaught ReferenceError: is not defined at HTMLButtonElement.onclick Addition...
asked by 02.03.2018 / 14:25
0
answers

Get CSV in ZIP from a site with Basic Auth using Google Apps Script (google sheets)

I'm trying to get a csv that is zipped in a url, which needs basic auth. I can not achieve it, since it throws a syntax error in the argument of the variable 'files'. This is what I tried: function importdatastreamcsv() { var user = 'user';...
asked by 17.11.2017 / 10:45
1
answer

error when activating a script with formsubmit

The following is the email I received when I failed to complete the form for the first time. Your script, Query and Procedures Form, has not been executed correctly. Here is a summary of the errors. To configure the triggers for the script or...
asked by 18.10.2017 / 18:12
1
answer

Trigger - Activator or Edit file without permission (no form) Google Script [duplicate]

I created a panel using doGet (HTML panel), linked to a spreadsheet. It adds data to the spreadsheet, and also extracts data from it when selecting from a drop-down list the name of people. The drawback I have is that I must give people per...
asked by 05.08.2017 / 17:24
1
answer

The installable trigger is not created using "ScriptApp.newTrigger"

I have created two scripts in Google Apps Script for the same purpose in standalone , in order to create a trigger Installable in a spreadsheet, but after executing the code, I can not see the trigger in the code editor interface of the...
asked by 18.05.2017 / 21:47
1
answer

Google Drive picker does not load

Yesterday there were intermittences with the Drive Picker API, I found a post that suggested changing the path of the script but both do not work, when wanting to invoke the picker it does not load <script type="text/javascript" src="https:...
asked by 07.04.2017 / 19:53
3
answers

Instruction DriveApp.searchfiles

In Google App Script I am doing an algorithm that consists in searching a file in the google drive and recording its URL for future use. To find the file I use the following sequence of instructions: var files = DriveApp.searchFiles('title con...
asked by 13.09.2017 / 02:17