Space Booking: Building a Workspace Reservation System in Google AppSheet

Space Booking: Building a Workspace Reservation System in Google AppSheet

Overview

With the rising costs of corporate real estate, many companies are opting for flexible, hybrid work spaces in favor of dedicated desks. As work culture shifts from cubicles to conference rooms and cafes, the way we plan out our work days is evolving too.

To help address the need for a more modern office environment, CloudWave used Google AppSheet to develop a workspace reservation system called Space Booking. Within Space Booking, employees can reserve conference rooms for collaboration and private workspaces for focus using innovative features like floor plan maps, filters for specific supplies, an employee locator search, and reporting dashboards for admins. The app integrates with any email or calendar system so that employees can schedule time slots and receive notifications seamlessly.

Project

Our team at CloudWave is always eager to innovate using emerging technology platforms. We chose the low code platform Google Appsheet to build this new application because it has numerous benefits for users: flexibility, affordability, and mobile accessibility.

When designing this app, our team kept the end users in mind throughout the entire process. They researched the most user-friendly system for scheduling reservations and included options for requesting supplies from office managers, receiving text message or email reminders, and even highlighting favorite work spaces to make it easy to find them and book them again. The most important feature we included was the option for businesses to upload a floor plan blueprint so that users can interact with a map displaying workspace locations within the facility.

We also designed Space Booking with versatility in mind. It can work for a wide range of different business uses ranging from large corporations with multiple office buildings, to manufacturing facilities with discussion spaces, to school campuses and education resource centers where faculty meet.

To ensure Space Booking would flow seamlessly into existing platforms and tools users interact with on a daily basis, our developers integrated it with Gmail and Google Calendar so that reservation dates and reminders are always handy. For businesses who rely on Microsoft Outlook or any other major email platform, Space Booking can be customized to integrate with that system instead.

Space Booking can be used on both desktop and mobile, and the team added some innovative features that can make the work day easier with just the tap of a button. An employee locator tool can help you find colleagues within the office based on their workspace reservations. A QR code scanner allows you to make reservations for a particular room or desk instantly rather than scrolling through the options in the app.

Our team understood that admins might need some additional controls in order for the application to be utilized as effectively as possible. We added customization options for specific rooms or wings of each floor plan so that admins can restrict access to include only leadership personnel as needed. We also created a dashboard with a variety of reports on how work spaces and supplies are utilized. Visibility into this info helps admins to ensure employees are both efficient and respectful when making their reservations.

Results

  • The Space Booking app allows users to upload custom floor plan maps and reserve work spaces either within the app or in-person by scanning a QR code.
  • Users can request supplies needed for their meetings or projects when reserving rooms, locate their colleagues based on reservations, save favorite work spaces, and more.
  • Admins can restrict access of certain areas to specific leadership groups, and review reporting dashboards with details on how spaces and supplies are being utilized.
  • The Space Booking app can integrate with any email or calendar system so that users can schedule their meeting or private work spaces ahead of time and receive both email and text message reminders about their reservations.

About CloudWave

CloudWave Inc. is an information technology consulting firm based in Virginia that provides end to end services from architecture to development in niche cutting-edge cloud technologies. CloudWave specializes in application development, integration, and cloud offerings – SaaS, PaaS, IaS, machine learning/artificial intelligence, analytics/business intelligence, microservices, and enterprise document management. Since 2012, the company has developed classified/unclassified, innovative, cost-saving, low-risk solutions to federal and commercial customers both within the United States and globally. The team has more than 30 years of exceptional systems and architectures experience managing complex and compliant projects.

CloudWave has successfully integrated Smartsheet with Salesforce, MuleSoft, Google Cloud, Azure, Jira, Hubspot, and more so that our clients can have real-time access to all relevant information across multiple systems.

With CloudWave on your side, you can feel peace of mind knowing that you are working with an official Smartsheet platinum Partner. Our team has the expertise and experience to determine your organization’s vision, and then design a powerful solution to meet those needs.

For more information, get in touch with us here.

Youth Care: Building a Childcare Management System in Google AppSheet

Youth Care: Building a Childcare Management System in Google AppSheet

Overview

CloudWave developed an application that helps caretakers access critical information about children and streamline the processes to provide them with healthcare, legal representation, and basic needs.

Admins needed a way to quickly onboard and manage sensitive information for children in a secure platform. Within the app, caretakers can find contact information for families, organize and access legal documentation, transfer children’s records to different facilities, assign children to specific rooms within facilities, request specific items children need, request an appointment with onsite and offsite healthcare providers for children, and more.

Project

An organization that provides housing for children until they can be reunited with their families was seeking a data solution that would make their records easily accessible to caretakers, but also extremely secure due to the sensitive nature of the data. Caretakers needed a way to manage files like medical records, legal documents, and family contact info without any concerns about data security.

Our team at CloudWave is always eager to innovate using emerging technology platforms. We chose the low code platform Google Appsheet to build this new application because it has numerous benefits for users: flexibility, affordability, and mobile accessibility.

