GAS-070 A Google Forms Approval System Built with Apps Script
💮 about me 🔗 ashtonfei.github.io/
💮 upwork with me 🔗www.upwork.com/workwith/ashto...
🧑🏻💻 automate the boring
#GoogleFormApproval #AppsScript #ApprovalFlow
Check this instruction if you can't make it working
• An Instruction for GAS...
I forgot to mention in the video. You can reset the uid by using the reset uid function in the Form addon.
Copy the script file to your drive
docs.google.com/forms/d/10GCs...
Source code:
github.com/ashtonfei/google-a...
Apps Script Support:
goo.gl/forms/GhJC63annAtIsif72
Github repo: github.com/ashtonfei/google-a...
Gmail: yunjia.fei@gmail.com
Upwork: ashton_fei
Twitter: / ashton_fei
Instagram: / ashton.fei
Buy me a beer: www.paypal.me/ashtonfei/
Пікірлер: 125
Love it sir,🤩🤩🤩
Thank you so much
@amgaulziisuren7236
2 жыл бұрын
I solved the problem. because this is appscript not working. If you want me to help you, write to me.
Regarding the FLOWS; Can you you have only one approver per department? and how would this look like please?
Hi, is it possible to generate a pdf file after the status columns changes to approved and save it in according folders for departments?
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.
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?
Number one.
Nice
How do you add approvals to edits made to already existing responses?
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?
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?
Do you have one that is made in Google App Script using HTML Form instead of Google Form?
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?
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
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")
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
@amgaulziisuren7236
2 жыл бұрын
I solved the problem. because this is appscript not working. If you want me to help you, write to me.
Hi sir apps script not working actually run but _udl,_states , another not attached response 1 sheet please help this concept
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.
@jiratest3585
2 жыл бұрын
any idea to sort this out
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
3 жыл бұрын
Yes. It's possible to do that in the spreadsheet, but the script needs update accordingly.
@Enrique-dTraveller
3 жыл бұрын
@@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.
@user-ev5pc4fv3t
11 ай бұрын
@@Enrique-dTraveller - I am trying to achieve this also (2 years later) did you get a working example you could share? 🤞
Hi Ashon, can you make a video on how to do a parallel multi level form approval? A bunch of 'ones'
@ashtonfei
2 жыл бұрын
Hi Calvin. Not sure if I understand the parallel multiple level approval flow correctly. Would you mind to give me an example?
@ngcalvinutomo96
2 жыл бұрын
@@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.
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..???
@ramonvila1594
2 жыл бұрын
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?
How to remove your signature and promotion?
Please help me with this error after clicking on "Approved"
Hi Aston, is it possible to add second flow and where we must declare about this second flow
@jerylgonsalves7037
Жыл бұрын
Hi, were you able to add a second flow?
Cannot retrieve the next object: iterator has reached the end. (line 74, file "app") Please help me with this error any one ?
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!
@muhammadkhairi8243
2 жыл бұрын
yups, i've same problem
@tristanfontanilla9117
Жыл бұрын
Hi were you able to solve the issue on this? i have the same problem. Thanks!
@koonerhospitalitygroup9688
Жыл бұрын
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 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
@listachequeo1850
3 жыл бұрын
Friend, I solved the problem. If you want me to help you, write to me.
@mis6068
2 жыл бұрын
@@listachequeo1850 please help
@indevicd2545
2 жыл бұрын
@@listachequeo1850 Sir Mail is not coming please help
@ashtonfei
2 жыл бұрын
kzread.info/dash/bejne/fqtp2q2xlZvAh6Q.html check my latest video if you still make it working.
How does it authenticate the user, can anyone recreate the link and access the authorization page
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 😥
@ashtonfei
2 жыл бұрын
kzread.info/dash/bejne/fqtp2q2xlZvAh6Q.html check my latest video.
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
3 жыл бұрын
Sorry. This is not possible for free users. developers.google.com/apps-script/guides/services/quotas#current_quotas
@turkialmajed5608
2 жыл бұрын
@@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
how to setup dynamic approve?
when first approval approve the leave, the status at excel show rejected instead of approved. try many times, but still rejected. why?
@amgaulziisuren7236
2 жыл бұрын
I solved the problem. because this is appscript not working. If you want me to help you, write to me.
Bro we add outlook mail id its not working bro please help
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
@anthonyroberts3476
2 жыл бұрын
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
@ashtonfei
3 жыл бұрын
If you changed my original header for them you need to update them in the script accordingly.
Hi Mr. Ashton, is there a possible to include follow up email on pending requests that has not been approved or pending for 3days?
@jerylgonsalves7037
11 ай бұрын
Hi, were you able to figure this out?
@naviyerolpmet826
11 ай бұрын
@@jerylgonsalves7037 no, I tried but it won't work
@jerylgonsalves7037
11 ай бұрын
@@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?
@naviyerolpmet826
11 ай бұрын
@@jerylgonsalves7037 yup, after 3 days of being pending. It should send an email for a follow notice
@jerylgonsalves7037
11 ай бұрын
@@naviyerolpmet826 yeah want the same format
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
3 жыл бұрын
Ya lo solucione 😄
@llorers
3 жыл бұрын
@@MrLococaco Como lo hicistes??
@llorers
2 жыл бұрын
@@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.
@ashtonfei
2 жыл бұрын
kzread.info/dash/bejne/fqtp2q2xlZvAh6Q.html check my latest video if you still can't make it working.
@listachequeo1850
2 жыл бұрын
@Dusan Todorovic Hola, pudiste resolver el problema?
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?
@jalalkia-gi8vl
3 ай бұрын
definitely. we perform it in our firm
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
3 жыл бұрын
What's you email address, maybe the email was sent to me. I received several emails from different people.
@patrickcarmans2940
3 жыл бұрын
@@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
@ashtonfei
3 жыл бұрын
Didn’t find it, maybe you can check your sent folder.
@listachequeo1850
3 жыл бұрын
Hello, were you able to find the problem? Greetings from Chile
@MrLococaco
3 жыл бұрын
@Gizem Nur Muratoglu Hello, were you able to find the problem of sending emails and green cells? Greetings from Chile
This is great, working fine with windows, but when trying to approve on Android this is not working, did I missed something?
@ashtonfei
3 жыл бұрын
sorry, I don’t have an android device. Did u see any error messages?
@sularambon9792
3 жыл бұрын
@@ashtonfei the page display this message: Sorry, unable to open the file at present. Please check the address and try again.
@sularambon9792
3 жыл бұрын
FYI It's working on Android phone build in browser (not working with chrome app on Android) 😬
Is there any way of bulk approval..?
@jerylgonsalves7037
11 ай бұрын
Hi, were you able to figure this out?
Dear Sir Ashton, if we want some pictures / images also embedded into email, how to do that ? thanks in advance
@ashtonfei
3 жыл бұрын
You can use tag to add it to your email html body.
hi i have getting error page not found pls help me Anshton Fei
@listachequeo1850
3 жыл бұрын
Hello, were you able to find the problem? Greetings from Chile
hi, how do you reset the UID?
@victorhugogarcia9662
11 ай бұрын
ejecuta la función resetUid desde app script
Hey which is the correct script for this integration
@ashtonfei
10 ай бұрын
To many copies, try the source code here. github.com/ashtonfei/google-apps-script-projects/tree/GAS-070
@michaelsglas
10 ай бұрын
@@ashtonfei thanks will get to it now
Dear Sir, very nice code,. Can you provide the code to us. Thanks in advance.
@amgaulziisuren7236
2 жыл бұрын
I solved the problem. because this is appscript not working. If you want me to help you, write to me.
@indevicd2545
2 жыл бұрын
@@amgaulziisuren7236 Dear sir we want code please help me sir
@elsonguila
Жыл бұрын
@@amgaulziisuren7236, can I have your email/contact?
Hi Sir, It is showing syntax error this.sheet
@mis6068
2 жыл бұрын
Please Help
@ashtonfei
2 жыл бұрын
Is “this.sheet” the entire message?
@mis6068
2 жыл бұрын
@@ashtonfei Thanks for your prompt reply sir, "Syntax error: Syntax error. line: 66 file: app"
how to use only 1 level approval ?
@ashtonfei
2 жыл бұрын
You can update the approvers in the data flow. For one level, you only need to have one approver in the approvers' list.
@agungramadhana2025
2 жыл бұрын
@@ashtonfei just let it blank or delete ?
@ashtonfei
2 жыл бұрын
@@agungramadhana2025 delete
Its not working no emails sent after submit form
@listachequeo1850
3 жыл бұрын
Hello, were you able to find the problem? Greetings from Chile
@shubhammangal330
3 жыл бұрын
@@listachequeo1850 i just copy code and change emails with my own emails but nothing happens
@listachequeo1850
3 жыл бұрын
@@shubhammangal330 I did the same from the video but nothing happens
@listachequeo1850
3 жыл бұрын
Friend, I solved the problem. If you want me to help you, write to me.
@erikhectorcruzcoronel7394
3 жыл бұрын
@@listachequeo1850 friend, how did you solve the problem, I can't send or receive emails with the script
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