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.
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 ;-)
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
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.
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?
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
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!
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.
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.
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.
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!!
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.
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
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..
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 ?
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 ...
How to create questionnaire responses based on scores. For example 0-15 ( a explanation ), 16-20 (another explanation ) and so on....
Its already on the spreadsheet under column called Form Edit URL.
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.
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 ;-)
can you make an other video to show us how to create a redirect link to the approve page? Thanks!
thank you for sharing the video, very helpful video!
how to run initial installation for formule to merge sheet to calendar?
Thanks
Hi Palvan,
How to send it to different persons for Approval, do we need to have Approver's email field in the Google form?
Thanks so much for the great video! It was so easy to follow.
+Chrissie Stevenson
You're welcome! I'm glad it was helpful.
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
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.
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?
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?
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?
Thank you for this brilliant tutorial, I do not see the "Run Initial Installation" and cannot set calendar invites.
Can you please help.
Used this one and it helped. sites.google.com/a/newvisions.org/scripts_resources/scripts/formmule
It worked!! Thank you so much!
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
how to create multiple approval? Manager --> HR --> Director
I am unable to find the formMule script Add-on
Is this possible to approvel link will be on spreadsheet
After the approvers submission, all the data of the requester goes away. what can i do ?
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!
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.
is this is script base ?
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.
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.
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.
+Travis Checkouts Emails go out from the account where the form is created. I don't think we can change "from" email.
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!!
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.
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
I think formMule add-on creates case numbers not copy down.
Thnks for that.....
How do you have formMule giving you over 150 emails per day available..?
I dont think we have that many requests per day. We are a small school.
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..
We're using Google Apps for Education. I guess that's a default quote for GAFE.
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 ?
You need to have Google Apps for Education or Work to do all these. Sorry!
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 ...
Plz contact me if you wanna do a paid task like this one.