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
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?
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.
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?
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.
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)
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
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
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
This my reference: ua-cam.com/video/eduG0XZ9mDs/v-deo.html 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: ua-cam.com/video/pmA_6yIEPOY/v-deo.html
+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.
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
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.
hi, do you have a new version of this flow?
Can we send to different persons for aprroval?
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
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?
Can we make the form will not receive before all the approval approved ?
Too many email (without full approve that i received)
Thx
Where can i find the files please, couldn't find it as mentioned in the video
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.
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?
Can you please describe about how I can added pending option and re-submission to again send for approval. Thanks in advance
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.
My quota for 20 users finished.. How can I reset again for continue use? Please suggest me..
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)
Have you solve it? i have same problem
Can anyone help with The formmule doesnt show the “Form edit URL” as choice only live url
did you solve it? i have same problem
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
how do i update the calendar automatically? Do i have to run manually?
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
are all of this functions 'free'?
Palvan, at 2:13 you accessed the form starting from the 'Requestor' page. How did you skip page one?
+Travis Checketts Travis, please watch the second video(6-9mins) for the answer. Thanks!
+Palvan Amanov Thanks!
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
You need to have Google Apps for Education or Work account to make it work.
+Palvan Amanov thanks dear for clarifying, could u please send me the path of the Google sheet, because the path u mentioned is changed
where is part 2?
Any one knows how to do the flow using PowerAutomate?
Could you please share the tutorial how to create this
This my reference: ua-cam.com/video/eduG0XZ9mDs/v-deo.html
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:
ua-cam.com/video/pmA_6yIEPOY/v-deo.html
Hi Pavan.. how do you capture the username.. i follow the steps but dont have that username column? Thanks
+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.
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
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.
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.
Try to re create the whole form.
I simply added another question asking for email address :) and used it to send confirmation emails.
where do i find the link to the sheets file i need to copy? great video by the way
Here is the updates link:
sites.google.com/a/newvisions.org/scripts_resources/scripts/formmule
How can i add page break
Look up “rtfm”
Boa tarde💑
Not getting a link "Google sheets" in formulle to download
did you solve it? i have same problem