Approval Workflow with Google form -Part 2

[@snowman3130]

How to create questionnaire responses based on scores. For example 0-15 ( a explanation ), 16-20 (another explanation ) and so on....

[@PhuongNguyen-ul8dh]

hi thanks for your video but I see the issue when we submit approval, it only show 2 row in google sheet. Could you advise to me how to solve this case? Thank you in advance.

[@rheybustos689]

how to run initial installation for formule to merge sheet to calendar? Thanks

[@MinhNguyen-ml4pc]

can you make an other video to show us how to create a redirect link to the approve page? Thanks!

[@pujaprathi]

Hi Palvan, How to send it to different persons for Approval, do we need to have Approver's email field in the Google form?

[@palvan3]

Its already on the spreadsheet under column called Form Edit URL.

[@prachishah9670]

Hi Palvan, I am facing two difficulties: First is I cannot integrate formule-calendar merge utility. I copied sheet still not showing that option under Formmule menu. Second is can you show how to create prefilled form skipping requester / approver section for approver.

[@chrissiestevenson1009]

Thanks so much for the great video! It was so easy to follow.

[@palvan3]

+Chrissie Stevenson You're welcome! I'm glad it was helpful.

[@collegeboy909]

I am unable to find the formMule script Add-on

[@ZahaWebConsultants01]

Can we also add a Cancel Leave Link inside the status email in case the requestor decides to cancel the leave which shall update data set in the backend?

[@hmdt3228]

thank you for sharing the video, very helpful video!

[@billzboxtv2651]

Thank you for this brilliant tutorial, I do not see the "Run Initial Installation" and cannot set calendar invites. Can you please help.

[@ZahaWebConsultants01]

Used this one and it helped. sites.google.com/a/newvisions.org/scripts_resources/scripts/formmule

[@ts.eddyramlin9421]

Hi @Palvan just want to check with you. how to change the value on the spreadsheet if user accidentally choose wrong type of leave and on the same time has been approved by the approver. is there any way to manually change the details or formula? Thanks

[@ZahaWebConsultants01]

Can we add the Calendar ID in a way that it works for every user on their respective calendar instead of picking my calendar ID in specific?

[@sinethdinu3531]

After the approvers submission, all the data of the requester goes away. what can i do ?

[@eStagadon]

Thanks for that video, very usefull. Just 2 points : how can i get prefilled url with the "new" google form ? synchro with agenda doesn't work for me, is there any details that could help me ? Thanks again, for all and answers ;-)

[@shikhinbharti8458]

Is this possible to approvel link will be on spreadsheet

[@meaganmathias792]

It worked!! Thank you so much!

[@orimarom]

Great video! would appreciate your help with the following: I am currently facing two problems: the calendar merge is not working (says invalid date and the preview shows 31/12/1969) and the sumifs formula is not working as well (I keep getting 0 for an answer). I am using a business google app account to try to do this. Thanks!

[@palvan3]

Hi Ori, Make sure to set the "Start Time" & "End Time" columns to "Date Time" format from Format-Number-Date Time. Data in those columns should look like this 2/11/2016 15:00:00. Sumifs is a tricky formula. Here what I have - =sumifs('Form Responses 1'!I:I,'Form Responses 1'!F:F,"Personal Leave",'Form Responses 1'!N:N,A2,'Form Responses 1'!K:K,"APPROVED") Hope it helps.

[@bigsteptheatre]

Does it mean you are not able to view the initial request from the requester? Meaning all the detials you will see is what is in the mail?

[@checkettstm]

Is there a way to make the email come from a different address than my gmail account? I get the 'reply to' function, but the email is sent from the gmail account I used to create the form. I would like the 'from' email and the 'reply to' email to be the same address.

[@palvan3]

+Travis Checkouts Emails go out from the account where the form is created. I don't think we can change "from" email.

[@thamyokelee1028]

Hi, I've been using this formMule add on for a month now. There is an issue starting recently. When the Approver edit with the , it will overwrite all the previous user's information and become all blank except for the Approver's information. Please help!!

[@palvan3]

This is probably caused by Copydown add-on. I had to disable the plugin and instead created another question to collect user's email address. I hope this helps.

[@thamyokelee1028]

Thank you for your prompt reply! But I kinda need the copyDown add-on to automatically increment the Case No. value...I think I have to think of another way then

[@palvan3]

I think formMule add-on creates case numbers not copy down.

[@priteemehra5663]

is this is script base ?

[@mudassirwaseem]

Hi, copy of formMule script sheet shows "working" and then shows "reconnecting". And i cannot see the FormMule script added in the sheet. please help.

[@palvan3]

Try updating your chrome browser, clear cookies, try it in incognito mode. Also, it might be a google sheet glitch that occurs once in a while. Just retry another time.

[@WheresJeanninePacifica]

FYI - you COPY to column M every time column C is changed. This causes the same issue with the username you had with the user intranet so you lost the 1st users personal days count - still helpful but you have a logic bug in your code I fear

[@RothaTouch]

sorry.. how can i create user to use my form .. ? my form can use only my google app account and i want my user(personal account) use my form , is it impossible ?

[@palvan3]

You need to have Google Apps for Education or Work to do all these. Sorry!

[@RothaTouch]

thank u so much ... your videos are very useful ! one more, is this Google Apps for Edu or work are free to use forever or it will paid after one year, or what ? And the last question is, how many user (user@my_domanname.com) i can create on my Google Apps ? thank again ...

[@charlesedwardmccabe8505]

How do you have formMule giving you over 150 emails per day available..?

[@palvan3]

I dont think we have that many requests per day. We are a small school.

[@charlesedwardmccabe8505]

in the video when you preview the emails at 3:01, formMule says that the "Remaining daily send quota: 1450" meaning that you can send with your account you can send 1450 emails that day.. how did you get that..? I work for a Corporation and being able to have a quota size like that would be great..

[@palvan3]

We're using Google Apps for Education. I guess that's a default quote for GAFE.

[@fayengch]

how to create multiple approval? Manager --> HR --> Director

[@lalitpatil4731]

Thnks for that.....

[@abdullahquhtani8058]

Plz contact me if you wanna do a paid task like this one.