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

  • @ashtonfei
    @ashtonfei2 жыл бұрын

    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.

  • @cwlindWX
    @cwlindWX2 жыл бұрын

    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!

  • @chantinon
    @chantinon2 жыл бұрын

    Great work! Thanks!

  • @jbybs
    @jbybs2 жыл бұрын

    Thank you very much for uploading great contents .

  • @adeprimasandy9687
    @adeprimasandy96872 жыл бұрын

    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.

  • @zohardilawar4096
    @zohardilawar40962 жыл бұрын

    Thank you Sir ,

  • @mahimanasa1
    @mahimanasa12 жыл бұрын

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

  • @jayasri-ft8040
    @jayasri-ft80402 жыл бұрын

    Greater than others

  • @muhammedaadhil5645
    @muhammedaadhil56452 жыл бұрын

    👍💚

  • @huonguc7673
    @huonguc76738 ай бұрын

    I think Admin has the right to delete items that have been created. Edit password for user. Thank you. Your project is great

  • @karlranili1140
    @karlranili11402 жыл бұрын

    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.

  • @vipemitra
    @vipemitra2 жыл бұрын

    When your google sheet copy Then click script Then deploy URL not working Please upload new script google sheet

  • @muhammedaadhil5645
    @muhammedaadhil56452 жыл бұрын

    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?

  • @soseksosek7440
    @soseksosek74402 жыл бұрын

    Would you help me, there is an error when running this application "RangeError: Maximum call stack size exceeded (line 323, file "backend")"

  • @user-qi5gp7zw5g
    @user-qi5gp7zw5g8 ай бұрын

    That's great, but I want additional files in form. Can you guide me how to do it?. Thank you

  • @evaluacionesvrh6008
    @evaluacionesvrh60089 ай бұрын

    Hello... I think your application is great, could you tell me how to take the titles from a column of the sheet please?

  • @user-ib7lc9id4t
    @user-ib7lc9id4t2 ай бұрын

    Sir, can you add upload files in the create request? Thank You

  • @minhhoangytcc87
    @minhhoangytcc87 Жыл бұрын

    I want upload file, but I don't how do. Can you help me!. Thank so much.

  • @vipemitra
    @vipemitra2 жыл бұрын

    Sir project not work and not show login page

  • @Nanang558
    @Nanang5582 жыл бұрын

    How to write a text message is a url/link?

  • @mymuzictripsecl5766
    @mymuzictripsecl5766 Жыл бұрын

    how can i change the picture?

  • @nourwaleed687
    @nourwaleed6878 ай бұрын

    i cant make a copy sir . the link is broken. pls can you fix the link

  • @hggoyani
    @hggoyani2 жыл бұрын

    This code use in laundry storage manage in Hotel& Hospital

  • @dbonline2104
    @dbonline21042 жыл бұрын

    very helpful, but the demo can't be opened, is there an error?

  • @ashtonfei

    @ashtonfei

    2 жыл бұрын

    Yes, some CDN links are broken, it's been fixed.

  • @dbonline2104

    @dbonline2104

    2 жыл бұрын

    @@ashtonfei great work!t

  • @janioqueiroz9263
    @janioqueiroz92632 жыл бұрын

    how do i bring the title and role list straight from the worksheet.

  • @evaluacionesvrh6008

    @evaluacionesvrh6008

    9 ай бұрын

    Hello.. do you already have the answer?

  • @DeIndra
    @DeIndra2 жыл бұрын

    Approval insert document

  • @vipemitra
    @vipemitra2 жыл бұрын

    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

  • @sirmacademy9186
    @sirmacademy91862 жыл бұрын

    Sir can you please try to do a clock in and out

  • @ashtonfei

    @ashtonfei

    2 жыл бұрын

    I was planning on it in LC012.

  • @janioqueiroz9263
    @janioqueiroz92632 жыл бұрын

    all applications are off, February 7th and 8th.

  • @ashtonfei

    @ashtonfei

    2 жыл бұрын

    Thanks for your comments, it's been fixed. Lots of packages have been updated to use Vue3, some links are broken.

  • @vipemitra
    @vipemitra2 жыл бұрын

    Sir Your project not working properly And Not show login page

  • @ashtonfei

    @ashtonfei

    2 жыл бұрын

    Still not working? Any error message? script.google.com/macros/s/AKfycbyTQKjVb456F-3TiV3gYD3u3hn8sQxyb_8BNncgB1rWZFfkvvezW0TjVHCZujaCzI_i/exec

  • @vipemitra

    @vipemitra

    2 жыл бұрын

    @@ashtonfei not login