@@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?
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.
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?
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?!
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.
@@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.
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.
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🙏
@@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
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 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 ?