Good simple tutorial, thanks

suppose you made your original as a powerpoint presentation, it does happen, you know added the autodate to it already, and then converted it to slides, would the autodate operate in slides?

The sheets file is on the website. He stated this in the first few seconds of the video.

Great formulas! I have a very similar sheet and was wondering if you had any advice on how to also calculate tardies with the timestamp?

hello. do you have the formula posted anywhere? Cant read on the screen

Can you emulate a Subtotal function using query function?

What App Script do I change to allow for check-in and check-out from devices like cell phones or laptop. When checking in/out by other users but me (the owner of the spreadsheet), it does not show time out or in. It only shows the name. The time does not populate in. What am I doing wrong?

Excellent! Thank you!

Thank you, I was at a loss until I found this video.

I loved it. Congrats.

Thank you, very useful indeed!

Thanks dude, there is tutorial validation ID number (have 5000 row unique ID number) on input google form? if they input ID number (correct), can input google form. Sorry my english bad.

I have a question. How can I do it with other pages for example 'sheet6' 'sheet7' 'shee8' in the same cell and column. col1 ('A2') for all the pages? by the way your videos are awesome. congratulations

very nicely done and explained perfectly - thank you very much and the best of luck with your excellent channel

Hola te sigo mucho y re agradezco todo lo que haces por la educación. Ojalá pudiera trabajar con usted pero vivo en Venezuela asi que como supondrá no hay recursos. Sin embargo agradezco cada video suyo éxito.

Thanks a lot for esiar way.

This is awesome. Thank you!

Hello, thank you so much for your perfect guide! I have a question, if you can help me. In my form, each answer of the multiple choice item has a "go to section" information, that is going to be lost after the form is updated. Is it possible to implement the script, by updating also the "go to section" information together with the anwers? For example "go to section" information could be stored near "Form List" column. Thank you in advance!

another superb tutorial - thanks very much - I follow you avidly 🙏 some feedback - not sure what happend to the video resolution on this.

Great Tutorial. I'm getting a "document is inaccessible" error on this line: const copiedDocument = DocumentApp.openById(documentCopy.getId()); Any ideas? Thanks

This didn't work. The copy and Paste onto google slides. Is there a script in the Google slides? Also I don't see a link to the spreadsheet.

Hello! Would it be possible to have the ID code show at the end of the form after the submission of the form? Thank you!

I solved the error "Exceeded maximum execution time" by this code and over 4000 files in folder listed in 1s function onOpen() { var SS = SpreadsheetApp.getActiveSpreadsheet(); var ui = SpreadsheetApp.getUi(); ui.createMenu('List Files/Folders') .addItem('List All Files and Folders', 'getListFilesandFolders') .addToUi(); }; function getListFilesandFolders(){ Logger.log("getListFilesandFolders function started"); var folderId = Browser.inputBox('Enter folder ID', Browser.Buttons.OK_CANCEL); Logger.log("Folder ID entered: " + folderId); if (folderId === "") { Browser.msgBox('Folder ID is invalid'); return; } makeListFilesAndFolders(folderId, true); } function makeListFilesAndFolders(folderId, listAll) { Logger.log("makeListFilesAndFolders function started"); const sh = SpreadsheetApp.getActiveSheet(); const range = sh.getRange('A2:H'); range.clear(); sh.appendRow(["parent", "folder", "name", "date created", "date updated", "owner", "URL", "ID"]); try { const parentFolder = DriveApp.getFolderById(folderId); Logger.log("Parent Folder ID: " + folderId); Logger.log("Parent Folder Name: " + parentFolder.getName()); listFilesAndFolders(parentFolder, parentFolder.getName(), 0); } catch (e) { Logger.log("Error in makeListFilesAndFolders: " + e.toString()); } } function listFilesAndFolders(folder, parent, depth) { const sh = SpreadsheetApp.getActiveSheet(); const data = []; const files = folder.getFiles(); while (files.hasNext()) { const file = files.next(); data.push([parent, folder.getName(), file.getName(), file.getDateCreated(), file.getLastUpdated(), file.getOwner().getEmail(), file.getUrl(), file.getId()]); } if (data.length > 0) { sh.getRange(sh.getLastRow() + 1, 1, data.length, data[0].length).setValues(data); } if (depth < 3) { // Limit recursion depth to 3 levels const subFolders = folder.getFolders(); while (subFolders.hasNext()) { const subFolder = subFolders.next(); listFilesAndFolders(subFolder, parent + "|" + subFolder.getName(), depth + 1); } } }

If I have a folder with many sheets, can I do this? Just textformat for 2 columns

Can you make a tutorial on how to format multiple sheet files in a folder? For example, columns B-C will be Plain-text instead of automatic

Thank you! This is exactly what I was looking for. Keep up the good work!

Working well for me. Thank you!

Exactly what I was looking to do (less the formatting which was just some unexpected icing on the cake!) Thanks, excellent explanation!

Hi! Thanks for sharing! What if I have multiple email addresses, and I’d want the email sent when a cell or column contains a specific text?

May I ask for a template?

thank you? does it work is shared drive?

You seem super knowledgeable about this topic. I need some help...We are trying to collect information on each student every day whether or not they took and ate a school breakfast and/or lunch. I created 23 different teacher forms in which the data is being dropped into a single spreadsheet. I'm using COUNTIFS to tally. The problem I'm having is that the form is not calculating in real-time or my formulas are incorrect because I'm new at this. I was wondering if you'd be able to help me?

very good script

I tried the script and it also works on shared folders. But I have a problem due to the large number of files in the folders - about 6 minutes after startup, a notification about the maximum time exceeded appears. Is it possible to amend the script so that on restart it continues where it left off in the previous attempt?

Hey there, do you need to be the owner of the folder for the script to work? Thanks!

Hello. How can this script be extended to rename files in the newly created folder? For instance to get a name structure like <student name> + <file name> Thanks.

Thanks so much - This solved an issue for me

can we do this on a third party g drive link shared with us thanks in advance

I am trying to script using your "Use Apps Script to send a Form email to different email addresses based on a form question" video. in the for loop, I get a undefined "values" error. Does a person enter this App Scripts EXACTLY as you have it? I am new to this.

Thanks

Thank you for the video. You explained it brilliantly.

I was expecting something more complex, but your simple script was the answer to my problem. Nice Job!

thank you so much, you saved me hours of time adding links to my flie names in excel 🙏

Amazing

thank you for this tutorial. How would I change the App Script to Central Standard Time?

Oho, this is great. I had my own slot machine sheet, but it wasn't nearly as complicated (it was just the RANDBETWEEN stuff with none of the actual calculations if one got a match), and I was wondering if anyone else had made anything better I could pull from. It looks like someone did! Thanks for this.

Exactly what I was looking for 👏

Thanks a lot sir I have been searching solution of this problem since 6 months now it solved thanks again

Stumbled upon your channel just now and this was exactly what I needed for a current project, thanks. One great thing to note about your method is that it allows the creation of a "print" button without invoking sensitive scopes for people using the file without knowledge of the author or the script.

Very nice - I love your style of presentation and the flow is well paced and clear. Congratulations and thank you. PS - looking forward to an update that will merge the Date as a Date (without time etc)