Author: Justin Hesser

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: When creating a new database on the FileMaker platform or any other, one of the keys to success is maintaining the servers that information is processed on. This is needed to not only ensure that data stored on them remains secure at all times, but also to head any potential problems off at the pass.

When your company partners with Kyo Logic to help create a new database, we take full responsibility when it comes to the FileMaker server machine. This takes the pressure off of your company to handle several solutions and instead focus on the data that is being created to improve how your company operates.

Kyo Logic will stay on top of installing all patches and updates to the operating system, FileMaker Servers and add any plug-ins that are released.

We run consistent reviews that can be used to adjust user permissions and examine the server logs for any sign of trouble. This keeps the systems ahead of any potential issues that could cause downtime for your business.

Kyo Logic also verifies to ensure that the backups are running correctly at all times and that there is enough disk space available to house all of the data that is being collected.

All of this information about the server's performance will be provided in a verbal report and checklist to the client to make sure that everyone is on the same page.

If you were to create a tool kit for any entrepreneur of the must-have gadgets to start their business with, the iPad would certainly be included. The device has made it possible for companies to effectively integrate a mobile element to their business.

Now, with the right applications, the mobile device can become nearly any tool that an organization could need. Plug in a Square credit card reader and it's a POS system. Sales people in the field can enter customer information or access critical data to help meet customer demand. It is also possible to run HR, manufacturing projects and countless other business tasks from the palm of your hand.

However, it can be difficult for small and midsized businesses to decide which apps they truly need if they are getting into the mobile landscape for the first time. Last month, NetworkWorld created a list of seven free iPad applications that businesses should download. Topping it was FileMaker Go.

"If you're a FileMaker Pro user on your PC or laptop, FileMaker Go lets you access these database apps from your iPad (note: the PC version is still needed to create, modify and sync your databases)," the post reads. "Version 12 in 2013 was a big change: lots of new features and controls, improved multimedia capabilities, multitasking support, greatly improved speed, and available free for the first time."

Businesses that are new to these systems can partner with a FileMaker solution provider to develop a plan, learn the software and start reaping their benefits.

Many organizations need to create a comprehensive database and certain tools are more popular than others.

A recent article from CITEworld profiled Berklee College of Music in Boston and features an interview with Damien Bracken, the dean of admissions. He mentioned that every year there are roughly 7,200 applicants and to figure out who is the most qualified talent, team admission staff must travel the globe to 120 sites to interview talent and evaluate not only talent but also potential.

To keep all this information updated, secure and streamlined, Berklee employees were required to carry laptops to enter all of this data when it was fresh. The organization was finally able to ditch the heavy computers on 2012 in favor of iPads because FileMaker – the database software the school has been using for over 20 years – released a mobile platform.

This allowed the officials to stay within a single application ecosystem. Now, all 30 members of the school's recruiting team carry the tablet and use the cloud-based software to take notes and upload them to the department from the road.

"Prior to FileMaker Go, which was designed for the iPad, we used some other products but they weren't up to par," Bracken said. "We needed something at a very professional level. As soon as this application came out it was like the sea parting for me, seriously. Having that available on a mobile device is huge for us."

He added that by using this kind of approach, it gives students the feeling that the school has all its ducks in a row when it comes to data.

This is one example for how a FileMaker solution can revolutionize how a business operates.

In a guest column from CitizenTekk, Brad Wilson, the Rentals Manager at Keslow Camera, spoke about how his company has been able to improve business processes through the use of FileMaker. As one of the largest camera rental companies in the Hollywood area, the organization provides equipment that is used in some of the biggest television shows and movies.

However, this also means there can be piles of paperwork to make sure all cameras are accounted for. This is where FileMaker can come into play. Wilson described several ways that operations have improved include:

• Going paperless – It is now much easier to look up order forms or check inventory. This lets employees answer client questions quickly, closing deals more effectively.
• Incorporate additional hardware – Because FileMaker can be used with multiple systems easily including Macs, iPads, iPod Touches and iPhones, employees now have a much easier way to access information and can help address customer needs from anywhere. This also helps manage business in off hours or during emergency calls.
• Improve speed – In a competitive marketplace, speed is everything. With this database, the company can submit bids quickly after checking to make sure they know all the information needed for an accurate assessment.

"The database is hosted on a Mac Pro for easy access across Keslow Camera's offices in Los Angeles, Chicago, Miami, Santa Fe, and New Orleans," Wilson said. "Managers and staff can tap into the information they need anytime, from anywhere, including via iPads and iPhones. The FileMaker Go app brings the full, rich application to Keslow's iPad and iPhone users – it's not just a slimmed-down version of the database."

With the help of a FileMaker service provider, any organization will be able to follow this path and create a better form of database.

Apple's Worldwide Developer Conference (WWDC) is one of the top software conventions in the industry. Last year, the company gave developers the first view of iOS 7 and OS X 10.9 Mavericks. These were then put into Beta and those with access started troubleshooting.

According to Tech Day, this year's annual event will be held June 2 through 6 at San Francisco's Moscone West. The five-day convention will again present the future of both the mobile and computer operating systems and if history holds true, this years event will have announcements that point to the next big moves for the company and consumers.

