@@LaurenceSvekisCourses First of all, thank you for your interest. I have a personal project that I want to do. A small Tattoo studio needs a management program. I want to add an appointment to google calendar with fields such as Customer Appointment information (Name Surname, Country, Hotel, Tattoo Type, Tattoo Artist, Tattoo Designer, Payment Method, Fee, Deposit, Free Service etc.). I also want to print the appointment information and the contract on a single A4 page and give it to the Customer. And I want a section to be made for calculating the percentage earnings of Tattoo Artists and Studio staff. Is it possible to manage this application from a web application using google script? Can you make a video about it?
Hi, Laurence! Your help is greatly appreciated. Question though, how can I make a line spacing between sentences in message.body? I want to make a sentence/paragraph next line below the first sentence with a single line space.
I'm trying to tie this to a form so that the email from the sheets goes out upon form submission. Is there simple code to add to sheets or should I start over and code the form?
@@LaurenceSvekisCourses I wanted to know if it is possible to save data in goolge sheets without repeating what has already been recorded. Would you help me? Thanks.
Okay, this video is assume. I have one question... could the code be set so IF the Sheet gets a new submission, it automatically runs the Email Out script? Or does the Email Out have to be run manually?
Thanks for making our work easier. I do have an issue though, whenever I script "Hi,${row[3]}." in the messagebody for the email, it won't populate. and its text is red. any tips how to resolve? Thanks in advance.
This is amazing! I'm having two issues... 1) I keep getting more copies of the file, but it's not replacing the one before. 2) The rest of the {} parts that need to be replaced by the worksheet are not working. Can anyone help please?!
Hello, I am trying to automate a template using a spreadsheet but I seem to be having issues populating multiple fields. I am able to body.replaceText once but when I try to add the others it won't work. How do I know which row number to use? thank you. Example: body.replaceText('{Employee Name}',row[1]) body.replaceText('{Field 2}',row[?]); body.replaceText('{Field 3}',row[?]);
Thanks for the useful video. In this process, excell data creates the doc file and simultaneously pdf file. However I have a project in which i have google sheet having a script which creates the doc file, filled with the sheet details. And second script in the doc template that is save as pdf and send on mail. Every time sheet is filled and doc is created and the save and send email script is run it asks for permission for every new doc file. How to resolve that? So that after checking doc file it directly save as pdf and send on email without asking everytime permission. Plz help me.
Yes thats the best thing about it, its a free server that has a tonne of built in services and processes on the ready. Thats actually how I ended up starting with Apps Script, a simple app they client had no server.
Yes you can, you can use the webapp and set a doPost() to retrieve the JavaScript request Keep in mind that this opens the sheet since its frontend code and the URL will be visible
@@LaurenceSvekisCourses Can You Please Share a simple blank View In Gmail Like for Example Inbox in Gmail has its own view by using the app script,or please share references by which I can try to do it myself
Thanks for ur tutor bro. But i have problems when we fill email not in sequence, why is not sent, it says "Failed to send email: No Recipient". for example we have 6 data, first to fourth is running like u did because is sequence, but if we jump to sixth, which is fifth data is empty, sixth row is not send and error message come out. How we fix this so we can fill the data not just in sequence? I really apreciate for ur answer
Generally you would see that type of error if the email was not a valid one, check if you have whitespace also try to prefill the email and test to see if it works.
@@LaurenceSvekisCourses yes, if email is not valid, it cant be sent. But the problem is, if we jump to another row, like tenth row. first to fourth row, we fill data and valid email like u did is running, but fifth to ninth is empty, completely blank row,and we fill data and valid email in tenth row, is not running is not sent, but if i fill 4 to 9 again with valid email, tenth row running again and sending. why i cant fill any position of row that i want? why cant be any blank row? why must in sequence? Really appreciate with ur answer🙏
I get an error when I run the script and it says, " Exception: The document is inaccessible. Please try again later. (anonymous) @ Code.gs:14 sender @ Code.gs:12 " How can I solve this problem ?
Dude, you're amazing! I've spent the entire day revising your video and its really gonna help me at work. Cheers from Brazil. Keep up the good work!
Above and beyond Thank you a million !!!
Thank you greatfully. This is help me to finish my work.
Thank you gratefully. This is exactly what I needed.
You're very welcome!
This was absolutely amazing. Thank you for this. Subscribed for LIFE!
Awesome, thank you!
Thanks for the good information. We look forward to the continuation.
thank you for watching please let me know if you have any questions
@@LaurenceSvekisCourses First of all, thank you for your interest. I have a personal project that I want to do. A small Tattoo studio needs a management program. I want to add an appointment to google calendar with fields such as Customer Appointment information (Name Surname, Country, Hotel, Tattoo Type, Tattoo Artist, Tattoo Designer, Payment Method, Fee, Deposit, Free Service etc.). I also want to print the appointment information and the contract on a single A4 page and give it to the Customer. And I want a section to be made for calculating the percentage earnings of Tattoo Artists and Studio staff.
Is it possible to manage this application from a web application using google script? Can you make a video about it?
Thanks for the amazing lesson!!!! Appreciate alotttttttt!!!!
thanks for your support
Thanks, a wonderful lesson.
Glad you liked it!
Thank you so much
How can I increase the 6 minute execution limit in Google Apps script?
Hi, Laurence! Your help is greatly appreciated. Question though, how can I make a line spacing between sentences in message.body? I want to make a sentence/paragraph next line below the first sentence with a single line space.
You can add a blank line or change the setting of the doc
Thank you for sharing it, this is super useful 👍🏻
Glad it was helpful!
I'm trying to tie this to a form so that the email from the sheets goes out upon form submission. Is there simple code to add to sheets or should I start over and code the form?
Thanks for share 👍👍👍👍👍
Thanks for visiting
great tutorial, keep doing pls ..
Thanks, will do!
Thank you so much for your hard work. If you don't mind is there a way to add a link of the pdf file created next to the sent date.
Yes you can get the URL of the PDF and set the link as needed.
thank you so much for this :D
You're very welcome!
Very cool. A question how to do not repeat messages already recorded ?
Please save em from this code.
Sorry I don't understand the question
@@LaurenceSvekisCourses I wanted to know if it is possible to save data in goolge sheets without repeating what has already been recorded. Would you help me? Thanks.
Okay, this video is assume. I have one question... could the code be set so IF the Sheet gets a new submission, it automatically runs the Email Out script? Or does the Email Out have to be run manually?
Thanks for making our work easier. I do have an issue though, whenever I script "Hi,${row[3]}." in the messagebody for the email, it won't populate. and its text is red. any tips how to resolve? Thanks in advance.
You need to use the backtick for template literals, or for quotes you need to break out of the string and use the +
@@LaurenceSvekisCourses thanks, I solved it thru the link provided. my script is now fully functional. this is new to me and i learn ir overnights..
Is there a way to populate the new Google sheet document instead of the date for sent column?
Yes it will take whatever content is posted to the cells in setValues()
This is amazing! I'm having two issues...
1) I keep getting more copies of the file, but it's not replacing the one before.
2) The rest of the {} parts that need to be replaced by the worksheet are not working.
Can anyone help please?!
If i make 5 doc from the spreadsheet, How to auto merge them?
Thank You
Sorry I don't understand, why would you not just create the one doc why 5 and then merge?
Hello Sir, How to replace text with QR from URL?
Hello, I am trying to automate a template using a spreadsheet but I seem to be having issues populating multiple fields. I am able to body.replaceText once but when I try to add the others it won't work. How do I know which row number to use?
thank you.
Example:
body.replaceText('{Employee Name}',row[1])
body.replaceText('{Field 2}',row[?]);
body.replaceText('{Field 3}',row[?]);
Thanks for the useful video.
In this process, excell data creates the doc file and simultaneously pdf file.
However I have a project in which i have google sheet having a script which creates the doc file, filled with the sheet details. And second script in the doc template that is save as pdf and send on mail.
Every time sheet is filled and doc is created and the save and send email script is run it asks for permission for every new doc file. How to resolve that? So that after checking doc file it directly save as pdf and send on email without asking everytime permission.
Plz help me.
Epic! One can utilize this to create server less erp/CRM solutions for business without breaking the bank.
Yes thats the best thing about it, its a free server that has a tonne of built in services and processes on the ready. Thats actually how I ended up starting with Apps Script, a simple app they client had no server.
How do you do the same thing, except instead of having it automatically emailed, it's saved to email draft instead
For draft emails you need to use the gmailapp service not mailapp
I cannot get the body.replaceText to work, any ideas?
Is it possible to modify the data in the spreadsheet using vanilla JavaScript?
Yes you can, you can use the webapp and set a doPost() to retrieve the JavaScript request Keep in mind that this opens the sheet since its frontend code and the URL will be visible
I have some other videos that show how to setup the JavaScript connection to Apps Script web app
Hi! I keep getting this error message and I can't figure out what I've done wrong - TypeError: Cannot read properties of null (reading 'getDataRange')
Hello Sir Can You create a simple CRM Like asana or Google Streaks by using a google app script, please tell us as soon as possible
I have several lessons on similar content, although a full CRM is a lot of work
@@LaurenceSvekisCourses Can You Please Share a simple blank View In Gmail Like for Example Inbox in Gmail has its own view by using the app script,or please share references by which I can try to do it myself
I have salary slip of employee n data i want to learn
Sir {FIRST}{LAST} in docs not working . Please help.header1=heading.toUpperCase()
body.replaceText( '{${header1}}'.row[1] I think problem.
if you use template literals its a backtick not a single quote `
@@LaurenceSvekisCourses SIR PERFECTLY WORK . '{${header1}}' THIS WAS MY MISSTAKE .THANKS .
Hi, sometimes the script runs and sometimes just shows in the log "started running" and after few seconds "stopped running"
It depends on the task, there is a timeout of 15 minutes on scripts also depending on the server load
Thanks for ur tutor bro. But i have problems when we fill email not in sequence, why is not sent, it says "Failed to send email: No Recipient". for example we have 6 data, first to fourth is running like u did because is sequence, but if we jump to sixth, which is fifth data is empty, sixth row is not send and error message come out. How we fix this so we can fill the data not just in sequence? I really apreciate for ur answer
Generally you would see that type of error if the email was not a valid one, check if you have whitespace also try to prefill the email and test to see if it works.
@@LaurenceSvekisCourses yes, if email is not valid, it cant be sent. But the problem is, if we jump to another row, like tenth row. first to fourth row, we fill data and valid email like u did is running, but fifth to ninth is empty, completely blank row,and we fill data and valid email in tenth row, is not running is not sent, but if i fill 4 to 9 again with valid email, tenth row running again and sending. why i cant fill any position of row that i want? why cant be any blank row? why must in sequence?
Really appreciate with ur answer🙏
i figure it out, just put this
if (email == "") return;
before mailapp
thanks anyway bro
I get an error when I run the script and it says,
" Exception: The document is inaccessible. Please try again later.
(anonymous) @ Code.gs:14
sender @ Code.gs:12 "
How can I solve this problem ?
Its possibly a permissions issue
@@LaurenceSvekisCourses Thank you and I have sorted out the issue
I had the same issue. It must be a google doc file. I had a word docx, which made this error.
@@xavierswiss yeah I got it, that was the error