Great project, thank you so much.

Thx a lot for this awesome project.

Thanks a Lot Ashton Fei Sir, it's working fine, and the email template is very intractive.

@patipahnlaejunkham1154

Ай бұрын

my side is not working. Can you help me

Great work

Thank you 😊

Super...

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!

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?

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?

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?

@thaimetaltechtmc2238

2 жыл бұрын

I can't send mail, it's error Exception: Failed to send email: no recipient how to fix?

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.”

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.

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, 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!

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

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 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 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 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?

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")

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 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?

Please help! it showing no data found when i clicked on approve or reject from mail

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

Hi the only problem is i can approve my own request in the sent item, is there any solutions to that??

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 :(

@aripresensi9298

2 жыл бұрын

Up, same here, sometime it overwrite the last submissions.

@ConsulthinkProgrammer

2 жыл бұрын

Observe👀

How to add recipient of the approved 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

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

HI NICE SCRIPT BUT IAM NOT GETTING THE APPROVE OR REJECT BUTTON IN THE MAIL.

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.

@unknown-is1mz

Жыл бұрын

Up

@koonerhospitalitygroup9688

Жыл бұрын

@@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.

@otunmusa3203

Жыл бұрын

@@koonerhospitalitygroup9688 can you share this, I have been looking for a work around as well

@koonerhospitalitygroup9688

Жыл бұрын

@@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.

How can I embeed a drive file (pdf) so authorizers can view it

almost work, with error TypeError: Cannot read properties of null (reading 'getDataRange') (บรรทัดที่ 85, ชื่อไฟล์ "app").

Cannot retrieve the next object: iterator has reached the end. (line 74, file "app") Please help me with this error any one ?

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 😢

@GamerNearby

Жыл бұрын

Anyone can help???

How does web app recognize the authorizer ?

Now the script cannot be approved. How do I fix it?

Hi ashton, i can't use this script anymore google developer has blocked it

Hi bro can i get only the answered section into the email

Hi Aston, why this script can't opened on mobilephone?

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?

@ashishkarki9090

Жыл бұрын

same here

My side is not working. Can you help me

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.

@ashtonfei

2 жыл бұрын

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.

@hrbamapcom6497

2 жыл бұрын

@@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.

@ashtonfei

2 жыл бұрын

@@hrbamapcom6497 check the id in the url. taskId=#####, responseId=#####

@hrbamapcom6497

2 жыл бұрын

@@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.

@ObmalObmaj

Жыл бұрын

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.”

Is this still working or I got mistakes during application? 😄

Need Help to remove Error : Exception: Failed to send email: no recipient (line 208, file "app")

@ashtonfei

2 жыл бұрын

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!

@CA-wc4zr

2 жыл бұрын

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.

@dukhagaming1788

2 жыл бұрын

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?

@_helloliyana

Жыл бұрын

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.

Hi Ashton , this is a great work , but I have facing issue in approval after click in approve button next screen coming blank

@channellegend

Жыл бұрын

in js.html change the value approveButton to "approvebutton" all lower case

Any reason why mails not being received? Debug shows no errors and Deployment was successful. Trigger also setup correctly..

@ashtonfei

2 жыл бұрын

Is the header for email address column is “Email Address”? Case sensitive.

@jean-pierrebruwer664

2 жыл бұрын

@@ashtonfei Yes.. I Did change not anything except the email addresses as per your tutorial.

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.

@dshoangviet

2 жыл бұрын

Thank you so much

@_helloliyana

Жыл бұрын

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.

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

@otunmusa3203

Жыл бұрын

UP

@otunmusa3203

Жыл бұрын

we you able to resolve this?

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 🙏🙏

@NaveenKumar-eh6fm

2 жыл бұрын

Did you figure this out....need to write supply_chain or something

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 :(

@signarthoadon

Жыл бұрын

🥲

@tungnguyenhoang7098

Жыл бұрын

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.

Exception: Cannot retrieve the next object: iterator has reached the end. Help me please !!

@user-iy8dk5jr3b

5 ай бұрын

Did you get the solution here? @user-Xn8vt

Hi Ashton, I can't send mail, it's error Exception: Failed to send email: no recipient how to fix?

@werapongsaejung6853

2 жыл бұрын

When Google Form Generate Google Sheet Column "B1" Header Must Be Change From "Email address" >>>> "Email Address" Then Will Work

@thaimetaltechtmc2238

2 жыл бұрын

@@werapongsaejung6853 thank you

Hi, Ashton Please help

Seems like the script not working anymore? After approved or rejected its going to blank page and not update the sheet leh

@thanhchinhban3488

2 жыл бұрын

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)

@thaimetaltechtmc2238

2 жыл бұрын

@@thanhchinhban3488 Is it possible if I need your help to check?

@rowellvillanueva241

2 жыл бұрын

please help :(

@mxbao1690

2 жыл бұрын

After I add the missing n in the js.html file. I still can not get the approval working.

@mxbao1690

2 жыл бұрын

@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

how to remove your signature?

@ashtonfei

2 жыл бұрын

Search my signature in the HTML file and remove them or replace with your own signature.

@yarraramu4774

2 жыл бұрын

@@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..

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 !!

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.

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

@ashtonfei

2 жыл бұрын

No sure if I get your point. Did you make some changes in the email body?

@turkialmajed5608

2 жыл бұрын

@@ashtonfei I did all the previous steps exactly But I did not receive an email for approval

@ashtonfei

2 жыл бұрын

@@turkialmajed5608 did you checked your sent box?

@turkialmajed5608

2 жыл бұрын

@@ashtonfei yes

@turkialmajed5608

2 жыл бұрын

@@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 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?

@hakodak

2 жыл бұрын

did you resolve this issue because I'm stuck with the same issue

@tristanfontanilla9117

2 жыл бұрын

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...

@koonerhospitalitygroup9688

2 жыл бұрын

FYI, for the white screen issue there is another comment above where the solution was provided. Its a typo in the code.

@koonerhospitalitygroup9688

2 жыл бұрын

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?

@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.

Is there a limit for sending responses a day ?