FileMaker for Your Database Application

FileMaker was initially designed as a DOS application for Apple Macintosh in 1985. But after two decades, FileMaker has emerged as one of the widely used cross-platform relational database applications. At present, it supports Windows, OS X and iOS. The enterprises also have option to use FileMaker Pro, FileMaker Pro Advanced, FileMaker Go, or FileMaker Server according to their requirements and budget.

FileMaker allows users to take advantage of Oracle, MySQL or SQL Server through the SQL database ODBC driver. So the programmers can easily connect FileMaker to their preferred SQL database, and create custom layouts based on the SQL database. The custom layouts make it easier for users to create, edit and delete SQL records directly using FileMaker layouts and functions. The cross-platform relational database application has been updated regularly to meet the latest trends in custom database application development.

FileMaker 14 comes with several features to simplify custom database development. It enables non-programmers to create custom database solutions by providing a drag-and-drop development environment. After defining the data, the users can take advantage of the drag-and-drop development environment to create custom screens according to their specific needs. The development environment allows them to create custom screens simply by dragging, dropping and stretching the required buttons, fields, boxes and bars. They also have option to add labels inside the fields to convey the nature and type of user input.

The navigation bars make it easier for end users to move from one record to another seamlessly. Also, the users can make the custom database applications more attractive through customized themes. The themes now use styles that include a number of attributes like fonts, text size and colors. So the users can easily change the attributes to create custom themes that can be reused across multiple projects. At the same time, they can also take advantage of the native iOS behaviors supported by FileMaker 14 to make the custom database solution accessible on iPhone and iPad.

FileMaker 14 further comes with several features to provide updated information to users without refreshing the page. It uses WebDirect to allow users to access updated data without any restriction. The feature works on web browser just like FileMaker works on desktop. Thus, WebDirect delivers updated information to users without requiring them to refresh the entire page. FileMaker 14 is also designed with features to reconnect to a server that is temporarily unavailable without re-launching the database. As the database is not re-launched, the working context of the user remains intact.

The features boost the custom database application’s performance regardless of the type and speed of data connection. FileMaker database development professionals can take advantage of the redesigned script workplace feature available in FileMaker 14. The revamped screen workplace allows developers to enter scripts directly from the keyboard. It further enables them to use the script step library to build scripts by following a number of steps. Thus, the seasoned programmers can simply start a script, and write lines of code using keyboard. They can further add script parameters and edit specific formula without using any additional tool.

The latest version of FileMaker supports .fmp12 file format which was introduced along with version 12 of the platform. So the users can easily switch from version 12 or 13 to version 14 of FileMaker. Also, they have option to import their existing data stored on a variety of files including XML, ODBC, Tab, .CSV and Microsoft Excel. FileMaker 14 also comes with several reporting and charting tools. These tools help users to quickly create colorful charts, summary reports and executive dashboards. They also have option to store the reports and charts in both PDF and Excel formats.

On the whole, FileMaker 14 comes with features to speed up custom database solution development. The drag-and-drop development environment provided by it makes it easier for non-programmers to create custom database solutions. At the same time, the redesigned script workplace helps seasoned programmers to create, edit and update scripts in a more effective way. Also, the users can use the framework to create applications by targeting Windows, OS X and iOS platforms.

Mindfire Solutions is a FileMaker Business Alliance (FBA) partner. We provide expert off-shore FileMaker development services across multiple platforms – iPad, iPhone, Windows, Mac, and the web.

FileMaker - Different Versions and Features

At present, FileMaker is one of the most widely used cross-platform relational database applications in the market. As it is designed by integrating a database engine with a GUI interface, FileMaker makes it easier for developers to create custom applications by dragging different elements into the form, screen or layout. But FileMaker was originally launched as a DOS-based application called Nutshell in early 1980s. The product was subsequently purchased by Claris, and renamed as FileMaker II. Thus, the versions of FileMaker can be divided into pre-FileMaker 6 and post-FileMaker 6.

Evolution of FileMaker as a Cross-Platform Relational Database Application

Version 4.0

In 1997, FileMaker 4.0 was released with a plug-in architecture. The version was designed just like Adobe Photoshop. The plug-in architecture enables developers to add custom features to the application. At the same time, the users also have option to use FileMaker as a web server using a bundled plug-in called Web Companion. The version 4.0 also allowed programmers to perform several file operations, along with sharing FileMaker files over the web or intranet.

Version 7

In 2004, FileMaker 7 was released with a new file format which supported file size up to 8 terabytes. The version also allowed individual fields to hold binary data up to 4 gigabytes or 2 gigabytes of 2-byte Unicode text per record. The enhanced relational model now enabled programmers to offer multiple tables for file. Also, the users have option to manipulate the related tables through a graphical relationship editor.

