German youth program uses FileMaker to run systems

In many cases, sports can be the great equalizer that brings unlikely groups together for something bigger than themselves. We saw this over the last month as nations across the world came together to watch and celebrate the World Cup soccer tournament. Even Pope Francis tweeted about how sports can promote culture.

For this to happen, organizations need to be ready to help promote sports with the youth in their respective countries. In Germany, while residents are celebrating its World Cup victory, 3,000 schools in the country are using FileMaker to help promote sports and run events through the Federal Youth Games.

A recent article from Bildungs Klick recapped the FileMaker sponsored school sports days that are held in Germany. These have been run for the last decade as a way to promote healthy living, team building and friendly competition, while also evaluating potential talent that can be nurtured for bigger things.

According to Alfred Bonk, a senior teacher at the Elly-Heuss-Schule in Wiesbaden — a University Sports Center and partner school of competitive sports and elite school of football — by using FileMaker, teachers are able to quickly record all necessary data in real-time. This allows the games to be handled quickly as they are easy to prepare and evaluate.

"We will continue to use the software because we have had only positive experiences and we can carry out the Federal Youth Games so fast, easy and safe," Bonk told the news source.

FileMaker consultants can help any group create a similar program that helps organizations keep track of programs and improve overall operations.

Your company should not be afraid to deploy a database

When a business decision maker hears the word "database," it can bring to mind a complex solution that requires special software and a dedicated server to crunch massive amounts of data. While that is what a traditional database may require, the system has evolved to turn this into an outdated version of what a database actually is.

A recent article from Macworld examined the current state of database software and why businesses should not be afraid of these systems. In many cases, databases are nothing more than a list of information. While an Excel spreadsheet can suffice in most instances, there is so much more than can be done.

This is where a system like FileMaker can be used to create a more complex solution, without much hassle. It is loaded with pre-configured databases that can easily be plugged in and started or slightly modified to better meet the needs of a business.

"Some applications, such as FileMaker Pro, have an iOS version (they call it FileMaker Go) so you can remotely access your data on a mobile device," the article reads. "Like many other database programs, you can also securely publish your data to the web so it can be accessed from any computer."

Businesses do not need to be afraid of the database anymore. With the help of a FileMaker developer, any business will be able to embrace the idea of a database and create a custom piece of software. Organizations will also be able to maintain the system and make tweaks as they become more comfortable with it.

More small businesses adopting software solutions

Many small businesses are increasing their use of business intelligence software solutions. The impact of technology has organizations looking for different ways to embrace the latest solutions that can help optimize systems.

A recent article from the New York Times features comments from several small business owners that are using solutions like FileMaker to improve their overall operations. A study from IDC shows that in 2010, just 1.7 percent of small businesses were using these kinds of solutions. That number is now up to 9.2 percent.

One of them was Brian Janezic, who owns two self-service car washes. He realized that there had to be a way to improve inventory, and after some searching he decided on FileMaker Pro. The biggest draw to the system is FileMaker Go, which allows these systems to be accessed on an iPad. This means that him and his three remote employees can monitor inventory levels from anywhere. Also, the employees of six other car washes that are owned by Janezic's parents can also access the information.

Sensors were added that link to FileMaker to each location's eight drums of car wash chemicals, including waxes, tire wash and glass cleaners. Previously, the contents of these drums were measured with a yard stick on a weekly basis. Now, everything is monitored continuously at every location. This means better data collection and immediate alerts through text or email.

According to Ramon Ray, the co-creator and host of the annual Small Business Summit, more companies are starting to look into adopting business intelligence solutions because they are easier to use than ever before. Many of these systems, including FileMaker, do not require a degree or manual to learn the basics. Now you can drag and drop spreadsheets or upload a file from a mobile device.

"If you have fleets of vehicles, you run those vehicles better; you can staff better, because you know where your employees should be, and when," Ray said. "The new tools provide better customer insights, so you know better what to sell them or what not to sell them; you can see which of your products has the best profit margin. You don't have to do things on gut check anymore."

