Event Tracker: Building an Event Planning System in Google AppSheet

Overview

CloudWave developed an application for event lifecycle for any organization that requires event tracking that allows users to create events with details about their date, location, and expenses and they flow through admin approvals at each level of the organization. Once an event is fully approved, people throughout an organization can register for the event. 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.