I feel like I should pay for watching this. Outstanding quality.
@sportyguy1
3 жыл бұрын
Agreed. I bought a book on this stuff and I always seem to get errors I can't fix. I love your authenticity, honesty, making mistakes. It's very human and incredibly good learning, from one teacher to another!
@helloscoopa
3 жыл бұрын
then donate on Patreon.
@MrJdorrington
2 жыл бұрын
Shhh! He might hear.
@ankitashastri4101
Жыл бұрын
just do it.. buy a thanks ..
@ighsight
3 жыл бұрын
What an incredibly lucid tutorial. When it comes to the best at explaining tech on KZitem, there is this guy and Bob Traversy, then everyone else.
@fernandobrito5316
4 жыл бұрын
I love You, I love the way you explain things, I love the amount of useful things you teach using Google Apps, I love How you release a video teaching exactly what I need to implement over here. I've been waiting so long for this video in particular. If, possible, you could make some videos about integrating Google Forms with Google Contacts.
@ExcelGoogleSheets
4 жыл бұрын
This might be a stupid question, but what does Google Contacts do?
@fernandobrito5316
4 жыл бұрын
@@ExcelGoogleSheets Create and update contacts on google platform. Like, What I want to do is to gather costumers info through a google forms, save this info in a spreadsheet and create a contact. If this contact has already been registered update it.
@Pilki
4 жыл бұрын
@@fernandobrito5316 @Learn Google Spreadsheets Yes! I was thinking the same thing watching this video. For me, as a self-employed guy, writing bills is a really tedious and I am implementing the technique in this video to automate bills via spreadsheets. It would be really awesome to learn about interconnectivity between google contacts and google spreadsheets. Like how to import in and export from sheets to contacts and vice versa. Why? The "autofill" function in gmail, or to give customers access to specifics sheets for example, only works, if you have the email adress saved in google contacts (afaik). PS: Thanks for your work - really appreciate it!!
@mwKanj
4 жыл бұрын
This is the video about integrating Google Forms with Google Contacts. kzitem.info/news/bejne/qol-p4B4kl-oaGk Thank you so much @Learn Google Spreadsheets for creating the video, and thanks for @ Fernando Brito for the idea.
@NetSkillNavigator
2 жыл бұрын
So gay .. 🤣
@josephlynch4532
4 жыл бұрын
My mind has just been blown. Thank you so much for the in-depth explanations. You have probably saved me months worth of work.
@ExcelGoogleSheets
4 жыл бұрын
Great to hear!
@openmindjustdoit1306
2 жыл бұрын
@@ExcelGoogleSheets Did you have Courses Online about app Script google sheet
@abnersangalang3849
3 ай бұрын
@@ExcelGoogleSheets hi, can i still use the removeFile method? cos it now says that this method is deprecated. thanks
@Rolroorlo
3 жыл бұрын
You are the best Teacher for Google Apps Script with Spreadsheets
@DjEdu28
3 жыл бұрын
Thank you so much! You've just freed me from third-party extensions, and made me more independent in creating certificates. Ps.: I'm #Brazilian and I used the automatic translator, sorry for the mistakes.
@OneDeed90
3 жыл бұрын
really love this channel now. feels like watching drama thriller series.
@adeep598
3 жыл бұрын
you are a saviour.. automated 70% of my department work from your channel
@zinalee2776
4 жыл бұрын
This is SO SO SO helpful! It's exactly what I needed to get things done for my new business, thanks so much--as a non-software language person, this broke everything down the way I needed to "get" it. I've subscribed and will be working my way through your videos, and hopefully will find a way to thank you that's remunerative, soon. Thanks so much again!
@kyle943
4 жыл бұрын
Could you take this a step further and show how to automatically send PDF file to a given email after it was submitted through google form?
@wagnerbarbosa1894
2 жыл бұрын
This is Wagner, speaking from Brasil. Simply amazing your videos! Thank you for taking your time teaching us!
@itamarnakar6698
3 жыл бұрын
If you have trouble with "MimeType.PDF" - replaced "tempFile.getAs(MimeType.PDF)" with "tempFile.getAs('application/pdf')" and it will work like a charm. Thanks for the great content!
@user-fq5vo9zs1q
3 жыл бұрын
for me it creates PDF from initial template doc file, not from copy with replaced data. any ideas?
@itamarnakar6698
3 жыл бұрын
@@user-fq5vo9zs1q Sounds like you have a bug somewhere around binding data. follow the tutorial correctly step by step and you will succeed
@user-fq5vo9zs1q
3 жыл бұрын
@@itamarnakar6698 thanks for reply. i see that another user here have the same problem. may be something in google script was changed?
@JinaneKarhani
2 жыл бұрын
@@user-fq5vo9zs1q it s working like a charm in the new script
@jedsantos9773
2 жыл бұрын
Would love to see a tutorial on printing out or exporting ranges to PDF or maybe image files, too. :) This would really be useful since there's currently no easy way to do this with code. Thank you so much for your great videos!
@tanveerhussain3881
3 жыл бұрын
World's No 1 Channel World's Best Teacher World's Best Quality Learn Easy and Understand I Love And Like All Video All Video Is Heart 💓 Touching
@mrzeidanmathclass
4 жыл бұрын
God bless you man. I think sometimes you read people's mind, this was a life savior video as it came out the right time we needed it to generate acceptance letters to email to students. Keep up the good work.
@ExcelGoogleSheets
4 жыл бұрын
Awesome!
@RoyStevenUngKengSoon
4 жыл бұрын
Great stuff! Everyone who uses Google Sheet/Excel should be on your channel!
@ExcelGoogleSheets
4 жыл бұрын
Thanks!
@richardnorris9256
26 күн бұрын
This guy is my frickin hero.
@DouglasThompson_Profile
3 жыл бұрын
Hello @learn Google Spreadsheets, I would suggest renaming this video to show it is different video from the other PDF video you created. So, this is more a 'Bulk' email AppScript, rather than 'onSubmit' form video. This will be better for users to find the correct information. Your videos are great. I implemented your solution without problems. The Google Permissions approval process has changed.
@christianheins1530
3 жыл бұрын
have you had trouble on line 10 const = tempfile = docFile.makeCopy(tempFolder); keeps returning docFile.maleCopy is not a function
@MrBawa85
4 жыл бұрын
Thanks for the informative video,it really helped me to get the automation i wanted to do from very long,i have no idea about java and any sort of scripting,but your explanation made it very easy to understand.big thanks
@arijitroy3436
4 жыл бұрын
You are a awesome teacher sir.
@First.Last.99
2 жыл бұрын
I used this tutorial and in 2h I made it to work without any problems, interface from google has changed a little bit here and there but it all works and its not hard to do and follow, THANK YOU!!!
@ExcelGoogleSheets
2 жыл бұрын
Unfortunately Google changes their interface so frequently that it's impossible to keep up.
@yoanngrange
2 жыл бұрын
You know that this is useful and needed so, I am just gonna say thank you. It saved me days and it will save days to a lot of people.
@elecsyslab3650
2 жыл бұрын
Absolutely amazing. Content, presentation, depth, to the point, spot on! Well done man!
@ExcelGoogleSheets
2 жыл бұрын
Much appreciated!
@raja2572
4 жыл бұрын
Awesome! Thanks for posting the video. Informative and educative. You explained very well.
@ExcelGoogleSheets
4 жыл бұрын
Glad you enjoyed it!
@jiteshkharbanda5955
3 жыл бұрын
Explained everything very well. Nice work👍🏻👍🏻
@pedroivanmedinareyes8662
3 жыл бұрын
Wow,,, super video,,, I going to practice. Thanks a Lot.
@patricioarguello4324
3 жыл бұрын
Gracias, @Learn Google Spreadsheets. Muy bueno el tutorial.
@alisaad8790
4 жыл бұрын
Very valuable content and clear explanations. Good job!
@ivanurbina2422
Жыл бұрын
This was an AWESOME tutorial, just what I was looking for. I subscribed for the next tutorial.
@roycerowan2587
2 жыл бұрын
Amazing. Exactly what I wanted to learn how to do. The last step that would be helpful is entering the url to the pdf in a column in the spreadsheet.
@elmodvz
2 жыл бұрын
Hi. Did you manage to find the solution?
@roycerowan2587
2 жыл бұрын
@@elmodvz No, but I have tried this yet either. Let me know if you figure it out though!
@javiermgeco
Жыл бұрын
Hi, many thanks for your teachings, very educative and over all step by step!
@frankcklin
2 жыл бұрын
This is a great demostration to do mail merge in Google Sheets without add-on. I learned from here and try to merge but hit the 6 mins execution time limit with maybe 60 recipients. Hopefully could see your solutions or ideas someday. Thanks!
@andreajaquelinearellanodia6250
4 жыл бұрын
Awesome! I've been looking for a video like this one, I am very grateful to you. Keep the good work!
@ExcelGoogleSheets
4 жыл бұрын
Glad you liked it!
@jgonrev
4 жыл бұрын
A magnificent class. Great!!
@dr.aspensen5090
3 жыл бұрын
This was exactly what I needed! You are a very good teacher. Thank you so much for this video. I have subscribed to your channel. :-)
@bangdoeltips7492
3 жыл бұрын
This is the most useful channel for me Love it very much Thank you for creating this channel
@ExcelGoogleSheets
3 жыл бұрын
Glad you enjoy it!
@DroidRaxx
4 жыл бұрын
Hey, your tutorials are amazing. Will you also please share the code which you write in the video. I have seen your website but there is nothing available regarding this code. :(
Just what I needed! And excellently presented! Thank you!
@johncherish7610
2 жыл бұрын
Awesome tutorial, also a great explanation of variables, loops, and error catching thanks a bunch
@vinaiv6969
4 жыл бұрын
May I ask a quick question. I am trying to export individual rows from a product catalog. The catalog has images stored in a cell. Is it possible to load that image into the template as well? I saw you using a different function to get the dollar symbol, so similarly does loading an image require a new function?
@Akaabouch
4 жыл бұрын
thanks for the valuable tutorials , a really loved this channel and the why you explain the things , very simple . I support to start learning JS separatly but here I found my self learning lot of things about JS and GS at the same time , really thank you very much I hope also that you make some videos about organizing many forms (custom form not google forms with bootstrap ) on google sites and link every thing with GD and GS thanks again
@nilecentre9552
3 жыл бұрын
I really love ur channel thank you very much for all your lessons, U R the best one thing in this lesson : When you Remove the temp file titeld "copy of template" from (Temp Folder) it goes to ROOT not to Trash i've added this Function between the original two functions: function trash() { var files = DriveApp.getFilesByName("Copy of template"); while (files.hasNext()) files.next().setTrashed(true); then added : trash(); in the end of the last function , after this line: tempFolder.removeFile(tempFile); It woorks fine But , now we have to empty the trash manually is their any wayTO EMPTY THE TRASH Automatically in the end of these scripts?
@ExcelGoogleSheets
3 жыл бұрын
You have to use advanced Drive API service to be able to delete without clearing the trash. You can't do it with regular Apps Script DriveApp service, at least not at the moment.
@SauliusBaublys
2 жыл бұрын
Thanks for this modification! Accidentally found bunch of template files in ROOT folder and didn't manage to find where they came from. I modified this script by my needs a lot, so thought that some of mine script lines creates duplicates of template in ROOT folder. I had no idea that these copies come from temp folder. Your solution works great. Thanks :)
@First.Last.99
2 жыл бұрын
This worked like a hot pie! thank you, I love it
@walterpaiva719
4 жыл бұрын
Really useful lesson here. Once again, thanks for the class!!!!!!!!!!!!!!!!
@linhpksw
2 жыл бұрын
I think we should use "tempFile.setTrashed(true)" instead of "tempFolder.removeFile(tempFile)" to remove totally temp file. Because it brings temp file directly to the Trash not outside the Temp Files.
@bobbogenie7235
Жыл бұрын
That worked better for me. thank you for the solution
@patra_amit
9 ай бұрын
Thank you so much it helps alot
@admintamilkart5813
2 жыл бұрын
very amazing and use full
@howiewang4238
3 жыл бұрын
very clear and informative. Thank you so much!
@ExcelGoogleSheets
3 жыл бұрын
Glad you enjoyed it!
@diatribes
Жыл бұрын
Nice one👍
@mustafahusain2966
3 жыл бұрын
Great
@haroldo_brito
4 жыл бұрын
nice, very nice, big very nice!!! thank you!
@JeanChristopheTaboada
4 жыл бұрын
Actually, you CAN chain .replace(). I've been using that a lot to generate bunches of customized "diplomas" for students, and it worked liket a treat. The only painful thing is to have to declare each and everyone of the placeholders. I'd rather do some sort of automatic find of the {} occurences and map them to the "fields" in the spreadsheet, but I'm not good enough to do that… Anyway, your video was the greatest I've ever found about that specific need. Thanks a ton !!
@ExcelGoogleSheets
4 жыл бұрын
Great!
@MohammedAbdulatef
3 жыл бұрын
Thank you so much. This is one of the best ever exist tutorials.
@vinaiv6969
4 жыл бұрын
Thank you so much for these tutorials. Absolutely amazing!!!
@talitouch
3 жыл бұрын
This was a great video! I've never used scripts before and was able to accomplish it. Do you have a video on how to make bulk Google Docs? I thought the PDF was the best option for my needs, but I think it would be great to know how to make Google Docs in Word format as well
@JinaneKarhani
2 жыл бұрын
Just download the google docs as word format :)
@dewaynewest7756
3 жыл бұрын
Your explanations are awesome man. Is there any way to add an image to the PDFs before we email them?
@user-qg9mf4zt5o
4 жыл бұрын
wonderful! especially liked the way the whole video went in a stepwise fashion, and often retrograde!!!
@rikasterling4468
3 жыл бұрын
Hi! This has been such a huge help for me. Thank you for your amazing tutorials. We receive applications at my organisation using Google Forms. From there the data gets saved into a sheet and I want to then save PDF summaries of those applications. Your tutorial has allowed me to achieve this. The one thing I would love to be able to do in addition to this would be to now allow for duplicate files. The way the code works now, it creates PDFs for all rows each time the script is run. I'd love to be able to run the script and only create new PDFs for new application responses without creating more and more of the same. Do you have any advice on how I can find out how to do that?
@mayash7604
2 жыл бұрын
Hello, I need to do this also
@nathanpolhemus1710
2 жыл бұрын
@@mayash7604 Hey, you would need to change the code that's getting all the rows to getting the last non-empty row. Then use the trigger tab to run the script every time a new row is added
@JinaneKarhani
2 жыл бұрын
@@nathanpolhemus1710 Can you show us how pls?
@cbsubs
3 жыл бұрын
Excellent tutorial. Question: since you use the script to create a new file and name it in drive, is there a way to create a link to the newly created file in a cell in the sheet?
@czarlieron271
2 жыл бұрын
I was looking for a way to do this as well.
@agentleads5880
3 жыл бұрын
Excellent video and its exactly what I need to do for my project!!!
@prabhakarang8107
2 жыл бұрын
Amazing tool. you made my task a lot more easier. Thanks a ton.
@danielvelasquez1851
4 жыл бұрын
Congratulations, the tutorial was very well explained, it guided me to create the functions that I needed in my script, now I ask you instead of creating bulk documents, how would I specifically create a single document? what would change in this formula? : function createBulkDocs(){ const docFile = DriveApp.getFileById("XXXXXXXXXXXXXXXXXXXX"); const tempFolder = DriveApp.getFolderById("XXXXXXXXXXXXXXXX"); const currentSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("sheet1"); const dato = currentSheet.getRange(2, 1, currentSheet.getLastRow()-1, 4).getDisplayValues(); dato.forEach(row => { createDocs(row[1],row[2],docFile,tempFolder); }); }
@david_tryon
2 жыл бұрын
Same question here. I'd like to be able to run the script when I add a new row to the source spreadsheet
@joymawad9201
2 жыл бұрын
Same question : but creating documents for a selected row or selected rows. Any replies yet ?
@gururaghavendran7794
Ай бұрын
Good 👍 thank you 😊
@leosumantra7476
Жыл бұрын
how to make the pdfs merge automately? thanks
@datacentersmpprogresifbumi2834
3 жыл бұрын
Hi, thank for your tutorial. That's it helpfully.
@ExcelGoogleSheets
3 жыл бұрын
Thank you!
@cutlooseentertainment
3 жыл бұрын
This is absolutely amazing instruction! I am a novice at coding, but was able to follow along step-by-step. I typed each line along with you and created the docs and folders right along with you. I actually made it through without errors (other than the ones you showed us) the first time through! The one issue I had has been mentioned in the other comments. How would you recommend duplication prevention when adding names to the spreadsheet and running the script again?
@ExcelGoogleSheets
3 жыл бұрын
Easy way: add a checkbox column next to your data and use FILTER function on another sheet to return rows that are checked. Then use the script on that filtered sheet. This way you can use checboxes to control which one should be created.
@cutlooseentertainment
3 жыл бұрын
@@ExcelGoogleSheets Thanks! I am gonna try that this afternoon. I had thought to use your try...catch to write DONE into a column as the PDFs were created and use if...then to NOT create those, but your way sounds much easier. I'm creating contracts, so that only needs to be done once. I can manually change anything they want changed.
@JinaneKarhani
2 жыл бұрын
@@ExcelGoogleSheets Thank you, if you can add a small tutorial about it :)
@JinaneKarhani
Жыл бұрын
@@cutlooseentertainment Can you complete please what comes after the if exactly ?! Thank you
@bigjames1970
3 жыл бұрын
Hello, all your videos are easy to understand, they give me a lot of solutions and help me to rethink my processes. In this case I wonder, how to group data in a pdf report having more than one item (lines of the spreadsheet ) referred to the same customer, like I 'm used to do with pivot, but to be dinamically generated, and saved in a folder. Thank you for all your videos and for the passion you put in spreading this knowledge!
@isikeratli
4 жыл бұрын
In your previous videos you used to use var instead of let and const, why did you change it here? And I understand you try to use them as variables but what are you using 2 different things there? Thank you for awesome contents!! Please keep up the great work!
@ExcelGoogleSheets
4 жыл бұрын
Since JavaScript engine was recently updated we can now use "const" and "let" to declare variables. In this particular case you could just replace all of them with "var" and it would work just fine as well. "const" means it's constant, so it can not be changed to something else later in code, so it's not really a "variable", even though that's what I call it. "let" is a long story :)
@RoyStevenUngKengSoon
4 жыл бұрын
@@ExcelGoogleSheets IIRC from the olden days when computer processing speed was a concern, const executes faster. If my memory serves me right...
@alitamaster1314
Жыл бұрын
If possible PDF File folder auto create into sharePoint ??
@lacocinadelatialety
4 жыл бұрын
🤯 just what I needed, thank you very much !!
@pablolacoste6777
3 жыл бұрын
Thank you very much for sharing your knowledge. Excellent work. Ask about this Tutorial: How can I incorporate an image to the PDF, if I only have the file link in a Cell? Thanks for your time. Muchas gracias por compartir tus conocimientos. Excelente trabajo. Consulta sobre este Tutorial: ¿Cómo puedo incorporar una imagen al PDF, si tengo en una Celda solo el link del archivo? Gracias por tu tiempo.
@iffyswitch
2 жыл бұрын
This is fantastic, thanks so much! ...Is there a way to include an image (any file format) in the data transfer? For a form I have images of a written signature included in the form questions, but when I put them in a column in the spreadsheet and run it though this program, in the resulting pdf it doesn't place the image but just prints the text "cellimage."
@MrTho99ed
2 жыл бұрын
same question here!
@agentleads5880
3 жыл бұрын
When you add more rows of data to your spreadsheet does the script re-create the pdfs already in the spreadsheet or just create new ones?
@cutlooseentertainment
3 жыл бұрын
Duplicates the old ones, adds the new ones. Great question! I would like to know how NOT to create duplicates. I'm using this to create contracts. I suppose you could create the PDFs and then move the data to another sheet after completion. Seems unnecessary, though. Perhaps, setValues Done and use if...then? Or have it check the Done column first before creating the PDF?
@JinaneKarhani
2 жыл бұрын
@@cutlooseentertainment any updates please?
@nicka6782
2 жыл бұрын
Firstly, amazing video thank you. Secondly, if I wanted to add in script that whenever I click the 'Create PDFs' button in the spreadsheet, it only runs the script and creates PDFs based on new data that has been added to the spreadsheet and not old/already processed data, how would I go about doing that?
@JinaneKarhani
2 жыл бұрын
hello, did you figure out how?
@nicka6782
2 жыл бұрын
@@JinaneKarhani Unfortunately I didn't. I have had to resort to just deleting the rows of data which I don't need to export.
@JinaneKarhani
2 жыл бұрын
@@nicka6782 Thank you, aha but this is not practical for some end users.
@PPanchal762
Жыл бұрын
Amezing sir thankyou soo much for this
@lmooncleveland3344
4 жыл бұрын
When I run my script, it is creating 4 extra pdf's for each 1 pdf with a name. Please help. Thanks.
@joymawad9201
2 жыл бұрын
Thank you for this clear brief tutorial. How about if i have a URL in one of the field, what should I put instead of replacetext? If you can send us how, it would be very helpful, thank you.
@ExcelGoogleSheets
2 жыл бұрын
Doesn't it just work if you treat it as text field?
@joymawad9201
2 жыл бұрын
@@ExcelGoogleSheets No sir, they need to click on it so it download the document..
@ExcelGoogleSheets
2 жыл бұрын
@@joymawad9201 body.appendParagraph("link text here").setLinkUrl("www.google.com");
@joymawad9201
2 жыл бұрын
@@ExcelGoogleSheets I will try it thank you.
@joymawad9201
2 жыл бұрын
It worked perfectly, thank youuuu.
@greglop1
3 жыл бұрын
thanks for your support!, great info very well presented!
@angelatremaine8540
4 жыл бұрын
Saved the day! Thank you so much!
@wix-li
3 жыл бұрын
This could be a great tutorial if you could share the code :) For those who understand code less but understand step by step action
@MicahKyler
4 жыл бұрын
This is such an amazing video. Thank you!!!
@loserkidAudie
4 жыл бұрын
ThankU so much badly needed this.. been searching for awhile without addons.. big big help, how about after submitted the form, auto generates PDF ?
@bolatmukashev2830
10 ай бұрын
Absolutely amazing!
@adrianosilva4572
4 жыл бұрын
Man, you is the best. Congrats.
@ScottGriffin321
7 ай бұрын
I love these videos I've learned so much! Could this be used to add a cell image to the pdf?
@nileshphalke2365
3 жыл бұрын
Gracias por este maravilloso tutorial!
@jonkat323
3 жыл бұрын
Extremely helpful, thank you!
@thanaphontangchoopong1449
3 жыл бұрын
Very useful script thank you.
@jansusan3256
4 жыл бұрын
Remarkably fabulously amazing - and every other positive adjective I can think of! Thank you. Now I need to determine how to do a mailmerge that attaches the newly created pdfs......and send it to those individual emails.....anyone?
@kumarabhishek6998
3 жыл бұрын
Can u explain how to use image stored as url in column to create pdfs? Example: I have signature stored in column K as google drive links and I want to fetch image from that url to create pdfs
@JinaneKarhani
2 жыл бұрын
hello, did you figure it how pls?
@yunyiwei5508
4 жыл бұрын
nice class :)
@ExcelGoogleSheets
4 жыл бұрын
Thanks!
@kurtismoser
4 жыл бұрын
You are a life saver!!! One quick question. How do I get it to look at the PDF folder and remove the old files automatically? My spreadsheet used to update information so when the spreadsheet updates I need new PDF's preferably without having to go into the folder and delete the old files manually.
@LasanthaPrasad
2 жыл бұрын
Thanks .. You saved my Day..
@ExcelGoogleSheets
2 жыл бұрын
Glad to hear that
@lisas5352
4 жыл бұрын
Finally, I found what I was looking for. Great teacher. However, I am still stumped. That's only because I am not into all this data stuff. Do you do this as a gig work too?
@F0YF0YT0S
3 жыл бұрын
That was an amazing tutorial. Straight to the point and perfectly explained. I implemented a version on my data which at the moment is 50 rows and 9 columns, trying to create invoices for my clients. Is it normal that the 6 minutes of allowed runtime only gets me up to about 30 pdfs created? Is there any way to optimize the script so it could potentially deal with 100 clients in less than 6 minutes? thanks for your help :)
@Ydzioemre12
3 жыл бұрын
Hi, thanks for this knowledge . Could you tell me why I received this message ''data.forEach is not a function'' ?
@epicanime87
3 жыл бұрын
Hi, I am getting the same error, did you solve it?
@germangenzor1791
2 жыл бұрын
Amazing comunicator Man!! Thanks a lot.
@ExcelGoogleSheets
2 жыл бұрын
🙂
@alfredramirez8106
3 жыл бұрын
Do you know why my PDFs print with the values (i.e. {first})? The only hint I have is that I noticed the google doc preview pane also shows the values (i.e. {first}, but when I open the doc, the correct values show. It takes a while, but the preview pane finally updates to show the correct values, but only after opening the doc manually and letting a few minutes pass by. Strange.
@alfredramirez8106
3 жыл бұрын
Update: I missed the () brackets after save and close.....works now!
@jaydipjadia
2 жыл бұрын
This is SO SO SO helpful! Kindly suggest automation for that PDF file link against that row with database.
@shannonconstructionheating4912
4 жыл бұрын
Nice just 1 question. Instead of using the button to run the code. Can i run and create the pdf each time i fill out a google form which then populates the google sheets row? Also if it can be emailed to a specific email?
Пікірлер: 634