Our client is a large organization with multiple different on-site facilities providing basic necessities like food and shelter as well as entertainment and emotional support for the children. Since there were so many different types of data that needed to be accessible within the app, we broke everything down into categories. These include: Calendar Events, Cafeteria, Entertainment, Library, Phone Book, Legal Documentation, Medical Documentation, Order Supplies, Children, and Youth Care Workers.

Caregivers can use these different tools within the same app for everything from ordering specific clothing items for a child to updating their medical history to providing them with books and movies for daily entertainment. Caregivers can also schedule offsite appointments with doctors or attorneys for specific children and onboard/offboard them as needed.

The app also features an innovative GPS tracking feature that helps employees quickly locate each other across such massive facilities. For example, if a caregiver needs to locate a particular onsite medical professional or mental health counselor, they can look up that person by name and find them on the facility map.

There are additional admin features like dashboards that quickly display lists of caregivers and the corresponding lists of children they oversee. While this information may change several times throughout the month, the app is connected to Google Cloud Platform where all of the historical data about each caregiver and their groups of children is stored safely and accessibly.

Results

  • The Youth Care App allows caregivers to organize critical documents and provide them with necessary care until they can be reunited with their families.
  • The app can be used for scheduling appointments with healthcare providers or attorneys, ordering supplies, or even providing the children with entertainment.
  • Employees can locate each other across the facilities using the GPS log.
  • Admins have advanced features and dashboards with a quick overview of the most critical information.
  • All data is safely stored in the Google Cloud Platform.

About CloudWave

CloudWave Inc. is an information technology consulting firm based in Virginia that provides end to end services from architecture to development in niche cutting-edge cloud technologies. CloudWave specializes in application development, integration, and cloud offerings – SaaS, PaaS, IaS, machine learning/artificial intelligence, analytics/business intelligence, microservices, and enterprise document management. Since 2012, the company has developed classified/unclassified, innovative, cost-saving, low-risk solutions to federal and commercial customers both within the United States and globally. The team has more than 30 years of exceptional systems and architectures experience managing complex and compliant projects.

CloudWave has successfully integrated Smartsheet with Salesforce, MuleSoft, Google Cloud, Azure, Jira, Hubspot, and more so that our clients can have real-time access to all relevant information across multiple systems.

With CloudWave on your side, you can feel peace of mind knowing that you are working with an official Smartsheet platinum Partner. Our team has the expertise and experience to determine your organization’s vision, and then design a powerful solution to meet those needs.

For more information, get in touch with us here.

Event Tracker: Building an Event Planning System in Google AppSheet

Event Tracker: Building an Event Planning System in Google AppSheet

Overview

CloudWave developed an Event Tracker application in Google AppSheet to help organizations create and track internal events throughout their lifecycle. Event Tracker allows users to create events with details about their date, location, and expenses, and then these events flow through admin approvals at each level of the organization. Once an event is fully approved, employees throughout the organization can register. This system helps businesses maintain event approval functionality and save money on the cost of software.

Project

One of our clients was looking for an opportunity to cut down on costs and still maintain existing functionality for scheduling and tracking upcoming events.

Our team at CloudWave is always eager to innovate using emerging technology platforms. We chose the low code platform Google Appsheet to build this new application because it has numerous benefits for users: flexibility, affordability, and mobile accessibility.

The app is designed so that system admins can create an event, and then it can move through a full lifecycle approval process. Criteria within the cycle determines what level of increasing approval is needed from key stakeholders.

Each event starts out as a draft with a minimum of three to five levels of approvalI. Admins can specify the details about the event, the number of attendees, expenses associated with the event, and the supervisor who needs to approve it at the next level. Supervisors will be pinged automatically with an email so that they can review the event details and approve or reject them.

If it is rejected for any reason, it will not be able to move forward to the next phase of the life cycle. Once an event has passed through the entire approval process, users can register to attend the event. Those who are registering will be prompted to fill out follow-up forms on their travel needs for attendance.

Within the application, users can view all of their upcoming registered events and submit expenses connected to them as necessary.

Results

  • The Event Tracker App allows users to easily organize info about upcoming events, including dates and times, budget, number of attendees, and more.
  • Events move through an approval process with notifications for the admins at each level of the life cycle.
  • This application built in Google App Sheet is a cost effective alternative that still allows for robust event tracking functionality.

About CloudWave

CloudWave Inc. is an information technology consulting firm based in Virginia that provides end to end services from architecture to development in niche cutting-edge cloud technologies. CloudWave specializes in application development, integration, and cloud offerings – SaaS, PaaS, IaS, machine learning/artificial intelligence, analytics/business intelligence, microservices, and enterprise document management. Since 2012, the company has developed classified/unclassified, innovative, cost-saving, low-risk solutions to federal and commercial customers both within the United States and globally. The team has more than 30 years of exceptional systems and architectures experience managing complex and compliant projects.

CloudWave has successfully integrated Smartsheet with Salesforce, MuleSoft, Google Cloud, Azure, Jira, Hubspot, and more so that our clients can have real-time access to all relevant information across multiple systems.

With CloudWave on your side, you can feel peace of mind knowing that you are working with an official Smartsheet platinum Partner. Our team has the expertise and experience to determine your organization’s vision, and then design a powerful solution to meet those needs.

For more information, get in touch with us here.