Just because business intelligence systems are easier to use does not mean that companies will be able to master them right out of the gate. A FileMaker developer can help any organization deploy these systems in an effective way.

Using FileMaker to win baseball games

Earlier this month, this blog covered the growing use of data analytics in the world of sports. MIT's Sloan Conference shows the impact that data and analytics have in the current athletic landscape. While this area has always been numbers driven, the analytics side is still fairly new and organizations are just starting to figure out how to optimize these systems.

A recent article from Fanside featured an interview with Oakland Athletics first base coach Tye Waller. The team has been on the cutting edge of this trend and the movie "Moneyball" showed a bit of what the organization was thinking at the beginning of the 2000s.

Now, the team is going even further and Waller spoke about how he used data and analytics through the use of a database he created with FileMaker that is able to be used on an iPad.

According to Waller, his database is used as part of the team's scouting. Back in the day, this was handled through conversations of guys you had seen play and those you hadn't. It was common for reports to be written on the same player multiple times over the course of a season. If that person had a long career, you could write near 100 reports, that contained similar data.

When he went into the front office of the San Diego Padres, he noticed the computer systems that were being used to compare players' strengths and weaknesses. When he went back to the field as a coach, he took the system with him through a FileMaker Go database. Over nearly a decade, he has compiled a list of roughly 5,000 players that includes their histories, statistics and notes about strengths and weakness.

"Now all I gotta do is make an adjustment on the players we play against," Waller said. "You can move the players around within the program so that the information follows them for whatever team they play on. I know that at least I've got a foundation about that player. All I have to do is look at a little video and see what I can notice about what has changed about him from a hitting standpoint, defensive standpoint or statistical standpoint and we're up-to-date."

The Athletics are currently one of the best teams in the league, so clearly something is working. This is just one way that a FileMaker database can be used to improve data gathering and analytics. With the help of the right FileMaker developer, any company can find the best way to improve overall operations.

Farm uses FileMaker to improve operations and bottom line

When most people think about using the latest technology to improve overall operations, they picture a company that is based in technology. While that may include older computer systems, there is some hint of tech already being deployed. What doesn't come to mind is a farm, restaurant and cheesemaker that uses a tablet and the latest databasing systems to improve overall operations.

FileMaker is such a flexible solution that is can be used by a number of different organizations to take operations to a new level. One of the company's recent profiles focused on Sea Breeze Farm, a grass-based animal farm known for world-class wine, a restaurant, charcuterie, butcher and cheese shops. It is located outside of Seattle and used the motto "Green is Good."

This is the type of business that would seem to shy away from technology, but instead has embraced the latest technology and is thriving because of this decision.

According to owner George Page, the farm used FileMaker Pro and FileMaker Go to create an integrated business system that links the numerous operations that the farm conducts into a single platform. It has elevated the farm's overall efficiency and profits.

In the dairy operations, Page and his team are able to manage cow productivity and update information in real-time on the server for all to see. For the cheese, employees keep records of which kind of milk is being used during the process and track of aging times. This is also used in the wine cellar to monitor every batch. In the butcher shop, orders and delivery of every cut of meat is tracked. Aside from having all of this information at their fingertips at any time through an iPad, iPhone or iPod, caring for these devices is also much simpler in the cramped quarters of some of the farm's rooms.

"We have to track production for internal and regulatory purposes, constantly logging temperatures, refrigeration times, ingredients, recipes and weights," says Page. "We need to do it in a tiny space and on a system that we can keep clean instead of running the risk of getting food stuck in a keyboard."

The restaurant, which is much roomier, is also included in the FileMaker solution as a custom point-of-sale solution.

With all of these systems tracked through a single platform in real-time, the farm is able to make sure that everyone is on the same page and master inventory numbers are accurate.

With the help of a FileMaker developer, any company will be able to create a custom solution that improves the bottom line.

Top prep school runs FileMaker database and Go systems