While tech enthusiasts will focus on this event because it is a major unveiling for the company, it also means that partner companies will need to adjust to change. Aside from software, the company has also unveiled hardware upgrades like the radically redesigned black cylinder Mac Pro that was unveiled last year.

For companies like FileMaker, this is the unveiling of the platform and hardware that their solution will be paired with.

As we reported last month, FileMaker recently announced its Developer Conference for July 28-31. It is highly likely that what is announced at the WWDC will impact this event, as it could have a direct impact of what the company has planned.

Regardless of what is announced by Apple, it will play a role in the future of solutions that are created by custom database software developers that use FileMaker as their primary tool.

Every software solution goes through a number of updates in order to remain effective. These can be patches to rectify new security threats, updates to existing software glitches or improvements to an existing solution. A majority of the time, these updates are needed to keep the systems firing on all cylinders.

This week, FileMaker released new versions of many of its solutions. This includes FileMaker Pro 13.0v2, FileMaker 13.0v2 Advanced, FileMaker Server 12.0v5 and the Mac version from OS X 10.9 Mavericks only and FileMaker Go 13.0.3 for the iPad and iPhone.

The Pro update addresses the limitations related to the FileMaker Pro URL protocol. It also includes general bug fixes pertaining to calculations and scripting, layout rendering and text editing.

FileMaker Go 13.0.3 expands file transfer capabilities to include moving files between iOS apps on the same device and transferring files between apps on other devices using AirDrop. It also addresses bug fixes and various compatibility issues. 

Making the decision to upgrade a software solution is not easy, especially if it is being used with critical business operations. The IT department needs to make sure that any and all updates are compatible with the other systems. For example, if you are running an older version of the Mac OS, the new FileMaker Server update will not run on this.

If you are a small business, keeping track of all this can be complicated. With the help of a Connecticut FileMaker developer, any organization will be able to assess their current solutions and learn about the new ones.

There are many systems in the corporate landscape that require business professionals to learn a new set of skills to be successful. However, learning these systems is not as easy as it seems, and because of how advanced the solution is, learning the skills could be complicated.

According to a press release from the company, FileMaker has released a new version of its training services series that is designed to help businesses learn the essentials of FileMaker 13. The system is available through Book and DVD, PDF and iBooks.

"Learn how to build a custom solution utilizing the full capabilities of the FileMaker Platform that meets the ever-changing needs of your business. 'The FileMaker Training Series: Advanced' covers a comprehensive set of topics to help you master the essentials of FileMaker 13 solution development," the article reads. "'FileMaker Training Series: Advanced' comes with a detailed, step-by-step manual and includes demo files, exercises and videos to help guide you through the materials."

There are several modules that make up the series that users will be able to master if they complete these projects. They include:

Introduction – This is the basics of the FileMaker platform and is the start of the journey. This is where organizations will be able to gain a fundamental knowledge to start using the database.

Data – FileMaker is a database, so understanding the basics of data relations, integrity and implementing multiple-table solutions are critical. This includes learning about certain types of data, auto-entry, validation, field storage and indexing. It also incorporates images.

Interface – This is the ability to work efficiently with several layouts, which is an essential skill for any developer. Whether accessing data from a mobile, desktop or the Web, the layout needs to be tailored to the specific environment in order for it to be successful.

Solution Logic: Calculations – This is a specific function that works in the calculation engine and can be applied in several contexts. These custom functions are built and use them in database solutions. There is also a set of specific functions for the mobile platform.

Solutions Logic: Scripting – Scripting allow users to create routines that can be triggered in a variety of ways. These make it easier to write and troubleshoot scripts for several platforms.

Reporting – Create reports in FileMaker with a number of techniques. Explore basic and advanced systems that can be used to learn cross-tab reports. This also touches on ExecuteSQL functions.

Security – This is a crucial component of every technology solution on the market. There are several built-in security features that need to be handled for companies to be successful.

Deployment – Work on deploying a FileMaker solution with the new FileMaker WebDirect technology and the improved FileMaker Go mobile application.

Integration – There are several different systems that can be integrated with FileMaker. These include SQL, ODBC connections and External SQL Data Source capabilities.

While this idea of self-learning can be help companies and individuals who have the time to learn it, it will not work for all businesses. This is where a FileMaker support service can come into play and help train an organization on all the best practices of FileMaker 13.

When most people think about gathering and sorting data, they think about using Excel. While it is a powerful spreadsheet tool that has its place in the corporate world, it may not be the best place to house your data if you are working with anything other than numbers.

When you consider that the world is becoming increasingly mobile, drastically improving the kind of information companies gather and the way they sort it, Excel becomes less effective. This is where a more powerful database is needed, and FileMaker has two decades of experience in this field and has embraced the mobile platform to go places never thought possible.

An article from CITEworld features an in-depth interview with Michael Jennings, a Chicago University Ph.D student and archeologist. Along with the fedora and whip, as part of his tool kit on a dig in Palestine of the 11th century Islamic castle at Khirbet al-Mafjar, near Jericho, Jennings is relying on FileMaker Go and an iPad.

