six years later, this is so helpful thank you so much!
@MARKJOSEPHVISTA2 ай бұрын
Thanks
@stephaniekwofriedl70764 ай бұрын
Thank you Carl!
@ImeeSabales4 ай бұрын
Thank you
@avidlyviewed4 ай бұрын
does this work on Mac? Reason I am asking, is I dont see the indent property on Mac version. Thank you for solving this nerve wrqcking problem.
@carlarrowsmith8114 ай бұрын
You may need to turn on the ruler in the view menu. Should not be any different on a Mac.
@tsvetentse5 ай бұрын
Oh my god!!!! This is absolutely amazing dude, thank you SO SO MUCH for sharing this with us. I can't believe how lucky I am to have found your video 🙏
@valostudent60746 ай бұрын
saved me from going insane
@RyukiTheDragonSlayerOfficialYT8 ай бұрын
Thank you! This is all I needed to know!
@elgallokriki21058 ай бұрын
The others have already said this, but THANK YOU SO MUCH, really
@lqs_esl8 ай бұрын
but if my doc is in another language, Romanian, can i set it somewhere?
@TK22368 ай бұрын
Thank you kindly my good Sir! I salute you! o7
@brendabushouse99478 ай бұрын
There is no sound to hear what is being said. I had my volume all the way up and still couldn't hear it.
@carlarrowsmith8118 ай бұрын
SOrry hadn't realised the volume wa so low, I'll delete this as it's unhelpful
@raydan60719 ай бұрын
Hey ! Unless I'm mistaken, I didn't see it mentionned so I ask the question - is there any way to cross analyse answers from an anonymous survey ? I guess not, I was wondering if google forms had an option to see what answers were correlated even if we couldn't access the identities...
@carlarrowsmith8119 ай бұрын
anonymous survey or one where you have the email addresses, it makes no difference to the analysis. To have correlated information you'd need to ask the questions in the form to correlate against, usually age, generder, experience, job type etc.
@BrittneyQuinones-b2u10 ай бұрын
incredibleeee!!! Thank you for saving me so much time <3
@NeilSpiegel10 ай бұрын
Very Cool. Can this be setup to crawl a single google DOC and bring in all the linked files? Or can it work on a directory full of shortcuts?
@carlarrowsmith81110 ай бұрын
Alas shortcuts were made after this script and won't work. It's not designed to do the inside of documents just folders I'm afraid
@htuazon7810 ай бұрын
amazing. been looking for this. straight to the point
@ondda211 ай бұрын
thank you, FCK gmail
@RandomImpluses11 ай бұрын
I'm getting an "Exception: Conversion from application/vnd.openxmlformats-officedocument.wordprocessingml.document to application/pdf failed." Error. Not sure what to do now
@pinefilms3141 Жыл бұрын
WOW LIFESAVER!!!
@ChineseNewYear2-19 Жыл бұрын
Thanks for sharing. What about gaps between top and bottom tables? How to close the gap?
@carlarrowsmith811 Жыл бұрын
The height of cells is usually too much if a height of a cell or row is set. Remove any height measurement and it'll space to the contents.
@stationaryobsessive Жыл бұрын
THANK YOU!
@jimreily7538 Жыл бұрын
Thank you, a concise and accurate video, you helped me find what I was looking for
@karefyhn548 Жыл бұрын
Something to note: This doesnt work with shortcuts, only the actual place that the google doc is stored :) Brilliant script!
@frikiaallout2300 Жыл бұрын
Thank you, you saved my day :)🤛
@ayeshasworld2268 Жыл бұрын
old version, need support for latest version
@carlarrowsmith811 Жыл бұрын
Unfortunately they change from version to version. It'll be there just under a different menu
@DiscordApps-z2k Жыл бұрын
you saved my fucking life. Thank you
@rohananil1266 Жыл бұрын
Saved me a lotta work. Thanks mate
@jackgaleras Жыл бұрын
Veo en los comentarios que la gente trata de convertir un Word de Microsoft directamente.. este Script requiere que sea importado a archivo de Google para que funcione...Tener en cuenta que normalmente cuando descargar un documento de Google se convierte a docx de Microsoft o al formato de Excel o al de Power Point..
@jackgaleras Жыл бұрын
Mil gracias .. funciona!
@Sarah_Lake Жыл бұрын
I love this! It has saved me so much time! Is there a way to set the size and orientation of the pdf? Hoping to PDF at 11x17 and Landscape.
@jvoidhuey3088 Жыл бұрын
Doesn't work with folder of jpg's! wtf?!
@MartialGlobe Жыл бұрын
quick, simple & easy, thanks for this straight to the point tutorial
@salma_CodeGalxy Жыл бұрын
Sadly, i got this exception Exception: Conversion from application/vnd.openxmlformats-officedocument.wordprocessingml.document to application/pdf failed.
@SherrieCourtney Жыл бұрын
I am getting an Exception: invalid argument:ID - any ideas on what to do?
@SherrieCourtney Жыл бұрын
actually sorted - may need the slash at the end, and also rookie mistake - was not using the actual URL of the google folders
@carlarrowsmith811 Жыл бұрын
@@SherrieCourtney Glad you got it sorted. No slash needed but need to be careful with the ID and not leave any blank spaces either.
@charlesalexander2406 Жыл бұрын
Can I change the Naming of the new file here: new_file = source_file.makeCopy(source_file.getName() + " - " + newsheet_firstname + " " + newsheet_surname + " - " + student_id, dest_folder); I am just interested in changing the order of the naming... with the first name being at the beginning of the new file name. Thanks!
@charlesalexander2406 Жыл бұрын
What should that line look like?
@carlarrowsmith811 Жыл бұрын
Yes that's the line to change. Just move source_file.getName() to later in the line.
@charlesalexander2406 Жыл бұрын
@@carlarrowsmith811 Sorry to keep bothering you with this... and Thank you again:) But when I change it to this: new_file = source_file.makeCopy(newsheet_firstname + " " + source_file.getName() + newsheet_surname + student_id, dest_folder); It gives me this error : 2:14:52 PM Error Exception: Cannot call SpreadsheetApp.getUi() from this context. onOpen @ Code.gs:2
@charlesalexander2406 Жыл бұрын
I am getting an error - Exception: Cannot use this operation on a shared drive item. - It will create one version of the file in the correct folder. then errors... I am the owner of the "MY drive" where the file is stored and (not a shared drive) and the destination folder is a Shared drive folder where I am the owner of that folder. What can I do? Thanks in advance!
@carlarrowsmith811 Жыл бұрын
Hi Charles. Shared drives don't have the same ownership as the My Drive. There is no ownership, just access by the people that are allowed in the shared drive. You could create in your my drive and then copy over.
@charlesalexander2406 Жыл бұрын
@@carlarrowsmith811 So both the destination and the original file should be in a "My Drive" folder?
@charlesalexander2406 Жыл бұрын
I tried it again and still only getting one version created in the folder then getting this error: Exception: Invalid argument: permission.value
@charlesalexander2406 Жыл бұрын
Both the destination folder and the original file are both in My Drive folders.
@charlesalexander2406 Жыл бұрын
@@carlarrowsmith811 Got it to work!
@BrownMonkey21 Жыл бұрын
sir you helped me so much. im struggling dealing with this thing for about 30 minute. god bless you
@BrownMonkey21 Жыл бұрын
im subcribing!
@LordTchernobog Жыл бұрын
Thanks, this was pretty helpful!
@george57l Жыл бұрын
Thanks - great tip.
@meganrice7296 Жыл бұрын
This looks awesome, but I keep getting this error: Exception: Unexpected error while getting the method or property getBlob on object DriveApp.File.
@diagnostikaorganisasi3896 Жыл бұрын
Thank u very much Carl. This is really help me alot. However, sometimes the alert ReferenceError: Drive is not defined. Whats wrong?
@carlarrowsmith811 Жыл бұрын
It could be that you don't have edit access to the folder, the folder might be on a shared drive or the ID for the folder is incorrect. Had to tell without seeing the particular scenario.
@cinsicky6811 Жыл бұрын
Awesome!! This is the most straightforward google form pivot table tutorial I am looking for!
@petebrag2 жыл бұрын
if only all help videos were this short and to the point!
@nitishbannur11452 жыл бұрын
Very Very helpful, thanks so much!
@spritesheets2 жыл бұрын
Thank you!
@nawalsingh29852 жыл бұрын
Hi, In use default voice , I am not able to see any voice .. what should I do?
@wisdom-for-life2 жыл бұрын
You the real MVP! Short and sweet. Thanks!
@danielcooney18402 жыл бұрын
Nice vid, thank you
@kaleighwoodard32682 жыл бұрын
If you click and drag over your photo in Gmail to highlight it in blue before adding your link (as opposed to just clicking the photo), that will solve your problem.
@carlarrowsmith811 Жыл бұрын
Doesn't work for just an image, it applies a link of the picture itself. If you select more than the image it will work but then the spaces either side will become a link too.