Google script app
- or -
Post a project like this3366
$$
- Posted:
- Proposals: 3
- Remote
- #660591
- Awarded
Description
Experience Level: Intermediate
General information for the business: Link a google form to a goggle calendar
Description of requirements/functionality: I need a google form created that gathers approx 8 fields of info, and as filled creates a continuing database of that info.
One field is a date and i need the info from the form to go to a google calendar on the correct date
also need to send an email out once a checkbox has been checked.
the google form/ calendar will be one shared by my company staff only, but the email going out will change and go to public email address's ( ie- not only internal emails)
Update 2#
the principle here is that:
a guest comes to my front desk, we fill out the form to gather data as indicated (we will manually input each form, excluding the date/ time log of form creation) . That data goes to a google calendar that my staff can view each day and print/ or view a report that shows what rvs need to be moved that day showing all the info gathered for each of that days events
Extra notes: Most data will be entered on a desktop but will also be reviewed on web page on small tablet
example of form attached
email would only go out once the "rv on site" button is toggled
Update Jan 17
Hello
I will attach an example of the form i was looking for. I would like to personalize it a bit better but that can come later.
As I ran this through my head more I thought I better explain in more detail and then as you for your opinion on the best way to get the results I need.
The main form needs to be accessible on all my front desk computers. Once this form is filled out it needs to go to a spreadsheet or whatever that keeps the data. Then i need a report or calendar function that can be viewed or a report run that outputs by "reservation date" the RVs that need to be moved that day. A hard copy report needs to be printed. The reason I like a calendar function (google etc) is that the staff can view it on a tablet or whatever through wifi, out in the field what units need to be moved. A searchable feature from the tablet would be great also, so if one of my staff are out in the field and want to know the status of a unit, they could put in the reservation # and get the units info, name, date of reservation etc. Another feature that would be needed is an email feature that sends a disclosure to the owner once we enter their info ( and of course their email). A unique, but not mandatory feature would be the ability to further email the rv owner a boiler plate email that says their unit is on site once my staff click on something on the form to indicate it has been completed. That way the front desk staff could see it is on site versus in storage and the guest would get that something extra.
Hope this helps clarify my initial thoughts
Update #3
The form needs to be non changeable by staff - they can fill it out but not change fields etc
Report needs to be simple to run and output
Have included flow chart for better explanation
Description of requirements/functionality: I need a google form created that gathers approx 8 fields of info, and as filled creates a continuing database of that info.
One field is a date and i need the info from the form to go to a google calendar on the correct date
also need to send an email out once a checkbox has been checked.
the google form/ calendar will be one shared by my company staff only, but the email going out will change and go to public email address's ( ie- not only internal emails)
Update 2#
the principle here is that:
a guest comes to my front desk, we fill out the form to gather data as indicated (we will manually input each form, excluding the date/ time log of form creation) . That data goes to a google calendar that my staff can view each day and print/ or view a report that shows what rvs need to be moved that day showing all the info gathered for each of that days events
Extra notes: Most data will be entered on a desktop but will also be reviewed on web page on small tablet
example of form attached
email would only go out once the "rv on site" button is toggled
Update Jan 17
Hello
I will attach an example of the form i was looking for. I would like to personalize it a bit better but that can come later.
As I ran this through my head more I thought I better explain in more detail and then as you for your opinion on the best way to get the results I need.
The main form needs to be accessible on all my front desk computers. Once this form is filled out it needs to go to a spreadsheet or whatever that keeps the data. Then i need a report or calendar function that can be viewed or a report run that outputs by "reservation date" the RVs that need to be moved that day. A hard copy report needs to be printed. The reason I like a calendar function (google etc) is that the staff can view it on a tablet or whatever through wifi, out in the field what units need to be moved. A searchable feature from the tablet would be great also, so if one of my staff are out in the field and want to know the status of a unit, they could put in the reservation # and get the units info, name, date of reservation etc. Another feature that would be needed is an email feature that sends a disclosure to the owner once we enter their info ( and of course their email). A unique, but not mandatory feature would be the ability to further email the rv owner a boiler plate email that says their unit is on site once my staff click on something on the form to indicate it has been completed. That way the front desk staff could see it is on site versus in storage and the guest would get that something extra.
Hope this helps clarify my initial thoughts
Update #3
The form needs to be non changeable by staff - they can fill it out but not change fields etc
Report needs to be simple to run and output
Have included flow chart for better explanation
Dave B.
100% (3)Projects Completed
1
Freelancers worked with
1
Projects awarded
25%
Last project
9 Feb 2015
Canada
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies