Sir you are a genius!! I searched high and low using Microsoft word and pdf to make this automation happen, but the correct answer is in your video. Thank you so much for your tutorial, really appreciate your work!!
I am a university professor myself and I must say that this video has made my day. I looked for many videos, but this was the most comprehensive one. Thank you sir for your kindness.
Is there a way to format the date from 8/21/2021 to August 21, 2021. I used the date picker and upon submitting the form, what was recorded is in this format 8/21/2021. How can I set or format the date?
Hi, thank you so much for the tutorial. I have followed the instructions -but participants are not getting emails. I am missing a step but i just cant figure out where?
Autocrat is giving an error message as_ Error: tags fetching failed. Please make sure type in all tags in your template manually. Autocrat wont fetch tags that are from copr and paste. I dont have any copied tags though. Kindly advise what to do now.
!!Error Sending Emails: Service invoked too many times for one day: i am facing this issue in my google sheet which registers response. any idea how can I fix it?
Whenever I want to use Autocrat addon in google sheets, I want to see my official business email sent to client but each time I am seeing my gmail email sent. How can I change it to my official email. I want to send emails to clients from my official email and not from gmail. Please advise.
Whenever I want to use Autocrat addon in google sheets, I want to see my official business email but each time I am seeing my gmail account. How can I change it to my official email. I want to send emails to clients from my business email through autocrat.
Not able to map source data to template, it is just saying that "duplicate merge sheet headers found". Please help me out of this as I cannot type the data of 120 students manually!
Sir, I had four columns in google response in fifth column i had put formula (Sum of column 3 and 4) when form submitted that fifth column response did not count in generating pdf. When response submitted that formula row goes down. Sir Can u help in this problem ?
How can we generate bulk certificates to our drive thru this autocrat.. Without sending mail individually.. Bcos I saw in a webinar they shared drive link in that 500 certificates are there at a single stretch I have searched my name then I get it How it can be done... Kindly explain sir
That is very simple, use Microsoft word mail merge and generate bulk documents and print the final document as pdf file ( say which contains 500 pages) and upload in drive and share the link. Using ilovepdf- we can also split one pdf into 500 single page PDFs.
Hello Sir. Please explain how to send the PDF certificates from a spreadsheet generated from earlier collected credentials but not linked to the Google Forms (as trigger option, as showed in your video).
@@BSReddy.Tech4Trends sir I did that. But how to make sure that the Certificate PDF goes to the same person? How to do that if the Autocrat was not earlier linked to the form.
@@BSReddy.Tech4Trends sir I could make the certificates and download in the drive. But how to send to the Participants automatically, without adding the certificate manually to each email.
very helpful video. My emails are however not getting delivered. It says the message was rejected. This is happening for all email ids. What should I do?
sir, I created the job and was working perfectly but 8 responses were not triggered in between (those responses were recorded at the exact same time), and after that, all responses are triggered. Is there any method to resend the certificates to those whose form responses are not triggered?
If all the responses are stored already, I forgot to add autocrat at initial, now I want send certificates to all them who already took the exam? How can I?
Hello sir, when i try to choose template from drive in the autocrat add-on, it mentions “error: the API developer key is invalid.” How do i solve this problem?
i attended your webinar at IDC chandigarh. I have a query do I have to run atuocrat each time whenever a person/student fills the google form. Didn't it runs automatically each and everytime when someone fills the forms.
sir I am creating certificate and almost process done as given steps by you but I didn't find autocrat folder in my drive there is shown certificate which made by me
It depends on which mail and which subscription you are using. With a free account, one can send 250 mails per day. We have Microsoft mails, through which I can send 10000 mails per day.
Hello Sir I m using certify'm for generating certificate But sir after all the process the name of the certificate is default as Linda kimson But all options are published ok like title What is the solution?
Thank you for the video. I have a query how can we generate certificates automatically if a participant score more than 60% for a quiz and not generate certificates who score less than 60% using autocrat. Is it possible in autocrat
Sir you are a genius!! I searched high and low using Microsoft word and pdf to make this automation happen, but the correct answer is in your video. Thank you so much for your tutorial, really appreciate your work!!
I am a university professor myself and I must say that this video has made my day. I looked for many videos, but this was the most comprehensive one. Thank you sir for your kindness.
Happy to receive such comments. Where are you from professor?
@@BSReddy.Tech4Trends Sikkim Manipal Institute of Technology, Sikkim
@@BibethSharmaSir, is Manipal University good for MBA.
Please suggest.
Very nicely explained sir. I did it simultaneously with your lecture. M so glad that I could generate a certificate myself. Thank you.
Class on this topic is exactly what i wanted to know.
Thank u so much Sir
Best demonstration for Autocrat on internet. thank you very much sir
Thank you for slow and clear explanation sir. It was very useful. I could easily generate certificate .
Thank you, please share with your contacts.
Perfectly explained...👍👍
Those trying to make it on mobile
can carry out things through Google Chrome(desktop site setting)
This is most useful video. Teach in very simple method. Thank you.
Sir I have a problem. One Certificate comes in many times. What is the problem.
Good morning Everyone..Very informative session
Reddy
Sir
..I am Ashima Varghese Asst.Prof
Thank you. It is good video, explains all the features. I was able to make use of this video to generate certificates and share the same by email.
I am surely going to enjoy using LibreOffice and AutoCrat in future. Thank you very much Sir.
Thank you very much it has been very helpful. Your explanation is very clear and easy to understand.
Can we preview the certificate prior to sending them through email.
nice lecture
now it is very convenient for me thanks sir
Dr.Anita
Very Informative and useful session
Thank you so much sir!! You saved my time & each step you taught very briefly 🙌🙌
Thank you sir
Thank You sir for your Clear Explanation.
Thanks brother highly useful🏋♂
Very nice explanation,it is very use ful, thank you sir
Sir first certificate forgot to add in spread sheet now participants are answered & entered what to do sir?
Is there a way to format the date from 8/21/2021 to August 21, 2021. I used the date picker and upon submitting the form, what was recorded is in this format 8/21/2021. How can I set or format the date?
Sr is session me aap kis trha se crtfct bannaya jaata hao wo sikha rahe ho kya autocrate k zrye se??
Your description about generating E-Certificate was clear, could you explain how to edit the generated certificate and send back
th-cam.com/video/KGOPMzERvTk/w-d-xo.html
very clearly explained sir
Hi, thank you so much for the tutorial. I have followed the instructions -but participants are not getting emails. I am missing a step but i just cant figure out where?
Please go though the video once again, still if you are not getting proper, then You send me screenshot of each step to my WhatsApp number 9096077789.
Thank you...though autocrat also stops after around 100 certificates but still it keeps generating certificates in the drive.
Same thing happened with me too now how to send the rest emails.... Please help me out someone please
Same thing happened to me..... no perfect answer from anybody
Very nicely conducted session by you sir
Sir, Did you teach a functional analysis course? I like your complex analysis course.
I taught functional analysis, but doesn't have video lectures. I have my lecture notes, if you want i can share.
Nice session sir.. Very much informative
Thanks for the video sir. Helped me a lot!
You are welcome
Thanku so much for this video 🙏🏻
Autocrat is giving an error message as_ Error: tags fetching failed. Please make sure type in all tags in your template manually. Autocrat wont fetch tags that are from copr and paste.
I dont have any copied tags though. Kindly advise what to do now.
Thank you, SIr, it seems more convenient to use AutoCrat than Certify them.
th-cam.com/video/KGOPMzERvTk/w-d-xo.html
This session is very informative
Excellent sir it is very useful application
Very interesting and useful information
very informative and useful session
Very simple language explain , useful video
Sir plz Make detail Video Certificate ID add ??
very good explanations
Sir I've a doubt. What to do if I don't want to send them emails and only create certificates and transfer them into my folder
For this you can use mail merge from ms word.
!!Error Sending Emails: Service invoked too many times for one day: i am facing this issue in my google sheet which registers response. any idea how can I fix it?
Very useful
Thank you sir
Informative presentation Sir
Informative session and very interesting tool thank u sir
Whenever I want to use Autocrat addon in google sheets, I want to see my official business email sent to client but each time I am seeing my gmail email sent. How can I change it to my official email. I want to send emails to clients from my official email and not from gmail. Please advise.
Madhuri Patil from MIT ,Aurangabad autocrat not launching but open option is observed.
Thankyou for your informative session sir
thank u very much for nicely explained
I have a question that when the tags are in BOLD FONT or ITALICS they show the error of copy & paste. Can you resolve the issue?
Every second of vedio is help full me how to create certificate ,sir will you please share vedio how to design custom certificate tq
Whenever I want to use Autocrat addon in google sheets, I want to see my official business email but each time I am seeing my gmail account. How can I change it to my official email. I want to send emails to clients from my business email through autocrat.
Autocrat works with gmail id only.
informative ...good one
Thanks so much ...really very helpful videos....
Not able to map source data to template, it is just saying that "duplicate merge sheet headers found". Please help me out of this as I cannot type the data of 120 students manually!
Make sure that you have a name for each cell in the header and no cell name is repeated. ( if two cells are empty, it shows the error of duplicate)
Informative session sir
Thank you Sir. Nice explanation
Sir,
I had four columns in google response in fifth column i had put formula (Sum of column 3 and 4) when form submitted that fifth column response did not count in generating pdf. When response submitted that formula row goes down. Sir Can u help in this problem ?
Please send screenshots on 9096077789
but sir, the generated certificate is not delivering to the other email holders other than me, why?
Excellent session thanks
When i am using a spearate google sheet, rather than form, the emails are not sent, please help me with it!
Yes, Sir Autocrat seems more friendly than certify'm.
TypeError: Cannot read property "details" from undefined. why this error are occur
Sir what if i have already created certificate through another software.Please do tell what can be done.Thanks in advance
Sir please explain how to resend the remaining certificates if More than 100
It will be sent automatically after 24 hours
@@BSReddy.Tech4Trends
no sir i am not possible to send remaining certificates
@@ramachandrappabm5900 th-cam.com/video/KGOPMzERvTk/w-d-xo.html
Which formats are accepted for the template??? I can't find a template I put on my Drive :((( What do I do?
pepared using Google slide only
How can we generate bulk certificates to our drive thru this autocrat..
Without sending mail individually..
Bcos I saw in a webinar they shared drive link in that 500 certificates are there at a single stretch I have searched my name then I get it
How it can be done...
Kindly explain sir
That is very simple, use Microsoft word mail merge and generate bulk documents and print the final document as pdf file ( say which contains 500 pages) and upload in drive and share the link. Using ilovepdf- we can also split one pdf into 500 single page PDFs.
Yes sir, it is helpful for us.
Sir in handed created sheet there is no working so please guide.
Very nicely explained
Hello Sir.
Please explain how to send the PDF certificates from a spreadsheet generated from earlier collected credentials but not linked to the Google Forms (as trigger option, as showed in your video).
You can attach Autocrat to any spreadsheet. Just open sheet and apply autocrat from add-ons to that sheet.
@@BSReddy.Tech4Trends
sir I did that. But how to make sure that the Certificate PDF goes to the same person? How to do that if the Autocrat was not earlier linked to the form.
@@BSReddy.Tech4Trends sir I could make the certificates and download in the drive. But how to send to the Participants automatically, without adding the certificate manually to each email.
@@hwm6945 in that excel sheet you might be having email address, so it well be delivered to those mail id
Sir, can you tell me how to generate individual qr codes for each certificate and insert those individuals generated qr codes using autocrat.
th-cam.com/video/KGOPMzERvTk/w-d-xo.html
very helpful video. My emails are however not getting delivered. It says the message was rejected. This is happening for all email ids. What should I do?
Send me some screenshots to understand better.
thank you for the tutorial. it help me lot
Hello sir,yesterday put of 134 students,100 stydents have received the certificate.
34 responses still are pending. How to send them that today
Thank you so much sir. It was of great help🌠
Hello sir , I have already designed certificate how to attach it ?
and print name only on it
Upload that certificate as an image and do the same process as explained.
Very valuable, Thank you sir.
sir, I created the job and was working perfectly but 8 responses were not triggered in between (those responses were recorded at the exact same time), and after that, all responses are triggered. Is there any method to resend the certificates to those whose form responses are not triggered?
On the excel sheet you will see the option of individual record to resend
@@BSReddy.Tech4Trends under wich tab/option sir??
Very useful sir
Informative session
Is there any way that students who have completed the course, only they get the certificates and not everyone with the link for the form?
You create a separate Excel sheet who completed the course and apply autocrat to that Excel sheet
@@BSReddy.Tech4Trends thank you
If all the responses are stored already, I forgot to add autocrat at initial, now I want send certificates to all them who already took the exam?
How can I?
Autocrat can be applied after responses collected also. Watch my video and apply the procedure for already created Google sheet from Google form.
thank you, for this tutorial it's very useful
Thank you for this tutorial!! It's very useful :D
Hello sir, when i try to choose template from drive in the autocrat add-on, it mentions “error: the API developer key is invalid.”
How do i solve this problem?
You can find solution from the following site: kb.blackbaud.com/knowledgebase/Article/105272
Pls Suggest sir, how to resolve this error.
The API developer key is invalid. in Autocrat.
Thank you for nice presentation
i attended your webinar at IDC chandigarh. I have a query do I have to run atuocrat each time whenever a person/student fills the google form. Didn't it runs automatically each and everytime when someone fills the forms.
If you enable form trigger as yes, then they automatically receive the certificate once they submit the form.
sir I am creating certificate and almost process done as given steps by you but I didn't find autocrat folder in my drive
there is shown certificate which made by me
You have to create a folder in drive, with any name, not necessarily autocrat name
I have done sir
thanks for being there
How many emails we can send per day, is there any limit of files it can create and send
It depends on which mail and which subscription you are using. With a free account, one can send 250 mails per day. We have Microsoft mails, through which I can send 10000 mails per day.
Nice presentation
Sir,how to get participants collegename in the certificate
Truly appreciate it!
thank you sir really nice video
Hello Sir
I m using certify'm for generating certificate
But sir after all the process the name of the certificate is default as Linda kimson
But all options are published ok like title
What is the solution?
Hi. Process was interrupted in between how to start again
Very useful video
Good information
Thank you for the video. I have a query how can we generate certificates automatically if a participant score more than 60% for a quiz and not generate certificates who score less than 60% using autocrat. Is it possible in autocrat
very useful video. Thank you.