Explore other case studies 
START YOUR PROJECT // Get a free consult with us today »
Reliability, and Security Anywhere
The Challenge
Western Winter Sports Representatives Association is a not-for-profit organization that sponsors trade shows for active winter lifestyles and outdoor industries. As a company perpetually on the move, where often events are held on the side of a mountain (at times in a blizzard), it’s critical that their technology solutions sync data and work both online and off.
WWSRA’s original FileMaker solution allowed them to interact with shadow tables from their website’s SQL database and manually import data from their offline laptops; however, ever-changing business demands meant that WWSRA needed to find someone to help take their solution to the next level.
COMPANY INFO:
- Headquarters: Longmont, CO
- Employees: 5 -10
- Industry: Trade Events
The team needed a flexible platform for offline devices: they couldn’t depend on always having access to their website. They needed to use their FileMaker solution with or without Wi-Fi, anywhere they need to be.
OUR APPROACH
The Codence team investigated the backend SQL changes and implemented an elegant solution with FileMaker ESS. The sync mechanisms Codence built resolved conflicts and become a one-click solution that required no fuss.
In addition to updating WWSRA’s outdated data sync approach, Codence designed intuitive reportsof meaningful information from field data.
MORE CASE STUDIES:
“We loved working with Codence. The team supported us across the board –from advice about our business down to the nitty-gritty of how our FileMaker app should work.”
– Cami Floros-Garrison, Director of WWSRA
“Codence saved us. In the beginning, we had a lot of urgent issues with our prior database. They came on and during our busy winter season, totally stepped up.”
– Cami Floros-Garrison, Director of WWSRA
Real Results
Our Solution
When people sign up to attend or present at a trade show, they register their information through the WWSRA website. The website then stores this information in an SQL database, and the team needed a flexible platform for offline devices: they couldn’t depend on always having access to their website. FileMaker serves as the perfect go-between as an onsite app with the power to integrate with their SQL-based backend.
WWSRA must also check people in on laptops in areas without Wi-Fi. After an event, once they have connectivity, the WWSRA team can tap a button and all of the information automatically syncs across laptops, FileMaker, and their SQL-based website.
As a result of their partnership with Codence, WWSRA is able to use their updated FileMaker solution with or without Wi-Fi, anywhere they need to be. After WWSRA gathers the information, they can view succinct reports, share them with stakeholders, and make meaningful business decisions. Whether on a mountain top demonstrating ski equipment, or at a convention center trade show checking in vendors, WWSRA knows that FileMaker’s Workplace Innovation Platform will keep the team over their skis.
Positive Impact
- WWSRA is able to use their updated FileMaker solution with or without Wi-Fi, anywhere they need to be.
- WWSRA can now easily see which retailers attended the show, along with their related attendees.
- Further, they now have a team available who could respond during events –either to urgent unplanned requirements, or to some technology problem that imposed itself.
MORE CASE STUDIES:
Let’s start something!
Speak to one of our expert consultants about how we can help you develop FileMaker solutions to meet your business needs today. During this free consultation, we’ll address your questions, learn more about your business, and make some immediate recommendations.
