Hi, this is really super and easy to understand tutorial, love the way of your teaching method. Sir you are awesome. Keep helping up.
@AutomationMadeEasy
Жыл бұрын
Thank you
@faisalmalik1637
Жыл бұрын
@@AutomationMadeEasy sir is there any limitations. After two days it stop working.
@faisalmalik1637
Жыл бұрын
It's not filling salary slips and showing error on sending emails.
@AutomationMadeEasy
Жыл бұрын
yes there are certain limitations. max execution time in a 24 hr window is 1 hr
@Summer-tq7pg
2 жыл бұрын
Your tutorial is super easy and, at the same time, very professional. Thank you so much.
@AutomationMadeEasy
2 жыл бұрын
Glad it was helpful!
@jackiebananura4003
5 ай бұрын
How do you create the codes
@user-ys4bm7bn4k
5 ай бұрын
Thank you so much for this sir. Thank you too for the script. I deeply appreciate you
@AutomationMadeEasy
5 ай бұрын
Happy to help
@ismatismet6559
2 жыл бұрын
thank you its worderfull explanation i hope u make "send salary by Whatsapp" im waiting :) because ur explain its so clear for beginner like me best regards
@EFFORTSWILLSCH
4 ай бұрын
thanks so much for this tutorial its really impactful. Thanks
@AutomationMadeEasy
4 ай бұрын
Glad you think so!
@excelwithjamessm.6468
6 ай бұрын
I love the content. Helpfull. Kudos Sir
@AutomationMadeEasy
6 ай бұрын
Glad to hear that
@swaminaathanvl6517
Жыл бұрын
If explain in Tamil it is very helpful
@AdminYAIHarja2
3 ай бұрын
thank you sir. clearly explanation
@AutomationMadeEasy
3 ай бұрын
You are welcome
@user-nk8ly9iy3p
3 ай бұрын
Hi, I am very happy to see your video. I have an issues that is my total employee 5person but when I applied your code then just created pdf for one employee that is in row no 2. please help me to solve this problem.
@AutomationMadeEasy
3 ай бұрын
check your loop may be the syntax for creating final pdf is placed outside the loop
@RAHULKUMAR-pm5no
Жыл бұрын
You explained complex things in a simple way. Awesome to watch and please provide me source code.
@AutomationMadeEasy
Жыл бұрын
thanks. You can find the code on the blog automationandagile
@SalAbraham7
8 ай бұрын
@@AutomationMadeEasy Where is the blog?
@heryantobinhassan1562
2 жыл бұрын
Hi thanks for the wonderful explanation. Can you help which code I need to change if I want to generate pay slip only for the selected row when clicking the button?
@Nidhin89
2 жыл бұрын
Wonderful Explanation.Thank you😇
@AutomationMadeEasy
2 жыл бұрын
Glad it was helpful!
@Krish9811
Жыл бұрын
Super satisfying. 🤩👍👍
@AutomationMadeEasy
Жыл бұрын
Glad you think so!
@darrelgavino6176
11 ай бұрын
Thank you! you are a genius! I tried it and it worked!
@AutomationMadeEasy
11 ай бұрын
Glad it helped!
@DibyenduR
8 ай бұрын
Its very helpful to me but I want to do this by google form when I submit the form by EmpID then script is running and One prob is removeFile property show disable
@makelifeeasy1917
Жыл бұрын
Hi, Thanks for the information. Your way of explaining is wonderful, thanks alot for the source code. : )
@AutomationMadeEasy
Жыл бұрын
Glad it was helpful!
@francinehernandez1876
Жыл бұрын
Exception: Document is missing (perhaps it was deleted, or you don't have read access?)Details Dismiss I'm getting this message when I try to execute it. What am I doing incorrectly?
@Azizashiq
2 жыл бұрын
Thank You Sir, great information
@AutomationMadeEasy
2 жыл бұрын
Glad it was helpful!
@iamhutchi
Жыл бұрын
Hi, I try your tutorial, and it working perfectly fine. But I need extra options is it possible to lock/encrypt the PDF file that is attached to the email for more security? let's say use the 'empID' as a pdf password. thank you for very useful tutorial :)
@AutomationMadeEasy
Жыл бұрын
It is feasible but will need lot of customization's.
@reggaedude111
Жыл бұрын
Hello. Is there a way to use a google sheet format instead of google doc format? Thank you.
@PeasOfCrab
2 жыл бұрын
Good explanations, boss - keep up the work!
@AutomationMadeEasy
2 жыл бұрын
Appreciate it!
@TilakConrad
Жыл бұрын
super - not only the comprehensive content but also your clear teaching style - really superb - thanks very much question - what needs to be modified in the appscript - to delete the extra pdf and the multiple "copy of salary template" that is created in this process. Hope you can advise - but thanks for the content you create.
@AutomationMadeEasy
Жыл бұрын
script for remove is explained in the tutorial. Syntax given below: pdfFolder.removeFile(paySlipFile);
@TilakConrad
Жыл бұрын
@@AutomationMadeEasy Thank you very much for that and sorry I explained badly - all works fine - but the script creates multiple (1 for each address) Doc files in the root of my Google Drive - called "Copy of Salary Slip Template" My "Salary Slip Template" is in my Salary_Slips folder and that is where the pdf's are created - however the "Copy of Salary Slip Template" are created in the root - I would like to have these automatically deleted - not sure what I've done incorrectly and your help is appreciated. TIA Tilak
@HeyTash
2 жыл бұрын
THIS IS AWESOME!!!
@AutomationMadeEasy
2 жыл бұрын
thank u
@LagaIndraLesmana
Жыл бұрын
Hi Thank you for your inspiring tutorial video, I already implement it to my own form but the script doesn't work :D please help me
@michaelangelosuarez8763
6 ай бұрын
Thnx is working :)
@AutomationMadeEasy
6 ай бұрын
Welcome 👍
@prithvirana1958
Жыл бұрын
I mean from google doc to google sheet?
@orlandonietolaverde4763
11 ай бұрын
Hello, do you think it is possible that if one of the fields is 0, that concept is not created in the format? For example, if the person does not have a profession tax, do not call the concept?
@AutomationMadeEasy
11 ай бұрын
definately possible but will need lot of customization
@ThanjaiThalaivaas
Жыл бұрын
is it possible to create in ms excel and send in outlook mail
@mohamadsafwan4575
Жыл бұрын
Thanks 👍🙏👍
@AutomationMadeEasy
Жыл бұрын
Welcome 👍
@MirMakarimAhsan
11 ай бұрын
Everything is working fine. But there is an issue that a copy of salary slip is automaticaly saved as doc file in the root drive folder. We have removed doc file from salary details folder but how do i get rid of it. It will be very much helpfull if you help me in this case.
@AutomationMadeEasy
11 ай бұрын
in the script it is explained , how to delete the copy of template file
@stanleymunro9829
11 ай бұрын
Hi is it possible to edit the code in the end instead of emailing it, it prints the PDF it created?
@AutomationMadeEasy
11 ай бұрын
yes just exclude the last part where mails are sent
@srishtipawar4254
2 жыл бұрын
Interesting! Could you please share the code? Or the link to download the code?
@jaysonradibok7596
2 жыл бұрын
When it comes to the linking of the SalarydetailFolder and salaryTemplate I just want to know what is the problem if the salary slp pdf doesnt appear in the google drive folder(Salarydetailfolder)?....
@AutomationMadeEasy
2 жыл бұрын
it can be any subfolder in the google drive.
@sheesh772
Жыл бұрын
how can i trigger the script in mobile? can you help me pls
@faisalmalik1637
Жыл бұрын
Sir, is this possible we can send all email through outlook. If yes then please guide me. Thanks
@@AutomationMadeEasysir I have watched your refer video. But it's not working in Google sheets script. Also unable to add signature
@AutomationMadeEasy
Жыл бұрын
Above link I shared is for excel and outlook not google sheets.
@acebrianamordomingo3236
Жыл бұрын
How do you make the code create and send payslips in a recurring manner? Like monthly?
@AutomationMadeEasy
Жыл бұрын
you can set up a trigger for that
@jaikumar7519
2 жыл бұрын
Please share the script code of the tutorial
@jaimelegaspi9869
2 жыл бұрын
Hi can i have a copy of the script i cant barely see it. Thank you in advance.
@EFFORTSWILLSCH
4 ай бұрын
thanks sir for the video, but pls i need to solve this "Exception: Failed to send email: no recipient"
@AutomationMadeEasy
4 ай бұрын
check the variable which is storing email id of the recepient
@michaelangelosuarez8763
5 ай бұрын
hi the copy template is deleted in salary folder but in the copy template is automatic in my drive. how this happen
@AutomationMadeEasy
5 ай бұрын
it may be in your trash folder of your drive
@sauravbanerjee2028
2 жыл бұрын
Hey, I want to connect with you on a work, This involved automation of a website on user's manual activites. let me know if we can connect
@AutomationMadeEasy
2 жыл бұрын
sure.. write into info@automationandagile.com
@sauravbanerjee2028
2 жыл бұрын
@@AutomationMadeEasy has sent you an email.
@jenniferflores4433
Жыл бұрын
What if I want a meesage prompt first "Are you sure you want to send payslips" Yes/No. Can you show me how, please?
@AutomationMadeEasy
Жыл бұрын
let me check
@menaeem
2 жыл бұрын
Hi, Thanks for the Tutorial. Can you please share the code??
@AutomationMadeEasy
2 жыл бұрын
its on the blog automationandagile
@menaeem
2 жыл бұрын
@@AutomationMadeEasy Plz share the exact link...
@BhavinJoshi123
Жыл бұрын
THE SCRIPT IS RUNNING AFTER DATA FINISH AND CREATEING EMPTY SALSLIP AND THAN THIS ERROR OCCURED Exception: Failed to send email: no recipient can you Pls help me here to stop script to run once cell are empty in G sheet
@AutomationMadeEasy
Жыл бұрын
need to see ur script
@BhavinJoshi123
Жыл бұрын
@@AutomationMadeEasy function createAndSendSalSlips() { var empName=""; var empEmail = ""; var empDesg=""; var noOfPayableDay=0; var salMonth_Year=""; var basicSal=0; var trainSal=0; var attendanceAllowence=0; var incentives=0; var proffTax=0; var dNachBounce=0; var grossEarn=0; var totalDeduction=0; var netPay=0; var spSheet = SpreadsheetApp.getActiveSpreadsheet(); var salaryDetailsFolder = DriveApp.getFolderById("1-fvE_wRpEO25guMUyyYrsqbi5j28lcnS"); var salaryTemplate = DriveApp.getFileById("1WjNZgR93i4HBCF82P2XLGrtca38vBm0NXTXxxm20msQ"); var totalRows = spSheet.getLastRow(); for(var rowNo=6;rowNo
@kankanaroy141
2 жыл бұрын
Can't find the code neither the blog . Can anyone please help me out
@NicolaBunchuay
Жыл бұрын
When I use debug code runs perfectly, however when I run in Googlesheet it shows an error message "TypeError: cannot read properties of null (reading 'getLastRow')". How can I fix this?
@AutomationMadeEasy
Жыл бұрын
check ur loop. seems it is reading null rows.
@NicolaBunchuay
Жыл бұрын
@@AutomationMadeEasy I have tried to check the loop but still not sure how to fix - could I email it to you?
@AutomationMadeEasy
Жыл бұрын
write into info@automationandagile.com
@NicolaBunchuay
Жыл бұрын
@@AutomationMadeEasy Thank you very much for your prompt reply and great code! I will email you as suggested.
@Just-the-Gameplay
2 жыл бұрын
first
@SanviPatil2019
2 жыл бұрын
sir please mujhe mere computer me yeh code ki settings karke do. mere pc me pdf file me kuch bhi changes nahi ho rahe he... file send ho rahi hai..but usme koibhi changes nahi ho rahe
@AutomationMadeEasy
2 жыл бұрын
write into info@automationandagile.com
@SanviPatil2019
2 жыл бұрын
hi sir.. maine yeh code sub barobar copy paste kiya mere google sheet me.. but meri file jis folder me pdf banke aa rahi hai.usme koi bhi salary ki details nhi aa rahi hai.. salary template waise ki waise hi pdf ban ke aa raha hai. empid_xxxxx, empname_xxxxx, isme name value nahi aa rahi hai..help.me.. aur word file folder ke bahar ban rahi hai..
@AutomationMadeEasy
2 жыл бұрын
script meh folder id aur template ka id check karo.Kuch chhoti mistake hogi jisse se process theek se nhi ho raha.
@SanviPatil2019
2 жыл бұрын
@@AutomationMadeEasy dono id right hai. per values replace nahi ho rahi hai
@dlodindigul5196
Жыл бұрын
the website you told was not available please enable to download the script sir
@user-zn9tq1gc9j
4 ай бұрын
how to create that send button please reply...
@AutomationMadeEasy
3 ай бұрын
Click Insert - Drawing - Click Shape. Select shape, On the top right corner of shape click the 3 dots assign script and paste the name of function in app script
@user-iy8wg9su6e
11 ай бұрын
Can we get a copy of this?
@AutomationMadeEasy
11 ай бұрын
you can find the script on the blog automationandagile
@backofficearchtech6250
6 ай бұрын
make copy thing is not working for me..help me
@AutomationMadeEasy
6 ай бұрын
need to see your code
@JieTeves
Жыл бұрын
Can i buy this?
@AutomationMadeEasy
Жыл бұрын
share your contact info or write into info@automationandagile.com and I will help you to create a customized solution for your requirements
@issacndlongwane7575
2 жыл бұрын
What to do if line 32 of the code is coursing an error in the code??
@AutomationMadeEasy
2 жыл бұрын
Can you share your script
@NicolaBunchuay
Жыл бұрын
Do you have a solution I have the same problem but not in debug only when run in Googlesheets
@FBTS-HR
6 ай бұрын
hi can i ask for the script?
@AutomationMadeEasy
6 ай бұрын
its on the blog automationandagile.com
@mittalraghav13
2 жыл бұрын
Can we send like this on wahtsapp also
@AutomationMadeEasy
2 жыл бұрын
unfortunately no
@user-sm1dv1km8g
Ай бұрын
i can't find the script can you please send me
@AutomationMadeEasy
Ай бұрын
you can find it on the blog automationandagile.com
@prithvirana1958
Жыл бұрын
How did you move your template to google sheets?
@AutomationMadeEasy
Жыл бұрын
template is created using google docs. The code is using the google doc template to generate the pay slips
@teachinfolk
Жыл бұрын
Please send me source code?
@rushrush6754
2 жыл бұрын
Share copy of file so we can play with
@AutomationMadeEasy
2 жыл бұрын
Entire code is available on the blog
@rushrush6754
2 жыл бұрын
@@AutomationMadeEasy link in description???
@mohdsalihin6474
2 жыл бұрын
Can share the code please?
@AutomationMadeEasy
2 жыл бұрын
its on the blog
@fahadmunir5426
2 жыл бұрын
@@AutomationMadeEasy Where is the blog?
@vapcabs
Жыл бұрын
Exception: The parameters (DriveApp.FolderIterator) don't match the method signature for DriveApp.File.makeCopy. createAndSendSalSlips @ Code.gs:85 I'm getting this error can you help me out
@hrmanager6240
2 жыл бұрын
I am looking for support can you help us
@AutomationMadeEasy
2 жыл бұрын
for consultation write into info@automationandagile.com
@jchorcrux1
2 жыл бұрын
why am i getting access denied driveapp. how to solve issue I followed your app script
Пікірлер: 130