Dude, you have absolutely no idea about how much easier my life has become since I found you. Of course it takes a little bit of time and brains to understand what you are explaining and adapt it to my specific needs (I'm no programmer), however... the time that this automations are earning me is countless,. My life is much easier now thanks to you. Thank you my friend, please, keep up the good work, we need you, hahaha :)
I have no formal tech training but have been designated the tech person for a small non-profit and needed to do exactly what this tutorial does in a needed it done last week time frame. Thank you for making these videos. They are a lifesaver.
I want to sincerely thank you for all of these tutorials. I got my degree last year and have been working with Google suite for several years now and just scored my first freelance programming job building an application in Google suite for a company
With a little work, I was able to use this basic outline, modify it a little, and create an actual working invoice I can create from my phone that is ready to email without having to be near a printer and computer. I can now create an invoice immediately and email when I have finished the work order. Thanks for the video's... so much better than other YT channels.
The best part of this, aside from all these cool stuff, is how we were able to see the thought process of it all. Plus the troubleshooting bits really gave it an approachable feel. I feel confident I can do this.
Great, Lectures, Thanks and Kudos to You. Just Now Finished by creating interactive Email System for My Clinic in Dubai, Where Patient get their immediate health indicator report. Responses are Amazing. Learned from the master. Thank You.
Excellent video, very good explanations with all the necessary details to understand simply and quickly. Congratulations and thank you for the remarkable quality of your knowledge sharing.
Thanks a ton for making this very useful video. This covered a lot of use cases and opened a ton of possibilities for future projects!! Quick tip for anyone who is facing the issue where google doc is getting created with values from form but the PDF doesnt reflect it, you can just add this line below before creating the PDF ie, last line of the createPDF()
This was AMAZING! It's the first time I've ever had no errors in my code. Thanks so much. I also appreciate how you didn't edit out your troubleshooting. That helped!
Hi! Were you able to make it work? I tried and copied what he did in the video but I got notified with exception: invalid argument: attachments I don't how to troubleshoot it. I have no background in programming. Can you help me? 🙂
Thank you very much for your tutorial. As of the present (2023), some methods in the code cannot be used, such as the "removeFile" function, which can be replaced by using the "setTrashed(true)" method.
This is exactly what I needed! I am so proud of myself. I was able to follow along and using the Google App Script Reference you showed I was able to have it send as my alias and add an additional email to send the file to myself too! I will be doing more of your tutorials to learn more. And I have little to none Java Script knowledge.
TriggerEvent step seems to have changed since you made this video. Google sheet form submit event shows a caution message “make sure you use this form submit trigger with SpreadsheetTriggerBuilder”. I am unable to pass googlesheet info data - that comes from google form - to google doc variables using event trigger. Any advise?
I've tried and this is awesome. For me this method has create a paperless system for my work. Awesome..!!! Definetely going to learn alot from this channel. Keep up the good work.👍🏻🙏🏻🙏🏻
Until 09:37 It work everything for me, but when you converting that script to reusable function are mysteries step for me, because I'm starting get a errors each time. How to add that event e correctly?
@@Didikmuhamadakbar I found a solution. It shows a some error, but it works: function afterFormSubmit(e) { Logger.log(JSON.stringify(e)); var formValues = e.namedValues; Logger.log(formValues); const info = e.namedValues; createPDF(info);
will it be possible to create pdfLink directly from google sheets without using trigger or after form submission function? Directly to generate pdflink in the google sheet and store the generated link in the pdfLink cell.
Hi @ExcelGoogleSheets, I hope that you are doing very well! I made the script as you presented it, and was working very well, but at the momment it seems to have two problems, and maybe you have some information about them. 1) It seems that the "Class File" from Apps Script, the method "removeFile" used at the end of the script "tempFolder.removeFile(newTempFile); " isn't anymore supported, it appears crossed over in .gs . Could you recomend other method to do the same part of the script? And my second question, I receive this message of error: "TypeError: Cannot read properties of undefined (reading 'namedValues')" on the constant declaration, line 3: "const info = e.namedValues;" in the function declaration. Do you have the seame error message? Many thanks for your help!
Thanks A lot. i Had a Small Issue ... How to Print Multiple Pages in 1 Pdf file? ( Mean Daily Entry as one PDF File or one Company invoices as one Pdf file)
Thank you for this awesome tutorial. I have a question. What if the respondent have to upload an image to the form which will be appear as gdrive link in spreadsheet. Then I want to show the image submitted in the PDF.
Thank you so much ! I have a question : When a form es edited and resubmitted. The namedvalues code only returns the modified values, there is a way to get all the values of the current row and execute the pdf creation? I Will be very grateful for your response ! Thank you !
When I run the code , I get this error [20-10-14 06:40:04:855 PDT] TypeError: templateDoc.makeCopy is not a function at createPDF(Code:13:34), hope to get your help, thank you so much.
Thank you for this Tutorial, I had trouble deleting the temp Document. But on looking through the references the removeFile() method in tempFolder.removeFile(newTempFile); is depreciated. So all temp Documents end up on the root folder. A new way delete is rather simple, just use newTempFile.setTrashed(true);
Hi! I have no training and new at this so this was perfect! Thank You! I am just having trouble with an addition. I added a column to the sheet to calculate two columns and just want to show the total on the google doc. It looks like it won't extract since it's a calculated value. Can you please tell me what script I need to accomplish this? THANKS AGAIN :)
I would try to pass the dependent cells values in your sheet into the script and use the script to calculate instead, then store that in a variable. I'd have thought it could pass calculated values....?
i have couple of questions: 1) the " e.namedValues " will get all the data from the form? 2) can i change the variable "e" to anything else or does it have to be "e"?
Hello, I have checked all code many times but I arrived at the same point , I have the following error, could somebody help me, what's is going on ? 2:47:44 PM Error TypeError: Cannot read property 'namedValues' of undefined afterFormSubmit @ Code.gs:3
Hi ! Awesome tutorial ! same here... any solution ? i've restarted 3 times the tutorial 3 times and still TypeError: Cannot read property 'namedValues' of undefined
The best channel to learn about google sheet Question: When a form is edited and resubmitted. The namedvalues code only returns the modified values, there is a way to get all the values of the current row and execute the PDF creation ? thx
I need help . Do you have a function that triggers a new row in the Sheet. Iam working with Wordpress and Metforms. My Workflow is Form Submit => Zapier => Data in Google Sheets. So i cant set the trigger from the Google Form, I need a trigger for a new row.
Thanks for the tutorial. Please help me knowing that if a respondent is uploading any file that appears in spreadsheet as gdrive link then I want to show that image in the pdf also. What should I do for that. Please reply.
Well this gives me some ideas, but it has to be SMS, and depending on the project, different messages need to be sent. Humm, looks like I'll be able to trigger those events. Film, Ship 2 Store, and Sameday....... the possibilitys are beginning to form... Could I send both a email and SMS at the same time..... or skip if I don't have a input value. I didn't know sheets was so powerful.
Hi, i have encountered an error during e.namedValues. It has an error which states: TypeError: Cannot read properties of undefined (reading 'namedValues'_
Thank you , its wonderful !!! Question- when I make the same form "edit response " and submit , it will fill in PDF only edited fields, not edited- will insert as blank , how do I deal with that to make them to pick up old values and fill in new PDF ?
Thanks again - I was also wondering if send email trigger can be put in place when a cell is populated manually in google sheets - i.e. when you manually enter a test result in the cell it will trigger to populate the PDF & then it will send an email with attached PDF to the person in the row...much appreciated
Fantastic! Thanks a lot for this! I already followed along with the create bulk PDF docs tutorial, and it worked like a charm! Then came here looking for triggers to make the script run automatically. This looks very very close to what I am looking for. However, I have one question. The Google Sheet from where I am pulling data into the Google Doc and converting to PDF is not connected to a Google Form. It is actually connected to Piotnet Forms on my WordPress website. Will this script run with a formSubmit trigger if it is not connected specifically to a Google Form? If not, can you please suggest a workaround if possible?
that's awesome! well i do have a question , how do i replaceText in the createPDF method when i have added a column with lets say a SUM ? when the form is submitted , it inserts a row in the sheet , so i made another sheet2 with the main columns and some extras , how do I use these extra column content with the replaceText?
very useful, as i was searching this from since many time but it seems i wasn't having option other than an add-on, but you have done a grate job brother, thanks for this video !!
How to automate only if the new row in created in spreadsheet, it will auto generate pdf for the new row. By doing this , we can include more data instead only depend on Google form which cannot perform calculation.
Hello! I am stuck in 8:18 because I keep encountering an error on the function ".makeCopy" in line 20. In my case, when I run the codes, it does not recognize it as a function. Here is what it specifically states: "TypeError: templateDoc.makeCopy is not a function". Is there a solution for this? Thank you! :)
@@ExcelGoogleSheets Hello again! Thank you for replying to my message. I tried to one by one enter the code and I saw the problem. In my function list, I don't have the "makeCopy" function. In your video, specifically at time point 4:48, you have a list of functions that includes the "makeCopy" function. Do I need to install anything or get add ons to include this function in my list? Thank you in advance. :)
Hi! What should I change in the code if I want to attach two pdfs. The first one being the customized one in the sheets and the other one is a uniform pdf for all?
seems like the url link,pdf name for the response sheet as well as sending email is not working with Shared Drive. or did i missed out something? because once i move all the files into "MY Drive" it works flawlessly
Sir, good day. Im new here. Ive read a question on how many emails i can send and you've answered 100 emails. May i know if that 100 emails is counted as 100 emails per day? Or for the entire duration? Thank you
Thank you ver much Sir. I was looking for this for a long time. I don't know the coding, but i still managed to follow the tutorial and create the mail merge as given in the tutorial. One request to you Sir, please also show how to merge the images uploaded through the forms in the doc and finally in pdf. I collect the information of my newly admitted students via google forms in which, I also collect there photos(images). So please provide next part of this tutorial in which there will be solution for merging the images in pdf. With regards.
Hi, I created a script same as yours. I works and output the PDF. Im missing a code how to attach the image that I uploaded on the form and will be on the PDF. Can you help me please? Im not a coder. I just followed your instructions.
Nice video, but the removeFile() method is now deprecated. Is there another way to delete the tempFile? Also, it would be great if you can create a video just like this but using Google sheet as the template instead of a Google Doc file.
I am using your tutorial here and need one more step ... the Google Form has file uploads and I need to have google app script paste the url of the file in the .pdf. Can you assist with the code needed to do that? The file fields (one each) are File1, File2, and File3 and their positions are 11,12,13 in the array. Thank you in advance.
Dude, you have absolutely no idea about how much easier my life has become since I found you. Of course it takes a little bit of time and brains to understand what you are explaining and adapt it to my specific needs (I'm no programmer), however... the time that this automations are earning me is countless,. My life is much easier now thanks to you. Thank you my friend, please, keep up the good work, we need you, hahaha :)
hi, do you have the code? could you please share?
I have no formal tech training but have been designated the tech person for a small non-profit and needed to do exactly what this tutorial does in a needed it done last week time frame. Thank you for making these videos. They are a lifesaver.
I want to sincerely thank you for all of these tutorials. I got my degree last year and have been working with Google suite for several years now and just scored my first freelance programming job building an application in Google suite for a company
Cool!
With a little work, I was able to use this basic outline, modify it a little, and create an actual working invoice I can create from my phone that is ready to email without having to be near a printer and computer. I can now create an invoice immediately and email when I have finished the work order. Thanks for the video's... so much better than other YT channels.
You make me feel like I'm the best coder 😄 It worked so much for my work. I create order form. No more losting papers. Thank you
The best part of this, aside from all these cool stuff, is how we were able to see the thought process of it all. Plus the troubleshooting bits really gave it an approachable feel. I feel confident I can do this.
its not working for my now. showing error ['First Name'] and etc., plz help me
Great, Lectures, Thanks and Kudos to You. Just Now Finished by creating interactive Email System for My Clinic in Dubai, Where Patient get their immediate health indicator report. Responses are Amazing. Learned from the master. Thank You.
Sorry, I can't create link and send mail. Can you assist me?
Excellent video, very good explanations with all the necessary details to understand simply and quickly. Congratulations and thank you for the remarkable quality of your knowledge sharing.
Thanks a ton for making this very useful video. This covered a lot of use cases and opened a ton of possibilities for future projects!!
Quick tip for anyone who is facing the issue where google doc is getting created with values from form but the PDF doesnt reflect it, you can just add this line below before creating the PDF ie, last line of the createPDF()
openDoc.saveAndClose();
const pdfFile = pdfFolder.createFile(blobPDF).setName("My PDF");
This was AMAZING! It's the first time I've ever had no errors in my code. Thanks so much. I also appreciate how you didn't edit out your troubleshooting. That helped!
Hi! Were you able to make it work? I tried and copied what he did in the video but I got notified with exception: invalid argument: attachments I don't how to troubleshoot it. I have no background in programming. Can you help me? 🙂
You have unlocked Pandora's box of creativity for me. Thank for teaching us🙏
Thank you very much for your tutorial. As of the present (2023), some methods in the code cannot be used, such as the "removeFile" function, which can be replaced by using the "setTrashed(true)" method.
Awesome! Plese don't get tired of doing more videos like this! Maybe you can share the script as well? Heh. :)
Oh, i would love it too!
It much better to learn if u share script. Thanks
This is exactly what I needed! I am so proud of myself. I was able to follow along and using the Google App Script Reference you showed I was able to have it send as my alias and add an additional email to send the file to myself too! I will be doing more of your tutorials to learn more. And I have little to none Java Script knowledge.
Fantastic!
It took me hours to do it, but bro.. you are something else.. really!! Thank you so much, you can't imagine how this is going to change my life!
Great teaching skills. Awesome tutorials!
you're real life saver. Please continue making videos about these.
this is actually life changing for cheap marketers like me, thanks for the tutorial, much appreciated!
TriggerEvent step seems to have changed since you made this video. Google sheet form submit event shows a caution message “make sure you use this form submit trigger with SpreadsheetTriggerBuilder”. I am unable to pass googlesheet info data - that comes from google form - to google doc variables using event trigger. Any advise?
Amazing work thank you
Thank you for step by step explanation
I've tried and this is awesome.
For me this method has create a paperless system for my work.
Awesome..!!!
Definetely going to learn alot from this channel.
Keep up the good work.👍🏻🙏🏻🙏🏻
Awesome tutorial ♥♥♥♥♥
You are an amazing teacher
Addicted to your video. Just like daily routine. Thanks 😊
huh.. super long and fun journey. Nicely delivered!
A huuuuuuuuuuuge thumbs up!!! Thank you very much. You are a life saver.
Excellent like always!!!
This tutorial is a new art form. Amazing
Great info..thank you
Excellent
Until 09:37 It work everything for me, but when you converting that script to reusable function are mysteries step for me, because I'm starting get a errors each time. How to add that event e correctly?
me to
@@Didikmuhamadakbar I found a solution. It shows a some error, but it works:
function afterFormSubmit(e) {
Logger.log(JSON.stringify(e));
var formValues = e.namedValues;
Logger.log(formValues);
const info = e.namedValues;
createPDF(info);
@@demo7191 ok, i will try it,
will it be possible to create pdfLink directly from google sheets without using trigger or after form submission function? Directly to generate pdflink in the google sheet and store the generated link in the pdfLink cell.
Thank you so much Chi! say I want to get an image uploaded in the form, should I use the mime type 'image'?
Hi @ExcelGoogleSheets, I hope that you are doing very well! I made the script as you presented it, and was working very well, but at the momment it seems to have two problems, and maybe you have some information about them. 1) It seems that the "Class File" from Apps Script, the method "removeFile" used at the end of the script "tempFolder.removeFile(newTempFile); " isn't anymore supported, it appears crossed over in .gs . Could you recomend other method to do the same part of the script? And my second question, I receive this message of error: "TypeError: Cannot read properties of undefined (reading 'namedValues')" on the constant declaration, line 3: "const info = e.namedValues;" in the function declaration. Do you have the seame error message? Many thanks for your help!
maybe
newTempFile.setTrashed(true)
wow thaank you ... well ... the slowmo guys would be very useful here ...
ur channel it is going to be big in no time!! congratulations 4 the good work n sharing!!
Great Video, thank's David
Man this is crazy and saved my life!
thank you so much for this Video. Please keep up the good work. Much love from Vietnam!!
Thanks A lot. i Had a Small Issue ... How to Print Multiple Pages in 1 Pdf file? ( Mean Daily Entry as one PDF File or one Company invoices as one Pdf file)
Thank you for this awesome tutorial. I have a question. What if the respondent have to upload an image to the form which will be appear as gdrive link in spreadsheet. Then I want to show the image submitted in the PDF.
Dear Sir kindly the solution for this question. Also resize of image that need to be fit in the template.
Did you learn how to do that?? I need it too
Thank you so much ! I have a question :
When a form es edited and resubmitted. The namedvalues code only returns the modified values, there is a way to get all the values of the current row and execute the pdf creation? I Will be very grateful for your response !
Thank you !
When I run the code , I get this error [20-10-14 06:40:04:855 PDT] TypeError: templateDoc.makeCopy is not a function
at createPDF(Code:13:34), hope to get your help, thank you so much.
Hi, even I'm getting same error "TypeError: templateDoc.makecopy is not a function (line 12, file "Code")"
Same here. I received the same error TypeError: templateDoc.makeCopy is not a function (line 20, file "Code")
I found this support.google.com/docs/thread/76410582?hl=en What did you end up doing to fix error?
@@stevenlee7524 Couldn't do anything.
@@jhone3241 I got it to work after looking at his other video th-cam.com/video/r9uU_KwGgzQ/w-d-xo.html
PRICELESS WORK ,,,,,FREE,,, THANKS A LOT
How about if you have a multiple choice and checkboxes from google forms? how could I implement it in template document and generate in pdf file?
Excellent !
Thank you for this Tutorial, I had trouble deleting the temp Document. But on looking through the references the removeFile() method in tempFolder.removeFile(newTempFile); is depreciated. So all temp Documents end up on the root folder. A new way delete is rather simple, just use newTempFile.setTrashed(true);
Thanks for the update!
Hi! I have no training and new at this so this was perfect! Thank You! I am just having trouble with an addition. I added a column to the sheet to calculate two columns and just want to show the total on the google doc. It looks like it won't extract since it's a calculated value. Can you please tell me what script I need to accomplish this? THANKS AGAIN :)
I would try to pass the dependent cells values in your sheet into the script and use the script to calculate instead, then store that in a variable. I'd have thought it could pass calculated values....?
Thank you for these videos. I appreciate you!
i have couple of questions:
1) the " e.namedValues " will get all the data from the form?
2) can i change the variable "e" to anything else or does it have to be "e"?
I think it's event, not element, but it doesn't matter.
Really great video here. Thanks !
VERY BRILIANT !!!
Thanks!
Finally, script is working fine.
I spend whole day. But failed, can you share your sources code sir
Wowwwww, just amazing! Thanks a lot!
Hello, I have checked all code many times but I arrived at the same point , I have the following error, could somebody help me, what's is going on ?
2:47:44 PM Error
TypeError: Cannot read property 'namedValues' of undefined
afterFormSubmit @ Code.gs:3
Hi ! Awesome tutorial ! same here... any solution ? i've restarted 3 times the tutorial 3 times and still
TypeError: Cannot read property 'namedValues' of undefined
Great Job!!!
i've been having an error saying Cannot read property 'namedValues' of undefined can anyone help?
I am having the same problem.
Did you fixed
Awesome
MAY BE ONE DAY I HAVE THE HONOUR OF MEETING YOU..
The best channel to learn about google sheet
Question:
When a form is edited and resubmitted.
The namedvalues code only returns the modified values, there is a way to get all the values of the current row and execute the PDF creation ?
thx
Hi, did you find a way to fix that ? I will be very grateful to you !
@@valentinpereira810
Yes,
const ActiveSS = SpreadsheetApp.getActiveSpreadsheet();
const ActiveSheet = ActiveSS.getActiveSheet();
const ActiveRow = e.range.getRow();
const Name = ActiveSheet.getRange('B'+ ActiveRow).getValue();
const ContactEmail = ActiveSheet.getRange('C'+ActiveRow).getValue();
Excelente muchas gracias por su ayuda, que mi Dios lo bendiga por siempre. 🙏
This was awesome! Learned so much!
:)
I need help . Do you have a function that triggers a new row in the Sheet. Iam working with Wordpress and Metforms. My Workflow is Form Submit => Zapier => Data in Google Sheets. So i cant set the trigger from the Google Form, I need a trigger for a new row.
Eres brillante!☆☆☆☆☆ El mejor canal de GAS☆☆☆☆☆
Thanks for the tutorial. Please help me knowing that if a respondent is uploading any file that appears in spreadsheet as gdrive link then I want to show that image in the pdf also. What should I do for that. Please reply.
I have the same question too.... Were you able to find a solution.. Thanks!
dude, if i just want make the url link, i can skip the step make pdf with spreadsheet and do de function to insert the url link?
Is there a script I can copy so I'm not reinventing this wheel? I'm new to this and didn't know where to look. Thanks!
@Learn Google Spreadsheets I got error in line 2..... TypeError: cannot read property ‘namedValues’ of undefined ( line 2, file “code”)
Need help
Well this gives me some ideas, but it has to be SMS, and depending on the project, different messages need to be sent. Humm, looks like I'll be able to trigger those events. Film, Ship 2 Store, and Sameday....... the possibilitys are beginning to form... Could I send both a email and SMS at the same time..... or skip if I don't have a input value. I didn't know sheets was so powerful.
Hello, thank you for this video. And please explain to me 09:40-09:42, when I remove info my command did not work.
Where is the section called Info? Doesn't it seem like it was just deleted? Please explain this part to me
Hi, i have encountered an error during e.namedValues. It has an error which states: TypeError: Cannot read properties of undefined (reading 'namedValues'_
Me too x.x
Me too
Thank you , its wonderful !!! Question- when I make the same form "edit response " and submit , it will fill in PDF only edited fields, not edited- will insert as blank , how do I deal with that to make them to pick up old values and fill in new PDF ?
Hello, did you find a way to fix that ? I will be very grateful to you !
Thanks again - I was also wondering if send email trigger can be put in place when a cell is populated manually in google sheets - i.e. when you manually enter a test result in the cell it will trigger to populate the PDF & then it will send an email with attached PDF to the person in the row...much appreciated
Fantastic! Thanks a lot for this!
I already followed along with the create bulk PDF docs tutorial, and it worked like a charm! Then came here looking for triggers to make the script run automatically. This looks very very close to what I am looking for.
However, I have one question.
The Google Sheet from where I am pulling data into the Google Doc and converting to PDF is not connected to a Google Form. It is actually connected to Piotnet Forms on my WordPress website.
Will this script run with a formSubmit trigger if it is not connected specifically to a Google Form? If not, can you please suggest a workaround if possible?
thanks for the video
i followed all your steps but i have a probleme the PDF FILE does not get ceated only the temp file
Many Many thanks.its working..
Love this channel
can we as well have images upload from G form and then populate onto the PDF layout?
that's awesome! well i do have a question , how do i replaceText in the createPDF method when i have added a column with lets say a SUM ? when the form is submitted , it inserts a row in the sheet , so i made another sheet2 with the main columns and some extras , how do I use these extra column content with the replaceText?
Does this works by using it on a tablet?
very useful, as i was searching this from since many time but it seems i wasn't having option other than an add-on, but you have done a grate job brother, thanks for this video !!
How to automate only if the new row in created in spreadsheet, it will auto generate pdf for the new row. By doing this , we can include more data instead only depend on Google form which cannot perform calculation.
Hello! I am stuck in 8:18 because I keep encountering an error on the function ".makeCopy" in line 20. In my case, when I run the codes, it does not recognize it as a function. Here is what it specifically states: "TypeError: templateDoc.makeCopy is not a function". Is there a solution for this? Thank you! :)
That means the line before where templateDoc was defined failed.
So check the line where it says
const templateDoc = something;
@@ExcelGoogleSheets Hello again! Thank you for replying to my message. I tried to one by one enter the code and I saw the problem. In my function list, I don't have the "makeCopy" function. In your video, specifically at time point 4:48, you have a list of functions that includes the "makeCopy" function. Do I need to install anything or get add ons to include this function in my list? Thank you in advance. :)
I already found it! Instead of putting "getFileById" in Line 11, I inputted "getFolderByID". Thank you for your help! :)
Hi! What should I change in the code if I want to attach two pdfs. The first one being the customized one in the sheets and the other one is a uniform pdf for all?
Dear sir
Can we add photo from Google forms and add the same to pdf
Perfect bro. You helped me a lot
seems like the url link,pdf name for the response sheet as well as sending email is not working with Shared Drive. or did i missed out something? because once i move all the files into "MY Drive" it works flawlessly
Thank you, this is great! I learnt lot of things watching your video!
TypeError: Cannot read property 'namedValues' of undefined
at formSubmit(Code:2:18)
I really appreciate your channel!
Sir, good day. Im new here. Ive read a question on how many emails i can send and you've answered 100 emails. May i know if that 100 emails is counted as 100 emails per day? Or for the entire duration? Thank you
per day
Thank you ver much Sir. I was looking for this for a long time. I don't know the coding, but i still managed to follow the tutorial and create the mail merge as given in the tutorial. One request to you Sir, please also show how to merge the images uploaded through the forms in the doc and finally in pdf. I collect the information of my newly admitted students via google forms in which, I also collect there photos(images). So please provide next part of this tutorial in which there will be solution for merging the images in pdf. With regards.
Hi, I created a script same as yours. I works and output the PDF. Im missing a code how to attach the image that I uploaded on the form and will be on the PDF. Can you help me please? Im not a coder. I just followed your instructions.
Nice video, but the removeFile() method is now deprecated. Is there another way to delete the tempFile? Also, it would be great if you can create a video just like this but using Google sheet as the template instead of a Google Doc file.
I am using your tutorial here and need one more step ... the Google Form has file uploads and I need to have google app script paste the url of the file in the .pdf. Can you assist with the code needed to do that? The file fields (one each) are File1, File2, and File3 and their positions are 11,12,13 in the array. Thank you in advance.
Can this code modify for run without Form Submit - etc. run after click "RUN"
Oh man, this makes my life easy
It’s very impressive! Thank you!