this is exactly what I need, with the exception of it using a form and I would rather have it be HTML based so I can modify it a little more detailed. any pointers on doing that?
Hi Ashton Fei, very nice app which very useful for HR team, but when i submit the form no one in the Department group is getting email.... if you could explain that would be a great support
Hello, I did everything you indicate. 1) I make a copy of the form. 2) I edit the script with my emails 3) I update the url, copy and paste the created ur in the script. 4) I test the same form without changing anything. Green headers are not created on the spreadsheet. I do not send or receive any mail. (script does not run). note: I use google in Spanish. you can help?
@@MrLococaco por favor Fabián me puedes ayudar para saber donde puede estar el fallo para que no me funcione el envío de mails? Muchas gracias de antemano.
Buenas tardes, Ahora en ingles he visto que funciona el tema de los mails. Sin embargo, Auqnue le des a REJECT siempre procesa como si hubiera aproved. Qué puede ser? If i press reject the process is like aprroved..???
Cuando le doy a Reject llama a la function Approve en lugar de la función reject...When i press Reject the process tigger is open is approve... no Reject... What is the problem?
Thanks for script. Working efficiently. Is there any method to make the flow script get from spreadsheet? So if there's any changes of approval level or person, only change at the spreadsheet rather than make changes in the script? Appreciate your reply and many thanks.
@@ashtonfei Thanks for the reply. Is it the whole script need to do changes or that flow portion only? I'm still trying actually but no success so far.
Mr Ashton Fei, can you help me how to change "Email Subject" from (const subject = "Approval Required - " + this.title) to only UID number? Thank you for your help.
Sorry, unable to open the file at this time. Please check the address and try again. getting This error when trying to approve/reject request from mail
Hello, I did everything you indicate. 1) I make a copy of the form. 2) I edit the script with my emails 3) I update the url, copy and paste the created ur in the script. 4) I test the same form without changing anything. Green headers are not created on the spreadsheet. I do not send or receive any mail. (script does not run). Please help me 😥
Really like the selection and the code behind this that allow the user to pick one category and then it send to the approver for response. Can we have where a person does multiple selections for choices. I have this condition right now where I just need to work on the users selection has to be multiple groups and then have it sent in the background to the approvers. Would like to get assistance in the design. Thanks
Hi Ashton , thanks for the video. I have got the mail for approval but the thing is that when i click approve or check approval , it is coming as no record found ...any idea how to troubleshoot that.
good day, thank you so much for this great project. However, I have a question. I followed your steps and everything is okay except when i pressed the approve and reject buttons the screen turn blank and the status is still pending. Hope there's a way around it. Thank you so much!
I cannot recall which user in the comments section provided the following solution but it worked for me. There was a typo in the js.html. The approveButto needs to be changed to approvedButton. The "n" was missing. Then you will need to redeploy the web app.
I get permission errors when I try to run this. It is fine with my account, and anyone I send it to can submit the form, but I run into issues when it gets to the approvers. When they click "approve" or "deny", they receive the following error, "Exception: No item with the given ID could be found. Possibly because you have not edited this item or you do not have permissions to access it. (Line 115, file "app"). How do I fix this? @ashtonfei
@@naviyerolpmet826 okay, if you ever get a solution do comment. If I get it too, il let you know. Just wanted to confirm that you wanted to send in the same email automatically if the req is pending for 3 days right?
@@ashtonfei Hi Ashton, I would mean an exit clearance check. Example in an employee resigning and needing multiple processes to be done: 1. Exit Survey with HR 2. IT Assets Deliverables with IT 3. Handover with Manager, and so forth. The one mentioned in GAS-070 needs the actions before to be done, can we have the 3 mentioned before running parallel/at the same time.
Great work thank you very much I need your help pleas about this log (Exception: Service invoked too many times for one day ) how i can make it send more emails per day
@@ashtonfei Hello, I did everything you indicate. 1) I make a copy of the form. 2) I edit the script with my emails 3) I update the url, copy and paste the created ur in the script. 4) I test the same form without changing anything. Green headers are not created on the spreadsheet. I do not send or receive any mail. (script does not run). Please help me
Hi Ashton Fei, very nice app.... but when i submit the form no one is getting email.... I did all changes (email in Flows and the updated web app url after deplo) if you could explain that would be a great support
@@ashtonfei patrick.carmans@uhasselt.be Initialy I forgot to change your email into mine in the flow (script) but now I changed to my email and still not receiving anything
this is exactly what I need, with the exception of it using a form and I would rather have it be HTML based so I can modify it a little more detailed. any pointers on doing that?
Number one.
Love it sir,🤩🤩🤩
Hello! Not sure if you're still seeing comments. Is it possible to reassign the approval to another person if the approver is not available?
Hi Ashton Fei, very nice app which very useful for HR team, but when i submit the form no one in the Department group is getting email.... if you could explain that would be a great support
Friend, I solved the problem. If you want me to help you, write to me.
@@listachequeo1850 please help
@@listachequeo1850 Sir Mail is not coming please help
ua-cam.com/video/Lw5xKxe8ZWA/v-deo.html
check my latest video if you still make it working.
hye, script working really good!! tq for sharing it. but could u guide me on how to hide unanswered columns from going in the email for approval?
Please help me with this error after clicking on "Approved"
Regarding the FLOWS; Can you you have only one approver per department? and how would this look like please?
Hello, I did everything you indicate. 1) I make a copy of the form. 2) I edit the script with my emails 3) I update the url, copy and paste the created ur in the script. 4) I test the same form without changing anything. Green headers are not created on the spreadsheet. I do not send or receive any mail. (script does not run). note: I use google in Spanish. you can help?
Ya lo solucione 😄
@@MrLococaco Como lo hicistes??
@@MrLococaco por favor Fabián me puedes ayudar para saber donde puede estar el fallo para que no me funcione el envío de mails? Muchas gracias de antemano.
ua-cam.com/video/Lw5xKxe8ZWA/v-deo.html
check my latest video if you still can't make it working.
@Dusan Todorovic Hola, pudiste resolver el problema?
Buenas tardes,
Ahora en ingles he visto que funciona el tema de los mails. Sin embargo, Auqnue le des a REJECT siempre procesa como si hubiera aproved. Qué puede ser?
If i press reject the process is like aprroved..???
Cuando le doy a Reject llama a la function Approve en lugar de la función reject...When i press Reject the process tigger is open is approve... no Reject... What is the problem?
Thanks for script. Working efficiently. Is there any method to make the flow script get from spreadsheet? So if there's any changes of approval level or person, only change at the spreadsheet rather than make changes in the script? Appreciate your reply and many thanks.
Yes. It's possible to do that in the spreadsheet, but the script needs update accordingly.
@@ashtonfei Thanks for the reply. Is it the whole script need to do changes or that flow portion only? I'm still trying actually but no success so far.
@@Enrique-dTraveller - I am trying to achieve this also (2 years later) did you get a working example you could share? 🤞
Cannot retrieve the next object: iterator has reached the end. (line 74, file "app")
Please help me with this error any one ?
Hi After the Manager approves before submitting to the President for approval conditions for more than 2 hours for the chairman to sign? how to fix?
Mr Ashton Fei, can you help me how to change "Email Subject" from (const subject = "Approval Required - " + this.title) to only UID number? Thank you for your help.
Thank you so much
I solved the problem. because this is appscript not working. If you want me to help you, write to me.
Sorry, unable to open the file at this time.
Please check the address and try again.
getting This error when trying to approve/reject request from mail
Hi, is it possible to generate a pdf file after the status columns changes to approved and save it in according folders for departments?
Hello, I did everything you indicate. 1) I make a copy of the form. 2) I edit the script with my emails 3) I update the url, copy and paste the created ur in the script. 4) I test the same form without changing anything. Green headers are not created on the spreadsheet. I do not send or receive any mail. (script does not run). Please help me 😥
ua-cam.com/video/Lw5xKxe8ZWA/v-deo.html
check my latest video.
Hi sir apps script not working actually run but _udl,_states , another not attached response 1 sheet please help this concept
I cannot able to get the UID button addon can you please let me know how can i do it !!!
Need Help to remove Error : Exception: Failed to send email: no recipient (line 208, file "app")
Do you have one that is made in Google App Script using HTML Form instead of Google Form?
How do you add approvals to edits made to already existing responses?
how to setup dynamic approve?
Really like the selection and the code behind this that allow the user to pick one category and then it send to the approver for response. Can we have where a person does multiple selections for choices. I have this condition right now where I just need to work on the users selection has to be multiple groups and then have it sent in the background to the approvers. Would like to get assistance in the design. Thanks
I solved the problem. because this is appscript not working. If you want me to help you, write to me.
Hi Ashton , thanks for the video. I have got the mail for approval but the thing is that when i click approve or check approval , it is coming as no record found ...any idea how to troubleshoot that.
any idea to sort this out
good day, thank you so much for this great project. However, I have a question. I followed your steps and everything is okay except when i pressed the approve and reject buttons the screen turn blank and the status is still pending. Hope there's a way around it. Thank you so much!
yups, i've same problem
Hi were you able to solve the issue on this? i have the same problem. Thanks!
I cannot recall which user in the comments section provided the following solution but it worked for me. There was a typo in the js.html. The approveButto needs to be changed to approvedButton. The "n" was missing. Then you will need to redeploy the web app.
Hi Aston, is it possible to add second flow and where we must declare about this second flow
Hi, were you able to add a second flow?
How to remove your signature and promotion?
How does it authenticate the user, can anyone recreate the link and access the authorization page
I get permission errors when I try to run this. It is fine with my account, and anyone I send it to can submit the form, but I run into issues when it gets to the approvers. When they click "approve" or "deny", they receive the following error, "Exception: No item with the given ID could be found. Possibly because you have not edited this item or you do not have permissions to access it. (Line 115, file "app"). How do I fix this? @ashtonfei
Hi Mr. Ashton, is there a possible to include follow up email on pending requests that has not been approved or pending for 3days?
Hi, were you able to figure this out?
@@jerylgonsalves7037 no, I tried but it won't work
@@naviyerolpmet826 okay, if you ever get a solution do comment. If I get it too, il let you know. Just wanted to confirm that you wanted to send in the same email automatically if the req is pending for 3 days right?
@@jerylgonsalves7037 yup, after 3 days of being pending. It should send an email for a follow notice
@@naviyerolpmet826 yeah want the same format
Nice
Hi Ashon, can you make a video on how to do a parallel multi level form approval? A bunch of 'ones'
Hi Calvin. Not sure if I understand the parallel multiple level approval flow correctly. Would you mind to give me an example?
@@ashtonfei Hi Ashton, I would mean an exit clearance check. Example in an employee resigning and needing multiple processes to be done:
1. Exit Survey with HR
2. IT Assets Deliverables with IT
3. Handover with Manager, and so forth.
The one mentioned in GAS-070 needs the actions before to be done, can we have the 3 mentioned before running parallel/at the same time.
when first approval approve the leave, the status at excel show rejected instead of approved. try many times, but still rejected. why?
I solved the problem. because this is appscript not working. If you want me to help you, write to me.
Hi, is it possible to send the approval approved emails to the approver and also to a default email ID? If possible, can you share the code?
definitely. we perform it in our firm
When I submit everything works fine but when the approver opens the file to approve there is no approve/reject button or comments......pls help
Any help with this at all?
In my spreadsheet _uid,_Status is not reflecting and do we need to run any software to run the appscript
If you changed my original header for them you need to update them in the script accordingly.
Bro we add outlook mail id its not working bro please help
Great work thank you very much
I need your help pleas about this log (Exception: Service invoked too many times for one day ) how i can make it send more emails per day
Sorry. This is not possible for free users. developers.google.com/apps-script/guides/services/quotas#current_quotas
@@ashtonfei Hello, I did everything you indicate. 1) I make a copy of the form. 2) I edit the script with my emails 3) I update the url, copy and paste the created ur in the script. 4) I test the same form without changing anything. Green headers are not created on the spreadsheet. I do not send or receive any mail. (script does not run). Please help me
Its not working no emails sent after submit form
Hello, were you able to find the problem?
Greetings from Chile
@@listachequeo1850 i just copy code and change emails with my own emails but nothing happens
@@shubhammangal330 I did the same from the video but nothing happens
Friend, I solved the problem. If you want me to help you, write to me.
@@listachequeo1850
friend, how did you solve the problem, I can't send or receive emails with the script
Hi Ashton Fei, very nice app.... but when i submit the form no one is getting email.... I did all changes (email in Flows and the updated web app url after deplo) if you could explain that would be a great support
What's you email address, maybe the email was sent to me. I received several emails from different people.
@@ashtonfei patrick.carmans@uhasselt.be Initialy I forgot to change your email into mine in the flow (script) but now I changed to my email and still not receiving anything
Didn’t find it, maybe you can check your sent folder.
Hello, were you able to find the problem?
Greetings from Chile
@Gizem Nur Muratoglu Hello, were you able to find the problem of sending emails and green cells?
Greetings from Chile
Hey which is the correct script for this integration
To many copies, try the source code here.
github.com/ashtonfei/google-apps-script-projects/tree/GAS-070
@@ashtonfei thanks will get to it now
hi, how do you reset the UID?
ejecuta la función resetUid desde app script
This is great, working fine with windows, but when trying to approve on Android this is not working, did I missed something?
sorry, I don’t have an android device. Did u see any error messages?
@@ashtonfei the page display this message: Sorry, unable to open the file at present.
Please check the address and try again.
FYI
It's working on Android phone build in browser (not working with chrome app on Android)
😬
Is there any way of bulk approval..?
Hi, were you able to figure this out?
hi i have getting error page not found pls help me Anshton Fei
Hello, were you able to find the problem?
Greetings from Chile
Hi Sir,
It is showing syntax error this.sheet
Please Help
Is “this.sheet” the entire message?
@@ashtonfei Thanks for your prompt reply sir,
"Syntax error: Syntax error. line: 66 file: app"
how to use only 1 level approval ?
You can update the approvers in the data flow. For one level, you only need to have one approver in the approvers' list.
@@ashtonfei just let it blank or delete ?
@@agungramadhana2025 delete
Dear Sir Ashton,
if we want some pictures / images also embedded into email, how to do that ?
thanks in advance
You can use tag to add it to your email html body.
Dear Sir, very nice code,.
Can you provide the code to us.
Thanks in advance.
I solved the problem. because this is appscript not working. If you want me to help you, write to me.
@@amgaulziisuren7236 Dear sir we want code please help me sir
@@amgaulziisuren7236, can I have your email/contact?