While on-site, archeologists are constantly taking pictures, drawing sketches and writing notes. Traditionally this requires parties to carry large binders filled with paper records. The problem is that these can be lost or damaged. One archeologist who was working on the northern area of the site suddenly found all of his records missing, causing the team to redo all of this work.

Not only were teams required to carry these bulky binders around the site, but transport them back to the university departments in carry-on luggage when every page was scanned and information was entered manually into a computer system.

Jennings and field director Jehad Yasin realized they had an opportunity to improve operations here, especially considering that the database program used at the university was FileMaker. There is where the Go version of the software came into play and an iPad version of the existing database was quickly created.

Now, while examining the palace, the archeologists are able to snap pictures using the iPad's camera and sketch on the screen. They have also be able to create several drop-down menus so they can more easily enter accurate information. This is faster than writing everything down and makes it easier to analyze after the fact.

As they started to explore the possibilities of using the iPad, certain tweaks needed to be made to optimize operations. This included adding more controls, which is easy to do with FileMaker Pro on a computer. There are several layouts, controls and themes designed specifically to be compatible with the iOS platform, making it easy to update as needed.

With the Web-publishing capabilities, it was also easy for multiple team members to be work and update the same database at the same time.

"Depending on what you need, you can keep things simple or set up a more powerful way of distributing your database automatically," the article reads. "That's exactly what FileMaker offers: you can make a very simple system for viewing your database and updating it, or you can add in more features to get something more powerful without having to become a database expert."

While not every business needs to gather data while searching the catacombs of an ancient palace, this does highlight the real world possibilities of FileMaker. With the help of a Connecticut FileMaker developer, any organization can improve the way that it handles databases.

We all remember the "I'm a Mac, and I'm a PC " commercials that ran from 2006 through 2009. They created the idea that Apple hardware and software was designed for the creative types and having fun, while the PC was the stuffy system needed for work. While it helped push the younger generation to look into the iMac and MacBook line, there was not much focus on the enterprise.

If your computing needs are spreadsheets, word documents and some of the more boring but critical uses, the PC can a better choice. This was because the ads focused more on making podcasts, movies, photos or listening to music. Later versions focused on viruses and mistakes within the Windows operating system.

Over the last few years, Apple has taken up a bigger push to show the potential of the Mac in the enterprise. Aside from specific price points and services that are only for corporate customers, each Apple retail store has a completely flushed out business sales team that specializes in implementing Apple products into the enterprise in an effective manner and supporting the unique needs of these consumers.

A recent article from ComputerWorld examined some of the more specific ways that Apple has been able to move past the image of being just for "creative types" with "shiny toys" and become a true company for the enterprise. The piece touches on iOS 7 and Mac OS X Mavericks improvements that were made just for businesses, the growing demand from companies and how the hardware has upgraded.

The article also covers how the database creation application FileMaker has become a key component to Apple's rise in the enterprise. The tech giant has owned FileMaker since the 1980s, and the technology has performed well from the beginning.

The latest version of the technology, FileMaker 13, came packed with some of the largest improvements to the database solution that is used by millions of consumers yearly. The piece said that there was some disappointment around FileMaker 12 because of a file format change to modernize the code. However, the new version takes this change and expands upon it to boost developer productivity when designing database-driven solutions for PCs, Macs, mobile devices and the Web.

One example of this is the improvements to real-time data collection and the ability to have all systems access that information at once. While the ease-of-use is still one of the top reasons to adopt the technology, it has improved the enterprise-level security, multiple developer features and productivity enhancements that could be as simple as adding a data entry keyboard to the iOS platform.

"We've made it easier to learn and more powerful and productive for developers using it on a daily basis," FileMaker product manager, Eric Jacobson, told the news source.

FileMaker has been one of Apple's main enterprise applications. With both Pro and mobile versions (FileMaker Go), the software has evolved over nearly 30 years to be a key system not only for Apple but also for many businesses. For companies that are looking for FileMaker help, a local software developer that specializes in the service can become a valuable solution provider to fully embrace the technology.

Yesterday, we continued our series looking at the new features of FileMaker 13. The focus this week is on the improved layout features that make the system easier for many organizations to use.

A recent article from Technology Tell dove deep into FileMaker 13, examining all of the new features. Throughout the review, the layout comes up.

There was one drawback that the review points out. This is in the pre-made layouts for the desktop that do not have a counterpart within the Touch layout. In FIleMaker 12, there were 35 desktop layouts and five of those were specifically designed with touch in mind. For FileMaker 13, the number of desktops increased to 42, but only nine of them are comparable with touch.

With how much support and focus is being put in FileMaker Go, it would seem like the touch/mobile landscape would have a bigger focus. However, it is important to point out that FileMaker 13 does have the ability to import layouts. This means that these numbers could start to even out as more desktop versions get touch comparable versions.

There was also another improvement to the layout that was not touched upon yesterday. One of the new features is WebDirect, which helps organizations transport their information to the Web. The new feature has modifying the database design with fields, layouts, scripts and relationships.

While there may still be a little work to make the system perfect, the layout upgrades allow developers to help users make more useful solutions. A FileMaker developer can help businesses use these new layouts to improve their databases.