"The big WIN for me is that I now have all my information in one SQL database. This has saved an enormous amount of time managing our Setup Crew!"
Michelle Wilson, Facilities & Operations
Leander Independent School District (LISD) educates more than 43,000 students at its 43 campuses in Texas, serving families in seven different municipalities. Leander ISD teachers and support staff focus on engaging and inspiring students for achievement and lifelong success. With that student-focused mission, they need to simplify complex administrative processes to keep the district operating smoothly.
One role of the LISD Facilities Department is to support room setup, for example when a teacher moves to a new classroom, or an organization hosts a banquet or conference on one of the campuses. LISD chose frevvo to automate this process for it’s easy to use design features and enterprise-grade integration options – particularly, SQL databases.
LISD's frevvo Room Setup Request form lets the user select a campus and then see a dropdown filtered to just rooms available on that campus. The user enters their event, including setup dates and other details to help the Facilities Department plan resources.
Business logic created with frevvo's Visual Rule Builder provides control validation on dates and displays a custom message if there is a problem. For example, the rules ensure the selected date and time is within two weeks of the current date, not on a holiday, and falls within the Facilities Department's operating hours. This helps ensure that accurate and complete data is submitted, and reduces the chance a request will be rejected. Users can upload a diagram of the room layout to help the team understand the plan.
LISD chose to integrate this form with their existing Microsoft SQL Server Database where they track other Facilities Department information. frevvo's Database Connector allows the form to dynamically show options from the database in dropdown controls and automatically write to the database tables. This integration not only streamlines the user experience, but allows the Facilities Department to manage their data all in one place.
LISD is so happy with frevvo that they are now implementing additional forms, including a Hazardous Area workflow, which allows users to report potential risks on bus routes and tracks the follow up and resolution of those reports.