Version 8

The FileMaker 8 product family was introduced in 2005. The FileMaker 8 product family enabled developers to avail a number of advanced features like script variables, custom menus, tabbed interface, tooltips and enhanced debugging. Also, the users have option to copy and paste scripts, script steps, and whole tables and field definitions. The new features made it easier for developers to create custom database applications according to client’s specific requirements.

Version 9

FileMaker 9 was introduced in 2007 with a number of new features including conditional formatting, fluid layout auto-resizing, external SQL link, and hyperlinked pointers into databases. The Quick Start screens provided by FileMaker 9 further made it easier for users to access and update the database application in a quicker and more efficient way. The version also allowed uses to share images, documents, spreadsheets and other content of a field through emails.

Version 10

FileMaker 10 was released in 2009 with a completely revamped user interface. It came with a status bar that displayed some of the commonly used tools at the fingertip. Also, the version 10 came with a number of new features like script triggers, saved finds and dynamic report. It further allowed users to send emails directly through the SMTP server without using any additional email client.

Version 11 and 12

FileMaker 11 was released in 2010, whereas FileMaker 12 was introduced in 2012. The version 12 streamlined some of the major features introduced with FileMaker 11. FileMaker 11 allowed users to quickly create reports in a spreadsheet-like format, and make the reports appealing using a variety of charts. It further enabled users to search for information just like initiating web searches. FileMaker 12 made it easier for developers to accomplish precise design by using a variety of design layout tools. The version also included a variety of scripts, themes and design tools for iOS development. These versions also came with several new themes and database templates. FileMaker 12 further made it easier for programmers to create iOS databases.

Version 13

The most recent version of FileMaker was released in 2013. FileMaker 13 supports several web and mobile methods of data access. It further allows developers to create custom themes using colors, font, text size and similar attributes. The programmers can further create new fields, and drag and drop multiple fields directly into the layout. They can further reuse the custom themes across different projects. The version further optimizes the security of data using AES 256-bit encryption.

At present, users have option to choose from four distinct versions of FileMaker 13 according to their specific needs. Each user can chose FileMaker Pro 13, FileMaker Pro Advanced 13, FileMaker Server 13 or FileMaker Go 13. The features of each version of FileMaker 13 differ, along with the targeted users. So it is important for the user to compare the features of each version of FileMaker 13 according to his requirements.

We provide FileMaker development services. If you would like to hire FileMaker developers for your development needs, please contact Mindfire Solutions. 

Tips to Work with FileMaker Pro 13

As an efficient relational database application, FileMaker Pro is used by enterprises in cross-platform environments. FileMaker Pro 13 further comes with several new features to help programmers in creating a variety of custom business solutions for various devices. Along with new design, development and security features, the latest version of the relational database application also comes with several features to rapidly create applications for iPhone and iPad. However, it is important for new users to understand some tips and tricks to work with FileMaker Pro 13 more efficiently.

Tips for Designing Custom Solutions in FileMaker Pro 13

Understand Different Ways to Create a File

FileMaker Pro allows you to create databases in a number of ways. You can create a new file from the scratch or create a new file by importing data from another application. FileMaker allows you to import data stored as XML, Microsoft Excel and Tab-Separated Text (.tab or .txt). Likewise, you also have option to convert an older version of FileMaker Pro file. Also, you can create the file using Starter Solutions (templates). When you understand different ways to create a new file, it will be easier for you to decide the most appropriate method for creating a new file.

Use Field Picker to Define Database Fields

After crating the new database, you can use the Field Picker dialog box to define the fields in simple and quick way. The dialog box can also be used for adding or changing fields for an existing layout. Once you define the fields using Field Picker, they will be added to the Manage Database dialog box. However, you use the Field Picker to define fields for the current layout of the current table in FileMaker Pro. The dialog box will allow you to decide the field configuration through options like labels and field placement.

Use Field Picker to Control Fields

In addition to creating new fields, the Field Picker dialog box can also be used for deleting and modifying existing fields. While in Layout Mode you can always access the dialog box by clicking on the "Field Picker" button displayed in the status toolbar. After selecting one or more fields, you can simply right-click or control-click on them and select the Delete Field option. Likewise, you can choose the field type by choosing the new field type from the list. You can further choose the Field Options after right-clicking on the specific theme.

Use Themes to Make the Database Solution Look Professional

