Sadly an ERROR code is given when a request for one day off is made. This is flagged by many comments in the supporting doc, but no response has been made to these requests for help. Also, the form cannot deal with requests for part of a day off.
Great video. Thank you. Very informative. I use Android apps for Google Docs and Tables every day. I worder why there is no Android app for Google Forms.
Hi Guys, I found a resolution for this! You should have access to the calendar of the person who logs to your app. -> "Share with specific people" setting
Hi. Awesome tutorial, but the new menu item at the top of that sheet called Form will not appear. I waited a few seconds, clicked Form > Go to live form to visit the form created by the script titled “Request time off”, and still Form did not appear. Do I require a certain version of Google? Any help is appreciated.
I had same issue. I had to open AppScript editor and run the script manually to get the new menu items to appear. Not sure if there is a glitch in the onOpen() trigger/command or what.
I work at a school district trying to apply this for specific times and dates for scheduling I already have a Form that takes basic information but it has a multiple choice column for time slots due to class periods, I am trying to get those variables to pull time in and time out then combine that with the date to set up a calendar event. I collect Name of Person the Date and Period Number(s) then want the variable to be distributed on separate rows in another sheet that can export that information to the Calendar. Unless I can create a script that takes Period 1 time of "8:10 am to 9:05 am" variables that will export per period without having to make teachers fill out a form per period.
🦕 ⚠️ Header "Email Address" not found in sheet: ["Timestamp","Email","Name","Start date","End date","Reason","Additional email","Approval","Notified status"] I get that massage could you please help me
I'm getting the same issue. Looks like the start and end dates HAVE to be different - so if they need just one day off, it causes that error message. LMK if you find a workaround, trying to implement this for 2022 in my office, really wish there was a fix.
🦕 ⚠ Header "Email Address" not found in sheet: ["Timestamp","Email","Name","Start date","End date","Reason","Additional email","Approval","Notified status"] I get that massage could you please help me
Sadly an ERROR code is given when a request for one day off is made. This is flagged by many comments in the supporting doc, but no response has been made to these requests for help. Also, the form cannot deal with requests for part of a day off.
Is there a way to modify this to allow for a 1-day off request? I saw a few people asking below but not sure if that was ever addressed.
Great video. Thank you. Very informative.
I use Android apps for Google Docs and Tables every day. I worder why there is no Android app for Google Forms.
Concerned about granting access to all of the things on their list. Can anyone share why I should not be concerned?
I've tried so hard to get this to work but it won't. Doesn't notify the employee or connect to my calendar.
I have the same problem.
Great video! Can I modify the form content to add sick and vacation leave?
When I hit "Notify Employees" I get this TypeError: Cannot read property 'createAllDayEvent' of nullDetails
. Any ideas how to fix the scripting?
Same issue!
Anyone find a fix for this notify error yet?
Same problem! Any fixes yet?
SAME PROBLEM! Anyone figured this out?
Hi Guys, I found a resolution for this! You should have access to the calendar of the person who logs to your app. -> "Share with specific people" setting
Great video as always 👍
Thank you
great video
Hi. Awesome tutorial, but the new menu item at the top of that sheet called Form will not appear. I waited a few seconds, clicked Form > Go to live form to visit the form created by the script titled “Request time off”, and still Form did not appear. Do I require a certain version of Google? Any help is appreciated.
I found same problem as you. Waiting other to share how hey to solve it.
I had same issue. I had to open AppScript editor and run the script manually to get the new menu items to appear. Not sure if there is a glitch in the onOpen() trigger/command or what.
I work at a school district trying to apply this for specific times and dates for scheduling
I already have a Form that takes basic information but it has a multiple choice column for time slots due to class periods, I am trying to get those variables to pull time in and time out then combine that with the date to set up a calendar event. I collect Name of Person the Date and Period Number(s) then want the variable to be distributed on separate rows in another sheet that can export that information to the Calendar. Unless I can create a script that takes Period 1 time of "8:10 am to 9:05 am" variables that will export per period without having to make teachers fill out a form per period.
Hi! how about if the employee applied for a 1 day leave? thanks
Hello, any update regarding my question? thank you
also looking for this answer :)
Can the all day event be called something else, such as the employees name and the time the employee is arriving or leaving?
Is there a way to set this up for a larger organization with various employees and different supervisors
is there anyway i can get on the phone or directly email someone in regards to some bugs im having with this. Thanks in advance
why is google currents paid >:(
It says Google hasn’t verified this app…. What will I do
Unable to send mail from my company domain mail id to gmail based mail id. Please Advice.
Doesn´t work anymore
the title says "How to manage manage employee vacation time requests
" looks like the second manage was a misprint
I bet they use app scripts to just post the vid to RUclips from sheets haha
I am 14 years old. I would like to submit a proposal to Google. I would like you to create a university called google university.
send your proposal
Im first year in michenical , i try for work with Google in future with my best idea .
Google im coming soon .
😇
All the best
🙌🙌🙌👏👏👏👏☝☝☝
🦕 ⚠️ Header "Email Address" not found in sheet: ["Timestamp","Email","Name","Start date","End date","Reason","Additional email","Approval","Notified status"]
I get that massage could you please help me
It could be that you didn't enter an "Additional Email Address" when filling out the form
When I hit "Notify Employees" I get this TypeError: Cannot read property 'createAllDayEvent' of nullDetails
. Any ideas how to fix the scripting?
I'm getting the same issue. Looks like the start and end dates HAVE to be different - so if they need just one day off, it causes that error message. LMK if you find a workaround, trying to implement this for 2022 in my office, really wish there was a fix.
🦕 ⚠ Header "Email Address" not found in sheet: ["Timestamp","Email","Name","Start date","End date","Reason","Additional email","Approval","Notified status"]
I get that massage could you please help me
It could be that you didn't enter an "Additional Email Address" when filling out the form