One of the hottest trends in the educational landscape is mobile devices. From school boards deploying tablets in every classroom to improving wireless networking so students can use their personal devices to using specialty applications to help special needs students, tablets and smartphones are finding a home in the education system. However, the learning institutes need to make sure that they are doing everything possible to optimize the mobile platform.

Recently, FileMaker profiled Cheltenham College Junior School, which has been educating young people between the ages of three and 18 since 1841. It is considered one of the foremost co-educational public boarding schools in the country with a sterling reputation for academic achievement, breadth of extracurricular opportunities and a strong community.

The organization has been a FileMaker customer for the past 15 years and has been active in how it uses the system. Over the time period, the solution, which started as a simple contact management system, has evolved to include everything from pupil assessments to e-registration. The College has taken full advantage of everything that FileMaker has to offer and continues to look for new ways to optimize how it runs with new systems.

The most recent evolution of the system that the school administration has spearheaded include a deploying a mobile system through FileMaker Go to better meet the demands of current trends.

Nicky Fortune, the Curriculum Director at Cheltenham Junior College, told the news source that by partnering with its FileMaker development firm, the school was able to create fill mobile access with the FileMaker databases that are already set up within the school network. This includes a significant amount of information that is now able to be accessed while on the go.

With the new system, professors are able to access the grade book, for example, and update grades and assessments during the actual lesson in real-time instead of making notes that need to be transferred at a later date. The success here has the administration considering expanding the programs to including management of extracurricular activities and sports teams.

The school also has a backend overhaul that included a major contact database for parents of students. With a simple search of the database, the school is able to find all the important and contact information for a student and make the call to a parent or guardian with the click of a button.

Fortune laid out an example where a an emergency arises and a student needs to be found and the parent contacted. By using the new FileMaker database, a quick search brings up all contact information, as well as the students schedule. Now, the administrator knows right where the student should be and can press the phone number to start a call.

He went to on talk about the security features, multiple standalone uses and plans for continued expansion of FileMaker in the coming years into curriculum systems and more.

"We're extremely proud of the system that we've created here at Cheltenham College, and even fifteen years on there's a real feeling that there's so much left for us to get from FileMaker," Fortune said. "With the addition of FileMaker Go, it's a very exciting time to be using the software."

With the help of a custom FileMaker development firm, any company can improve how it operates through the use of FileMaker and its many features.

Using FileMaker as a CRM system

There are multiple software solutions in the business landscape that companies are adopting as a way to improve overall operations. One of the more popular is customer relationship management (CRM). This system allows companies to keep track of current and future customers by organizing, automating and synchronizing sales, marketing, customer service and technical support.

There are many ways that a CRM can be customized to meet the specific needs of a company. There are also countless features and tools that can be used to craft a customized solution.

A recent article from Productive Computing makes the case that the most effective form of CRM software is FileMaker Pro. It is a database program that integrates its powerful engine with a easy-to-use graphic user interface. There are several specific reasons why FileMaker Pro is such an important part of a CRM solution.

First off is the fact that FileMaker 13 is user friendly. If your company is switching to a system like this for the first time, it can be overwhelming. That is only compounded if the new solution is complicated to learn.

"FileMaker Pro is a completely user-friendly application that is easy to use regardless of your computer prowess," the article reads. "You don't have to develop databases for a living to use FileMaker, and teaching your team won't require many precious hours of training. All it takes is a few minutes to become a pro thanks to the clean, easy-to-understand user interface."

The database is easy to start using for any modern business, regardless of size if it is looking to store, organize, change or recall information. From a CRM standpoint, the relational database helps business owners record customer information like products purchased, time of purchase and personal customer information to help customize a marketing strategy. 

Powerful data analytics tool

In the hands of the right FileMaker developer, the system can be a dream because of the robust capacities. Organizations can create a database by importing a Bento library or through an Excel spreadsheet. Even companies that try to run the system themselves have the option to use several layouts and themes from 30 starter databases that can handle a wide array of applications.