FileMaker Pro 13 allows you to use themes to provide professional look to the business solution. As a collection of coordinated styles, a theme allows you to easily define various attributes of the layout including color, font, background, parts and objects. You can further use the theme to provide a consistent look to both layouts and reports. The theme can be further changed for a layout in the Layout mode. You also have option to save the theme in a new name after incorporating desired changes. You must know how to use and manipulate themes to make your application look more professional.

Keep the Layout and Navigation Simple

Along with making the layout look professional, it is also important to keep it simple. You must make it a practice to avoid adding additional fields and objects to the layout. Likewise, you need to remove the fields and layout objects that will be used by the users rarely. If it is required to use secondary fields and layout objects, you can consider removing them from the main layout. You can move the secondary fields to another layout, or separate them using tab panels or slide panels. While designing the solution, you must keep the navigation option simple and fast. The users must be able to navigate without putting any extra time and effort. Instead of using buttons, you can consider using icons to covey the information to users without labeling.

While creating custom business solutions using FileMaker Pro 13, the developers must not forget to avail styles, custom themes and layout enhancements. The new features will help them in improving the application’s look, feel and performance without writing longer lines of code while doing FileMaker development.

We provide FileMaker database development service. If you would like to hire Filemaker developers for your database development needs, please contact us at Mindfire Solutions.

FileMaker Development best practices

Nowadays many organizations make use of FileMaker for creating custom solutions without giving extra time and effort. It is convenient to use as it allows the users to modify the database by simply dragging the new elements into screens, forms or layouts. Furthermore, the current version of the FileMaker is powered with new capabilities that help users to access the data across a variety of mobiles and other conventional devices.

Following certain guidelines as well as carrying out certain practices will result in getting accessible and robust solutions with the FileMaker 13.

Layout Mode to be More Accessible

The design of the layout of FileMaker solution determines to a great extent the accessibility of the same. With the help of the Accessibility Inspector, the programmers will be able to connect the field labels to the active field. Moreover, with this feature one can simply use the Layout button instead of the Status bar to get enhanced control and accessibility.

Optimization of Search Capabilities of the Application

Optimizing the FileMaker search capabilities goes a long way in increasing the accessibility of the FileMaker solution. Herein, each of the fields requires to be described properly in an unambiguous as well as clear manner for the purpose of enhancing the search capabilities of the FileMaker solution. As users access database in recent times from varied number of devices like laptops, computers, tablets, Smartphones, etc. it thus becomes extremely important that the solution finds the related data on the basis of particular search keywords entered by the users to display the results of the search faster. At instances of the data fields being properly identified along with results being clearly read out, the solution finds it easier to display the data.

Enhancement of Code Readability

FileMaker at present do not provide the developers with a code editor that is comprehensive. It, thereby, leads to the event of missing out the convenient options of writing clean and structured code by the developers. The programmers however have the option to access the external editors and snippets as well as various tools for keyword expansion. To enhance the readability of the code, it is important for the writers to write codes that are cohesive, which are able to be encapsulated and can be used repeated number of times without going through any hassle. The programmers are also required to actively handle probable errors without making use of additional dependencies apart from including grouping conventions that are strongly named.

Optimizing the Images

Optimizing images is another best practice for effective custom FileMaker development. The developers need to be careful enough to avoid the use of images as well as uninformative and functionless decorative objects at the time of designing the layout. Furthermore each of the text objects is to be spelled correctly in order to be easily read and understood by the reader reading the screen to optimize the use of images.

Improve the look & feel of the application

Working on the look as well as feel of the FileMaker solution is another recommended practice that results in enhancing the accessibility level of the same. Optimizing the layout by the application of high contrast themes is an easy way to enhance the look of the same. The developers should make sure that the document window of the application gives the users the option of increasing its Zoom level. Further, avoiding animation portals, tab control and videos helps greatly in making the solution work quicker. The application can further be enhanced to prompt the designers using the FileMaker solution for the next course of action with the help of the custom dialog box which can again be used to give out error alerts.

Option of List View Layout

Programmers have the option of choosing from both Table View Layouts and List View Layouts during the creation of the FileMaker solutions. However, the accessibility of the same can be enhanced only by the use of the latter that is the List View layout and hiding the former- the Table view layout. Moreover, in this context the programmers need to make use of field objects in place of the merge text at the time of working with List View Layout.

It is important to note that each of the updated versions of the FileMaker comes with new features as well as several enhanced capabilities to make the work faster and easier. The developer, thus, requires following the best practices with respect to the features of the latest version of database application.

We provide Filemaker database development services. If you would like to hire filemaker developers for your database development needs, please visit Mindfire Solutions.

FileMaker and Businesses - How Does It Satisfy Your DB Needs

