Create a conference room scheduler using google products (Sheets, Site, and Calendar)
Budget: $250 – $750 USD
Things that need to be created:
1. Create a form that can be embeded on a google site.
A. The form must grab data from a google sheet ( Room Name, Room Number, description,...)
B. The form needs to check if the room selected is available for the number of people, date, time needed.
2. Place the data collected from the form to a google sheets
3. Sync the sheet with a conference room calendar
4. Allow user to cancel the room
1. Create a form that can be embeded on a google site.
A. The form must grab data from a google sheet ( Room Name, Room Number, description,...)
B. The form needs to check if the room selected is available for the number of people, date, time needed.
2. Place the data collected from the form to a google sheets
3. Sync the sheet with a conference room calendar
4. Allow user to cancel the room