Through FileMaker Pro, companies can create dynamic summary reports that create records and offer subtotals based on the sort order. The system can also be connected to the company's website, allowing for better email blasts and sharing of information. Through the cloud hosting services, organizations are able to manage customer information and better communicate it with the rest of the team.

"Getting into the nitty-gritty of FileMaker Pro helps you realize just how much control you have over the program, primarily in the scripts you can write to perform all sorts of actions with data," the article reads. "Scripts can be simple—send a report to a printer—or highly complex."

FileMaker Pro provides small businesses with a powerful tool for a fraction of the cost. With the help of a FileMaker development firm any company will be able to improve how they harness their data and take operations to the next level.

The security benefits of FileMaker Pro

For every new technology, one of the biggest challenges is security. Because an increasing number of business critical systems are transitioning to a digital platform, the need to keep this information safe is a growing priority.

A recent post from FileMaker's internal blog focuses on the security features that the platform has. While most operating systems provide their own security features, the FileMaker Pro access privileges are a fundamental way to control who has access to the database, which is security 101.

"It's especially important to protect FileMaker Pro files that are shared with other FileMaker Pro users via the FileMaker Network, with web users via Instant Web Publishing, and with ODBC/JDBC clients," the article reads. "These shared files are more vulnerable because they may be more widely available over your network."

There are other ways that FileMaker's built in security can be beneficial. This includes:

  • App development – With fine grain access control for data, script execution and meta-data, organizations will be able to protect the integrity of an application while allowing end-users to perform expected changes like adding a use or making small improvements.
  • System administration – With a database on a FileMaker Server, businesses can leverage infrastructure for authenticating users and protecting network resources. Companies can also set up accounts for specific users based on a centralized server.
  • Ease of use – Transparency is crucial and FileMaker has this as a priority.

With the help of a FileMaker support service, any company can improve how they manage their database and improve security across the board.

FileMaker 13 considered powerful database solution

The latest upgrade to FileMaker has helped cement the solution as a powerful database tool for the enterprise marketplace. Over the last few months, we have touched on several of the features that make the system as a whole a popular software tool.

A recent article from ProgrammableWeb put the system through the ringer for full review. Article author Stuart Iler, along with his team, created desktop, Web and mobile layouts with FileMaker Pro without any programming. While a database novice may face a learning curve, the intuitive interface and extensive documentation will make it much easier for anyone that is handling this process.

“One of the key selling points for FileMaker 13 is that it lets users design and create a single database back end, with an easily configured and deployed solution wherever you want to consume it. In the process of conducting this review, the advantages of that approach were apparent,” the article reads. “In all, we recommend FileMaker 13 as a powerful tool for building customizable database solutions without the need for a lot of technical know-how.”

It is unsurprising that the piece gives a positive review to FileMaker 13. It is a powerful database tool that can help any organization find a more efficient way of doing business. However, it can be difficult for companies that are unfamiliar with this kind of software solution to effectively deploy it. This is where a FileMaker developer can become a valuable resource for creating and deploying a new database.

FAQ: Can Kyo Logic link my website to FileMaker?

Every business considering a partnership with a FileMaker developer is going to have questions. In this series we will address the frequently asked questions that our customers have about our services.

Answer: In this digital day and age, you would be hard pressed to run a business without the aid of a website. With consumers connected to the "information superhighway" through computers and the mobile devices in their pockets, a company can become invisible without an online presence.

However the system is more complicated than just putting together a cheap site quickly so there is something in that space. A poor website can be just as, if not more damaging than having no site at all as it can make a company look unprofessional.

Once a quality website is created, the content then becomes king. There are many ways that this can be addressed and incorporating some software solutions into the website is one way to accomplish that.

It is not surprising that a company that has built a large database on the FileMaker platform would want to improve its business practices by linking it to the website. Depending on what the database was created for, having access through the company website can become a fantastic tool.

By partnering with Kyo Logic, we can help pair these two entities. For large volume sites we have built sophisticated synchronization tools that allow the site to use MySQL and other high volume databases. We can also link FileMaker via remote database protocols that syncs to a FileMaker server.