The database needs vary from one enterprise to another. But each business want to pick a relational database management system (RDBMS) that is reliable, scalable and easy to manage. At the same time, the RDBMS also needs to meet the frequently changing information management needs of the business, while delivering predictable service level.

As a relational database application, FileMaker is designed to meet the information management needs of modern business. As the application is integrates a GUI-based interface and database engine, it becomes easier for users to modify the database according to their changing information management needs. At the same time a company can also use FileMaker to make its business data accessible over several platforms and devices.

Why FileMaker Pro can meet the DB Needs of Your Business?

Easy to Use

Each business looks for a database application that can be use by employees regardless of their level of computer literacy. FileMaker Pro comes with a graphical user interface (GUI) that can be accessed by users without putting any extra effort. So your employees can learn how to use the relational database application within a shorter span of time. Further, your business can migrate to FileMaker Pro without providing any specialized training to the employees.

Easy to Start

FileMaker Platform further enables users to easily create custom database solutions. For instance, the users can create database solution simply by dragging and dropping their existing Excel files into the FileMaker solution. Likewise, they can use several built-in tools and solution to create database solutions within a shorter span of time. The tools further make it easier for the users to modify the database according to their specific information management needs. That is why; your business can switch to the relational database applications regardless of your existing database management system.

Highly Scalable

Nowadays, each business has to manage a wide variety of information and data. The volume of the data or information also grows gradually with the expansion of the business. So each business wants to use a database application that is highly scalable. A business has option to choose from several products launched under the FileMaker Platform. The FileMaker Pro comes with features to help businesses in creating and running database solutions, whereas the FileMaker Pro Advanced provided specialized tools to create and manage custom solutions. That is why; your business can easily expand the relational database application to accommodate the increase in the volume of data or information.

Facilitates Multi-Platform Sharing

Nowadays, people access information and data on a variety of devices. A constant increase is being noted in the number of professionals accessing business data on their iPhones and iPads. So it has become essential for modern enterprises to enable their employees to access the business data anytime and anywhere. Your business can share FileMaker information safely across a variety of devices. The information can be accessed by users on platforms like Windows and Mac, and mobile devices like iPhone and iPad. Further, you can safely share the business information on the web or over a network.

Enhanced File Security Features

Unlike other relational database applications, FileMaker Pro comes with several features to keep database files secure and inaccessible. However, FileMaker aims to keep the security setup simple and transparent for end users. The security features of FileMaker cover both application development and system administration. These features protect the application’s integrity, while allowing end users to carry out the desired changes. The relational database application further protects data, script execution and meta-data through fine-grain access control mechanisms. At the same time, FileMaker Server allows users to avail additional security features like user authentication and protection of network resources.

Each enterprise also has option to choose from a number of products available under the FileMaker Platform. Based on its specific information management needs, a business can choose FileMaker Pro 13, FileMaker Pro 13 Advanced, FileMaker Go 13, or FileMaker Server 13. So it becomes easier for companies to create and deploy custom database solutions to effectuate the overall information management. You can get in touch with a custom Filemaker development company who can help you develop database application within allocated budgets and time schedules.

We provide Filemaker database design service. If you would like to hire Filemaker developer for your database development needs, please contact us at Mindfire Solutions.

What is new in FmPro Migrator 7.34

FmPro Migrator 7.34, that converts FileMaker databases into LiveCode, had been launched during the RunRevLive conference. David Simpson, a developer has introduced the new version over his FmPro Migrator software at the RunRevLive.14 conference in San Diego, which will be taking place this week or so. This particular software is going to transform FileMaker data into LiveCode programming language, additionally the latest version includes extended functions and also great flexibility. FmPro Migrator 7.34 is actually enhanced for the LiveCode 7, the new version of the app-creating language, it is an open source edition occurred after the successful Kickstarter venture which started in the year 2013. The previous 3 versions of FileMaker Pro 11, FileMaker Pro 12 and FileMaker Pro 13 all are compatible.

Now it has included support for changing FileMaker Pro Advanced 12 & FileMaker Pro Advanced 13 files to a LiveCode application stack file. Included support for transforming FileMaker 12 & FileMaker 13 script steps to LiveCode scripts. Moreover, enhanced the conversion of earlier script steps. FileMaker Tab Controls now are supported two levels deep while FileMaker 12 layout process. The new DataGrid object by LiveCode 6.5.2 is included in LiveCode template stack embedded in FmPro Migrator. Diagonal line objects now are created with a polygon object, to draw the object much more accurately than the earlierrectangle object. Included one new resizeStack handler in order to resize automatically the enclosing object group to offer the auto feature of scrollbars. This particular handler also is called every time the Layout Menu used to change among cards. Enhanced support for the FileMaker scrip steps with script parameters allotted to keys on layouts. The script steps consist of: Go to Layout, Perform Script, Open URL, Show Custom Dialog & Go to Record/Request/Page, Save Records as PDF, Save Records as Excel. Included cursor changing code to every layout object with the attached script step.

