Approval Workflow with Google form -Part 1

[@theprosthecons4315]

Hi Palvan .... I'm stumped and no one seems to know how to do this. When someone fills out my google form I want to let them checkmark 1 of 5 ebooks and when they sumbit their form how do I get Forms to send the link to the 1 ebook they check marked on their form?

[@sonaljain4493]

Hi, I created the form as stated by you in the video. But after some days as the approver approves the form the requester details gets blank and in the sheet

[@aripatil8330]

hi, do you have a new version of this flow?

[@brurytangkere4874]

Can we make the form will not receive before all the approval approved ? Too many email (without full approve that i received) Thx

[@omarotonielholguinbatista4303]

I have a question, is it possible to put about 5 approvers for a single request and that when one approves, follow the process? How could I do it? That is, only one of the 5 has to approve to follow the process and when it does, the others see it approved.

[@chrislam1341]

Is there any way that I could create a route that for different approvers but not only one, which is allowed to be chosen by the requester? furthermore, when there is a contradicting decision of different approver for a single request, what should I do for making the final decision is the approver who has a higher rank in the organisation? Thanks.

[@TigranMovsisyanTB]

Can we send to different persons for aprroval?

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

[@jackyjigs2498]

My quota for 20 users finished.. How can I reset again for continue use? Please suggest me..

[@md.monzurulislam240]

Can you please describe about how I can added pending option and re-submission to again send for approval. Thanks in advance

[@maisabosila4637]

Where can i find the files please, couldn't find it as mentioned in the video

[@nitingurav9292]

Hi pavan, I have created a sheet exactly ah u have shown in vidoe. I have added multiple approving email id 's to approve request by adding question to select approving person Email id. When selected person approves request. Requester is get email that his request is approved . Is it possible to get email approval email notification from approving person mail id. Thnx Nitin

[@tsotneperadze5828]

Hello guys, I need your help, please let me know how to approve form? when I click the link for approving - Responses to this form cannot be edited. Try contacting the owner of the form if you think this is a mistake. ( I was a form owner)

[@reemomair6720]

Have you solve it? i have same problem

[@saud5133]

Hello , How can i transfer data from Sheet 1 to Sheet 2 daily basis and when data changes in Sheet 1, data is transfer to Sheet 2 without deleting previous data in sheet2

[@healthconnectionltd.403]

Can anyone help with The formmule doesnt show the “Form edit URL” as choice only live url

[@kian1990k]

did you solve it? i have same problem

[@checkettstm]

Palvan, at 2:13 you accessed the form starting from the 'Requestor' page. How did you skip page one?

[@palvan3]

+Travis Checketts Travis, please watch the second video(6-9mins) for the answer. Thanks!

[@checkettstm]

+Palvan Amanov Thanks!

[@prtvcscheduler4463]

how do i update the calendar automatically? Do i have to run manually?

[@tamershawer]

Dear, the google sheet didn't get the username after submitting the google form, is that something related to setting issue, or with the Formula string

[@palvan3]

You need to have Google Apps for Education or Work account to make it work.

[@tamershawer]

+Palvan Amanov thanks dear for clarifying, could u please send me the path of the Google sheet, because the path u mentioned is changed

[@ORR.72]

are all of this functions 'free'?

[@hishammohammed8563]

Hi, i had created the form exactly following the process shown in the video, However from few days. However, when the approver approves, the data on the google sheets are getting overwritten

[@palvan3]

The copy down plugin stopped working a while ago. Don't use that plugin. Instead I added just another question asking for user email address.

[@hishammohammed8563]

Hi, thanks for replying, Even I added the question in the beginning of the form, The issue that i am facing is, 1. The form is filled 2. It gets recorded on the google sheets 3. the Approver gets an email for approval The issue starts here, When the approver clicks on the link and approves, the entire data entered by the requester is overwritten. I could share the file if you want to have a look at it. Thank you.

[@palvan3]

Try to re create the whole form.

[@palvan3]

I simply added another question asking for email address :) and used it to send confirmation emails.

[@jemimoy]

Any one knows how to do the flow using PowerAutomate?

[@manzourfirdaws993]

Hi Pavan.. how do you capture the username.. i follow the steps but dont have that username column? Thanks

[@palvan3]

+Manzour Firdaws Hi Manzour! Make sure to check "Automatically collect respondent's....username" option under form settings menu. BTW, you need to have Google Apps for Education or Work account for that feature. It won't work with personal google accounts.

[@leshamak]

where is part 2?

[@santoshkumarghosh859]

Could you please share the tutorial how to create this

[@ConsulthinkProgrammer]

This my reference: kzbin.info/www/bejne/m5XYeGOOj56getU And I made a little modification like this one: For an alternative--and this simple approval application made by google form, save the result in google sheets: kzbin.info/www/bejne/pp6kkGmvfqqDhbs

[@conofre91]

where do i find the link to the sheets file i need to copy? great video by the way

[@palvan3]

Here is the updates link: sites.google.com/a/newvisions.org/scripts_resources/scripts/formmule

[@kalyanchakravarthyn9159]

How can i add page break

[@Rickety3263]

Look up “rtfm”

[@dinateresaserafimteresa7615]

Boa tarde💑

[@prachishah9670]

Not getting a link "Google sheets" in formulle to download

[@kian1990k]

did you solve it? i have same problem