I assume you’re only interested in ways to programmatically assign a unique ID before the user fills out your form. No, Google Forms still has no direct support for hidden fields such as you have in HTML Forms. Your only option appears to be the custom styling route, which you’re already aware of. Here are … Read more
As far as I know, this type of client side event does not exist in Google Forms. The scripting mechanisms of Google Apps Script are designed for creating forms and other documents, but do not reach very far for client-side functionality. What I suggest is that you split the form into multiple pages and use … Read more
You should search this forum before posting questions; I did search on email+cell and got a few results : For example, this post answer does almost exactly what you want to do. EDIT following your edit : use an IF condition. Something like this : var cellG = ” if(cell.indexOf(‘D’)!=-1){ // = if you edit … Read more
Actually it’s even easier than that. Files are already Blobs (anything that has getBlob() can be passed in to any function that expects Blobs). So the code looks like this: var folder = DocsList.getFolder(‘path/to/folder’); folder.createFile(Utilities.zip(folder.getFiles(), ‘newFiles.zip’)); Additionally, it won’t work if you have multiple files with the same name in the Folder… Google Drive folders … Read more
With the introduction of document-bound scripts, it’s now possible to make a text highlighting function that’s invoked from a custom menu. Surely THIS is the best answer now! 8^) This script was modified from the one in this answer, and may be called from the UI (with no parameters) or a script. /** * Find … Read more
This will recurse through the folder writing them into a spreadsheet. var level=0; function getFnF(folder) { var folder= folder || DriveApp.getRootFolder(); var ss=SpreadsheetApp.getActive(); var sh=ss.getSheetByName(‘FilesAndFolders’) var files=folder.getFiles(); while(files.hasNext()) { var file=files.next(); var firg=sh.getRange(sh.getLastRow() + 1,level + 1); firg.setValue(Utilities.formatString(‘File: %s’, file.getName())); } var subfolders=folder.getFolders() while(subfolders.hasNext()) { var subfolder=subfolders.next(); var forg=sh.getRange(sh.getLastRow() + 1,level + 1); forg.setValue(Utilities.formatString(‘Fldr: %s’, … Read more
Google Apps Script apply changes made on Google Sheet in batches: Scripts commonly need to read in data from a spreadsheet, perform calculations, and then write out the results of the data to a spreadsheet. Google Apps Script already has some built-in optimization, such as using look-ahead caching to retrieve what a script is likely … Read more
You want to create the converted Google Spreadsheet files to “FolderB”. You want to delete the XLSX files in “FolderA” after the files were converted. You want to achieve above using Google Apps Script. If my understanding correct, how about this modification? In this modification, I modified your script. Modification points: You can directly create … 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