GAS-086 Build an Approval System via Apps Script & Google Sheets
🔗 💮 about me 🔗 onescript.work/about
💮 upwork with me 🔗www.upwork.com/workwith/ashto...
🧑🏻💻 automate the boring
#approval #webapp #googleappsscript
🔗 demo app
script.google.com/macros/s/AK...
email: admin@gmail.com, password: admin
chapters
Start [00:00:00]
Intro [00:00:14]
Login to System [00:01:00]
Create User [00:02:01]
Delete User [00:02:51]
Update User [00:03:50]
Send a Request [00:05:57]
Approve a Request [00:09:47]
Reject a Request [00:10:09]
Forward a Request [00:10:26]
Update Roles and Titles [00:21:58]
End [00:26:37]
🔗 make a copy
docs.google.com/spreadsheets/...
🔗 source code
github.com/ashtonfei/google-a...
🔗 repo live-coding
github.com/ashtonfei/live-cod...
🔗 repo google-apps-script-projects
github.com/ashtonfei/google-a...
🔗 repo gas-libs
github.com/ashtonfei/gas-libs/
🔗 gmail
yunjia.fei@gmail.com
🔗 upwork Freelancer
www.upwork.com/freelancers/~0...
🔗 twitter
/ ashton_fei
🔗 instagram
/ ashton.fei
🔗 buy me a beer
www.paypal.me/ashtonfei/
Пікірлер: 37
Since the release of Vue 3, some CDN links for vuex and vue-router are not compatible with Vue 2. I've udpated the links and you should be able to use the demo app now. If you have problem to access to login page, please make a copy of my latest script.
This is amazing my friend. The only thing I would add is a file upload or "Add attachments" option. In many cases, a file or document is what needs approval. Just a thought.. great work!
Great work! Thanks!
Thank you very much for uploading great contents .
Thank you so much sir. It is a very valuable share from you. To be honourable if I also become like you to share everything for everybody free.
Thank you Sir ,
It's a cleanest webapp i have ever seen. Soo much learning from you. Just thinking below possibilities to enhance the webapp. 1. Is that possible to add a table to the request. 2. On request the mail should trigger to approver with all thr table details. 3. Where approver should have dynamic button to approve/rejected in email itself. OR he reply to the same email and it should capture. I know these need next level of enhancement. Just added my thought here. As I have seen approval flow earlier from you it is similar. GREAT WORK 👏👏👏👏 and thank you soo much .💐
Greater than others
👍💚
I think Admin has the right to delete items that have been created. Edit password for user. Thank you. Your project is great
Thanks Ashton this is awesome. Where can I change it on the code so that the approvers will also see the History of their actions? Is it possible. Current version of history is only saved for the creator of the approval request.
When your google sheet copy Then click script Then deploy URL not working Please upload new script google sheet
If I want to send an email alert to the users such asTask creators and Assigned To Users with a message " There is an update to your Approval List" where should I do the editing in the script?
Would you help me, there is an error when running this application "RangeError: Maximum call stack size exceeded (line 323, file "backend")"
That's great, but I want additional files in form. Can you guide me how to do it?. Thank you
Hello... I think your application is great, could you tell me how to take the titles from a column of the sheet please?
Sir, can you add upload files in the create request? Thank You
I want upload file, but I don't how do. Can you help me!. Thank so much.
Sir project not work and not show login page
How to write a text message is a url/link?
how can i change the picture?
i cant make a copy sir . the link is broken. pls can you fix the link
This code use in laundry storage manage in Hotel& Hospital
very helpful, but the demo can't be opened, is there an error?
@ashtonfei
2 жыл бұрын
Yes, some CDN links are broken, it's been fixed.
@dbonline2104
2 жыл бұрын
@@ashtonfei great work!t
how do i bring the title and role list straight from the worksheet.
@evaluacionesvrh6008
9 ай бұрын
Hello.. do you already have the answer?
Approval insert document
Sir Please make perfect portal as Like Every use change password himself option add And Create request to upload document and other Option add Name Father name Gender Address Mobile no Remarks And other
Sir can you please try to do a clock in and out
@ashtonfei
2 жыл бұрын
I was planning on it in LC012.
all applications are off, February 7th and 8th.
@ashtonfei
2 жыл бұрын
Thanks for your comments, it's been fixed. Lots of packages have been updated to use Vue3, some links are broken.
Sir Your project not working properly And Not show login page
@ashtonfei
2 жыл бұрын
Still not working? Any error message? script.google.com/macros/s/AKfycbyTQKjVb456F-3TiV3gYD3u3hn8sQxyb_8BNncgB1rWZFfkvvezW0TjVHCZujaCzI_i/exec
@vipemitra
2 жыл бұрын
@@ashtonfei not login