FmPro Migrator 7.34 will enable developers to function over 2 layers at the same time, and it also has brought, among the different additional features, even more accurate drawing of the objects. Databases could be saved to Excel & PDF files. Understanding the value of the LiveCode 7 developing cycle, Simpson stated regarding the latest platform and the software, he has really been constantly testing FmPro Migrator with the LiveCode 7 releases ever since 2014. He further said that his app at present appears to be razor-sharp on the Mac OS X along with Windows Hi-DPI displays, enhancing the professional appearance of FmPro Migrator.

In fact, it will be professionals who actually can expect to benefit more with the usage of FileMaker on their business plans. A FileMaker database is the perfect tool in order to collate & keep a record of all of the details a business requirements, from the internal organizational information to the sales data. Professional FileMaker developers could create this type of databases for the businesses of different sizes, enabling them to evaluate all the relevant statistics. Other organizations could possibly prefer to work with their personal databases, doing FileMaker training would be a good choice for those. Certified trainers could educate an organization's staff, a way to create and sustain their databases, providing their enterprises instant access to their information, as well as a great advantage in the competition. You can get in touch with a custom filemaker development company who can help you develop database application within allocated budgets and time schedules.

We provide filemaker database services. If you would like to hire filemaker expert for your database development needs, please contact us at Mindfire Solutions.

Does Filemaker score over Bento in user friendliness ?

According to Katsunori Shigeta, a FileMaker Database Developer & Trainer, the big difference among FileMaker & Bento happens to be its mechanism of relationship. FileMaker is able to deal with a lot of different relationship. Bento likewise has easy relationship, but it is enforced and can not be changed by user. He further explained exactly what the "relationship" means? It means connection in between the tables. And the table means the place of storage data, along with row & column. It is just like bookshelf. When you need to deal with real world data (for instance consumer, product, or perhaps transaction), one particular table will manage just one real world entity. Consumer table will manage consumer's data alone, product table works only with product's data. If you wish to handle several entity, such as consumers & products, or perhaps students and classes, make sure you consider relationship in between such entities. You may function many kind of entities on the FileMaker, however, Bento includes various limitation. If you'd like to create address book, Bento is a great one. Simply because address book handle person as well as their attribute. If you would like to manage two or more entities, and then make relationship among them, FileMaker is definitely is a good option. it isn't very simple, however as soon as you have an understanding of distinction between "table" & "table occurrence" with FileMaker terms, it isn't really difficult.

There were lots of opinions over the Mac App Store regarding the current version in Bento to become quite disappointing. Is that FileMaker thinking about phasing it out? FileMaker, Inc. reported that it might discontinue Bento so that it could put the focus on the FileMaker product family. It will eventually carry on supporting for Bento till July 30, 2014. FileMaker does not provides the Bento consumer products. It was informed that they'll give tech support for the Bento products through 30^th July, 2014. This particular change had been a part of the greater concentration on the FileMaker products. FileMaker Pro are going to be suitable for different users of the Bento for the Mac. They encourage Bento for the Mac consumers to see their "Is FileMaker Pro Right For You?" page to find out distinctions between Bento & FileMaker Pro and also to download a cost-free trial of the FileMaker Pro.

In case you are using Bento, it will continue to provide what you need for a long period. When you choose to export your data from the Bento to some other application, there are helpful tips regarding your options. FileMaker Pro in considered the greatest user friendly commercial database for the teams and the companies. FileMaker Pro just isn't as easy to use just as Bento, then again is much flexible and extensible. Along with FileMaker Pro, you could develop custom solutions, that usually appear and function absolutely the manner in which you want. FileMaker Pro usually takes more work to setup as compared to Bento. Yet it is at the same time a lot more flexible. For instance, in Bento you could drag-out a field then Bento would automatically setup the different fields however it would certainly space them the way Bento believes is better. With FileMaker Pro you need to move fields personally however you could put things just as you want. with Bento you'll be able to select an address field & Bento will likely to have it set up. However there aren't many changes you can create in order to the way the address field performs. With FileMaker Pro you need to set-up every single portion of the address field by yourself (street address, city, state, etc) however you could make different types of address field you want. You can get in touch with a custom filemaker development company who can help you develop database application within allocated budgets and time schedules.

We provide filemaker database development services. If you would like to know more about the expertise of our filemaker certified developers, please contact us at Mindfire Solutions.