Unfortunately this is not currently possible with Google Apps Script and Google Forms. Apps Script can be triggered by the submission of a Form, but it cannot interact with the Form in the users browser. It is possible to build a form entirely in Apps Script (using HTML) which would allow you full control over … Read more
[edit to address updates in Google Docs] This currently not possible. You can know if a cell is merged by looking calling getColSpan and getRowSpan but there are no setter methods. Please star the following issue to be notified by updates regarding this. The merge function you found is not specific to table cells, it … Read more
Required reading: ScriptApp#getOauthToken Blogger §post#insert UrlFetchApp#fetch Editing manifest#Setting explicit scopes Switch to standard GCP API Library Issue: Usage of asynchronous client side browser samples in the synchronous server side. Solution: It is possible to access Blogger api from Google apps script using UrlFetchApp Full OAuth flow can be bypassed using oauth token provided by ScriptApp … Read more
How about this workaround? In this workaround, Sheets API is used for copying a Spreadsheet. In the case of copy() of Class Spreadsheet, makeCopy() of Class File and Files: copy of Drive API, the copied spreadsheet includes the bound scripts and linked forms. So I thought to use Sheets API. The flow of this workaround … Read more
I’ve tried this myself, and reproduced your results, using Chrome on Windows Vista. The paren matching went Red with exactly 100 blank lines between the opening and closing braces. Steps to try, for the non-believers: In Drive / Docs, create a new script for a blank project. Start with the template for “myFunction()”. Place the … Read more
Okay looks like I found an answer, via REST API I can update file’s parents. I’ve made that call and it’s working. Here’s the sample. var apiUrl = “https://www.googleapis.com/drive/v3/files/fileId?addParents=newFolderId&removeParents=oldFolderId&supportsTeamDrives=true”; var token = ScriptApp.getOAuthToken(); var header = {“Authorization”:”Bearer ” + token}; var options = { “method”:”PATCH”, “headers”: header }; var res = UrlFetchApp.fetch(apiUrl, options); UPDATE Using … Read more
After an answer on another recent post (Thomas van Latum), I tried the suggested doc api and get an interesting result… here is the test code I used and that is working nicely except the file is in xlsx format, not in xls but this is not necessarily an issue these days : function googleOAuth_(name,scope) … Read more
You can insert an image that looks like a button. Then attach a script to the image. INSERT menu Image You can insert any image. The image can be edited in the spreadsheet Image of a Button Assign a function name to an image:
Like Jonathon said, you’re comparing dates wrongly. But that’s not the main issue with your script nor what you asked. The main concept you’re getting wrong is that the continuation token can’t be saved before you do your loop. When you get the token, it saves where you were at that moment, if you continue … Read more
Step 1: Create Form Normal operating procedure – create your form either through a script or using the Forms UI. Capture the ID of the form. For instance, from the URL when in the editor: https://docs.google.com/forms/d/1-AWccGNgdJ7_5Isjer5K816UKNSaUPSlvlkY3dGJ1UQ/edit ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Attach a spreadsheet to capture responses. (We’re not going to do anything more with that here.) Step 2: … Read more