An Instruction for GAS-070 Google Form Approval System
HTML-код
- Опубликовано: 18 окт 2021
- 💮 about me 🔗 ashtonfei.github.io/
💮 upwork with me 🔗www.upwork.com/workwith/ashto...
🧑🏻💻 automate the boring
#GoogleFormApproval #AppsScript #ApprovalFlow
GAS-070 • GAS-070 A Google Forms...
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/
Thanks a Lot Ashton Fei Sir, it's working fine, and the email template is very intractive.
my side is not working. Can you help me
Great project, thank you so much.
Thx a lot for this awesome project.
Great work
Thank you 😊
Hi Ashton! Thank you for this wonderful tutorial... i was able to make this work thanks to your video. On the other hand is there a way wherein they can attached or provide their digital signature besides clicking the approval? Hoping for your answer and help on this. Thank you very much!
Hello, first off, Ashton, thank you for all you do this is incredible stuff..
I had a colleague get this working beautifully a few weeks ago, but now when I try on my edge browser the links to the “Check Approval Progress” and “Approve or Reject” aren’t working.
It says “Sorry, unable to open file at this time. Please check the address and try again.”
How can I add the button in the third approval and use it to acknowledgment instead of approved?
when i click approve or reject it shows
TypeError: Cannot read properties of null (reading 'getDataRange') (line 85, file "app")
Can the FLOWS have only 1 approver per department? Will any other part need to change? I get an error, "Can not read property ‘forEach’ of undefined at App.onFormSubmit line 228" and again at _onFormSubmit (line 292). Would really appreciate your help
Super...
Thanks Ashton - Fantastic Script and explanation of the features and ideas within. Just wondering if you (or anyone else) has been able to get the FLOW populated from a range on a Sheet rather than hard coded. This would make things a lot easier to update for end users. I have tried, but it's beyond my knowledge...anyone any ideas?
How can I change the subject of email, from Form Name to some value from form responses i.e, for each response its different some thing like respondent name etc.
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?
Hi sir, can I ask I'm having a problem on how to proceed an email for next approver even the previous approver rejected the request?
Can you add a print button when the user opens the form from the mail. So in this way we could print the form. Any help would be appreciated. Thanks in advance.
hi ashton, first of all thank you so much for this tutorial. i've been using this approval system for about a year now and its been going great. but just today i did a mistake of restoring a version history of the excel sheet and i think that messed up the code. now the script editor is not opening up, showing error, and the approval/reject page shows "Not Found". Could you please help me on what I should do please? Right now it's affecting my company's procurement approval and I'm stressing out a lot. I hope you can help me please! Thank you!
Please help! it showing no data found when i clicked on approve or reject from mail
Hi Ashton, I need to add comment in the spread sheet , when the approver is giving comment option. how to change the app script , can u help me in that one please. And one more doubt , after approving all notification mails should go to one particular mail.
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 the only problem is i can approve my own request in the sent item, is there any solutions to that??
Hi thanks for this wonderful work.
I want to know how to create 2 person at same level for approval, where either one can approve.
I have facing issue in approval after click in approve button next screen coming blank also approval status not update in spreadsheet and mail also not trigger for confirmation... Need advice what I can do
This is great. Btw, this project can view in the smartphone? I tried to view the Approval Progress on my phone but said "Sorry, unable to open the file at present". Any settings that can you provide or tip on how can I view on my phone? Thank you in advance God bless
Hi Ashton. Not sure if you are still reading comments. Your script works great by the way. All works with the exception of the second approver. The second approver isn't receiving an email, but I can look at the spreadsheet and see the taskID and pull it up manually. So, all is working with the exception of the second approver not receiving email (the email address is correct, in case asked). Thoughts on how to resolve?
almost work, with error TypeError: Cannot read properties of null (reading 'getDataRange') (บรรทัดที่ 85, ชื่อไฟล์ "app").
Hi thanks this is a great script I am however, not getting an approve reject or comments coming up when trying to approve
How can I embeed a drive file (pdf) so authorizers can view it
Cannot retrieve the next object: iterator has reached the end. (line 74, file "app")
Please help me with this error any one ?
How to add recipient of the approved email?
Now the script cannot be approved. How do I fix it?
Hi Ashton best work but one problem I am send mail in Approved And Reject click Exception: No HTML file named css was found. (line 301, file "app") this show new screen please help this regarding please help
Love you so much for the incredible thing. I need a help that the Approvers are unable to approve or reject it .
showing like - Exception: No HTML file named css was found. (line 306, file "app")
How does web app recognize the authorizer ?
Hi ashton, i can't use this script anymore google developer has blocked it
Hi Aston, why this script can't opened on mobilephone?
Hi Ashton, this is brilliant work. I tried it and it worked seamlessly. Just wanted to ask, is there a mechanism whereby approvers can change based on the amount of Invoice?
I can't send mail, it's error Exception: Failed to send email: no recipient how to fix?
HI NICE SCRIPT BUT IAM NOT GETTING THE APPROVE OR REJECT BUTTON IN THE MAIL.
Hi bro can i get only the answered section into the email
Hi Ashton cool app can you please repost the App and don't let anyone to change the APP, because the app right now is not active, has a lot of errors, can you make a video with step to step how have you create this app and please tell me how to fix the page not found error
thank you
My side is not working. Can you help me
Hi. Thanks a lot for this amazing project. I'm trying to change the form, I added two upload fields. Everything was ok until the third submission, it overwrites the second submission which has been successful (approved). Does the upload field affect the trigger or flow? My problem is the new submission that overwrite the previous submission :(
Up, same here, sometime it overwrite the last submissions.
Observe👀
Great work, thank you. Wondering if an IF/ELSE statement could be added before “const flow = FLOWS[flowKey] || FLOWS.defaultFlow” without breaking the whole thing? Our Email approvers are determined by Department and Location in which I need to add in the location variable.
Up
@@unknown-is1mz Found a workaround, the Flow pulls from the sheet so I changed the Department colomn into an arrayformula that creates a "Flow" code and then added all of those codes to the script. It's not ideal but it works.
@@koonerhospitalitygroup9688 can you share this, I have been looking for a work around as well
@@otunmusa3203 Making the changes to the script was beyond our skills. The workaround we are using is in the response sheet. Who the script emails is based on a value in one of the columns in the response sheet in which we just changed which column the script looks at. Instead the script now looks to a column where we have an arrayformula that creates a code for the submission based on the information submitted in the form. For example if the location field is “Store 1” and the submission type field is “Invoice” then the arrayformula generates the code “SI”. Then in the script we designated that “SI” emails the location manager first, then accounting. It’s not perfect but it gets us closer to what we were hoping for.
Is this still working or I got mistakes during application? 😄
Hi Ashton, i try this project..email approval&reject work fine. But,when i click button "Check Approval Progress" on the email it goes to other page with blank white with word "ReferenceError: approver is not defined (line 12)" please help me 😢
Anyone can help???
Ive done it exactly the way it was shown, step by step. I am not getting the green header in the responses sheet. Something must have changed in the code?
same here
Need Help to remove Error : Exception: Failed to send email: no recipient (line 208, file "app")
make sure every approver have an email address in the flow data.
It's supper great! However, can you help me with two problems after I received Email: 1. The APPROVE/REJECT does not work when I press(It leads me to a NOT PAGE FOUND). 2 The same problem with the button of APPROVE PROGRESS. Thanks a lot!
Just a suggestion, make sure you are running the app in a browser logged in to one google account. I had the same issue. I logged out of all other google accounts and it worked.
same thing it just stops there and white screen.. I tried the above suggestion to use a different browser and have the same problem. Anyone have ideas?
It didn't work for me when I tried to open it on Mac Safari, but it worked when I opened it on Google Chrome with just one account per window.
I have problem TypeError: Cannot read properties of null (reading 'getDataRange') (dòng 85, tệp "app") when click "Check Approval Progress " in email. Anybody have problem same to me, how can to fix it :(
🥲
I'm find a problem. But when _approver_1 ok, _approver_2 have problem "TypeError: Cannot read properties of null (reading 'getDataRange') (dòng 85, tệp "app")". So sad.
Any reason why mails not being received? Debug shows no errors and Deployment was successful. Trigger also setup correctly..
Is the header for email address column is “Email Address”? Case sensitive.
@@ashtonfei Yes.. I Did change not anything except the email addresses as per your tutorial.
this is a very useful and interesting project. when i tried however, it's seem like it works only up to approver 1. after approver 1 click on approve, it show form header and show no record found. the apporver 2 did get email, but when click the form to approve it show page with text no record found. can any one help me to fix this
i believe if i can fix this, this project will be the brilliant one
UP
we you able to resolve this?
Everything is working except for two things. 1. The requester's button "Check Approval Progress" is not working and returns "page not found" (both in desktop and mail mobile version). 2. Mail Mobile version of the approver's button Approve/Reject is not working (page not found). When the approver is using desktop, buttons are working fine. One thing I noticed on the buttons returning "page not found" is that they are accessing the Google drive of the script's owner (which I think is this one). I'm not sure if my observation is right. Still, this approval flow is great. That's the problems I'm encountering. I would like to resolve the mobile version problem since most of the users would be using their smartphone to access the email.
Thanks for your comments.
1. If it's working on the desktop and it should work in the mobile browser.
2. "Page Not Found" basically means the "taskId" or "responseId" was not found in the spreadsheet.
@@ashtonfei Is the responseid or taskid the long string composed of alphanumeric with the header '_response_id' in the spreadsheet? If this is so, I think the sheet has it. Even the copy (nothing changed except for the emails) has the same problem when I tried using it. For some reason, the url has "/u/2/" in between when clicking on the buttons that return Page not found.
@@hrbamapcom6497 check the id in the url. taskId=#####, responseId=#####
@@ashtonfei yep, I checked it. It has taskId (for approval) and responseId for check approval progress. I think this isn't working on Chrome app. I saw a comment from your previous video and tried the suggestion and it works when I tried using a different mobile browser.
Hello, first off, Ashton, thank you for all you do this is incredible stuff..
I’m wondering if this issue was resolved… I had a colleague get this working beautifully a few weeks ago, but now when I try on my edge browser the links to the “Check Approval Progress” and “Approve or Reject” aren’t working.
It says “Sorry, unable to open file at this time. Please check the address and try again.”
Hi Ashton, I can't send mail, it's error Exception: Failed to send email: no recipient how to fix?
When Google Form Generate Google Sheet Column "B1" Header Must Be Change From "Email address" >>>> "Email Address" Then Will Work
@@werapongsaejung6853
thank you
Hello,, sir
Drop down Supply chain at Google form
How I write in app.gs
Supply Chain
Or
SupplyChain
Or
Supply_Chain
Need your advice.. Thanks 🙏🙏
Did you figure this out....need to write supply_chain or something
Exception: Cannot retrieve the next object: iterator has reached the end. Help me please !!
Did you get the solution here? @user-Xn8vt
Hi Ashton , this is a great work , but I have facing issue in approval after click in approve button next screen coming blank
in js.html change the value approveButton to "approvebutton" all lower case
Hi Can you please let me know how cam i get the Reset UID addon !!! i have copied as it is but still i cannot able to see the reset UID addon !!
Seems like the script not working anymore? After approved or rejected its going to blank page and not update the sheet leh
ok I figure it out, the script copy from link above got issue in js.html file, there is a typo just correct it then able to works
const approveButto -> const approveButton (there is 'n' typo)
@@thanhchinhban3488 Is it possible if I need your help to check?
please help :(
After I add the missing n in the js.html file. I still can not get the approval working.
@Thanh Chinh Ban @ashton Fei. Can you guys help on on the js.html? I got the same issue. After approved or rejected its going to blank page and not update the sheet
For the people who can't receive the email(Exception: Failed to send email: no recipient):
Please check the header in cell B1, make sure it's "Email address" with the correct case. Since the script uses it as a key to find the respondent's email.
Thank you so much
Hi Ashton, thanks so much for this video. Just to help anyone with this issue, make sure its "Email Address" and not "Email address" in the response sheet.
Hi, Ashton Please help
how to remove your signature?
Search my signature in the HTML file and remove them or replace with your own signature.
@@ashtonfei yes i did and removed, but the thing is it is still appearing in the Final Approval Email send to the requester, i gone through all the single line of code i did get so asking you..
Thank you
But there is a problem that a message is not delivered to the email
Note that the e-mail data in the program file has been changed, but to no avail
The mail has also been changed, same problem
No sure if I get your point. Did you make some changes in the email body?
@@ashtonfei I did all the previous steps exactly
But I did not receive an email for approval
@@turkialmajed5608 did you checked your sent box?
@@ashtonfei yes
@@ashtonfei welcome
I have a problem ( Exception: Failed to send email: no recipient )
Cannot retrieve the next object: iterator has reached the end. (line 74, file "app")
Please help me with this error any one ?
@ashton
Hi, thanks for your work, it's great!!
My boss ask me to save paper find a way to replace a simple approval "paper" form, this totally helped me.
But i want to get some advice.
I tried with my google account to host the form, everything work fine. Me and my colleague can approve the form.
And I do it again on my working account. my colleague can approve the form, but i can't. it shown i cannot access the file.
the different between my colleague and i is: their chrome only have one google account. my chrome have 3.
is there any solution on this?
And share some experiences:
1, Click approve button goto white blank page.
- it may caused by the js.html file. "const approveButton = document.getElementById("approve")"
- the second words "approveButto" -> change to -> "approveButton". may solve the problem
2, Excel file not have those "Green header" column /not send email
- it may caused by the app.gs
- few lines related:
----> this.sheetname = "Form Responses 1"
----> this.emailHeader = "Email Address"
----> const spreadsheet = SpreadsheetApp.create(this.title + " (Responses)")
- because of your google default language is not english, the related wording maybe different.
- you may change the "Spreadsheet file name", "Sheet name", "column name", or the related code to solve it
Finally, really thanks for your works, it helped me a lot.
Hi Ashton. I copied everything without changing code only the emails and it seemed to work fine up until doing approval/decline from email. Once you take an action it results to a white screen and redirected to a new page with this url --- alot of text then scrip.userCodeAppPanel?.. Can you please tell me what I did wrong?
did you resolve this issue because I'm stuck with the same issue
Try using other web browser...i have the same issue when i used it in my mobile phone. But when i try using other web browser in my phone it works. Hope it helps...
FYI, for the white screen issue there is another comment above where the solution was provided. Its a typo in the code.
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 copied everything without changing code only the emails and it seemed to work fine up until doing approval/decline from email. Once you take an action it results to a white screen and redirected to a new page with this url --- a lot of text then scrip.userCodeAppPanel?.. Can you please tell me what I did wrong?
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.
Is there a limit for sending responses a day ?