Menu
1.2 First steps with FileMaker
Getting started with FileMaker is an exciting step on the road to developing your own customized database solutions. FileMaker, a platform known for its ease of use, provides an intuitive environment that allows even beginners to quickly become productive. In this section, we'll guide you through getting started with FileMaker, from installation to creating your first database and the basic features you need to know.
Table of contents
Installation and initial setup
The first step to working with FileMaker is to install the software on your computer. FileMaker is available for both macOS and Windows, and the installation process is straightforward in both cases.
- Download the software: Visit the official Claris websiteto download the latest version of FileMaker. After downloading the installation file, you can start the software by double-clicking on the file.
- InstallationFollow the instructions of the installation wizard. You will be asked to agree to the license terms and select the installation location. In most cases, you can keep the default settings.
- First versionAfter installation, start FileMaker by clicking on the program icon. You may need to enter your license information the first time you start FileMaker. You will then be taken to the start screen, from which you can either create a new database or open an existing one.
Overview of the user interface
Once FileMaker is launched, you will be greeted by a clean and intuitive user interface. The interface is divided into several main areas that make it easier for you to access the most important functions.
- Start screenThe home screen provides quick access to recently used files, templates for new projects and the ability to create a new database from scratch.
- Menu barThe menu bar at the top of the screen provides access to all of FileMaker's main functions, including file operations, layout design, scripting and data management.
- Status barThe status bar, which is located at the top of the window by default, provides quick access to frequently used functions such as creating new data records, searching through data records and sorting data.
- Layout areaThe largest part of the screen is reserved for the layout area. This is where you design the user interface of your database, create fields, add buttons and design the appearance of your application.
- Inspector and palletsOn the right-hand side of the layout area is the inspector, a tool that provides detailed settings for the selected layout objects. Here you can define properties such as colors, fonts, sizes and positions of objects. On the left-hand side is the field and object palette, with which fields, objects and add-ons can be edited and dragged into the layout area.
Creating a new database
Creating your first database in FileMaker is a simple process that will give you a basic understanding of the structure and workings of the platform.
- Create new databaseClick on the "Empty" icon on the start screen and then on the "Create" button. You will be asked to select a storage location and a file name for your database. Once this is done, the file will open and you can start working.
- Define tables and fieldsA FileMaker database consists of tables, which in turn consist of fields. Fields are the smallest unit of data in FileMaker and store specific information such as names, addresses or phone numbers. To add a new table, navigate to File > Manage > Database. Here you can create a new table and define the corresponding fields.
- Enter dataOnce your table and fields have been created, you can start entering data. To do this, switch to the Browse mode (accessible via the status bar or via the menu bar "View > Scroll"). Here you can add new data records and fill the fields with information.
- Customize layoutsFileMaker allows you to create different layouts to display your data in different ways. This is particularly useful if you want to create reports or customize the input forms for different user groups. Layouts can be customized using the Layout mode which can be activated via the menu bar under "View > Layout mode".
Import of data (CSV, Excel)
In many cases, users work with data that is already available in other formats, such as Excel spreadsheets or CSV files. FileMaker makes importing this data simple and seamless.
- Start data importTo import data, open your database and select File > Import data records > File. Select the file you want to import and follow the instructions in the import wizard.
- Assigning fieldsDuring the import process, you need to map the fields in your FileMaker database to the columns in the imported file. FileMaker provides a preview of the data so you can make sure everything is mapped correctly.
- Validate dataAfter the import, it is advisable to check the data to ensure that everything has been imported correctly. If necessary, you can make adjustments or perform the import again.
Basics of database development
A solid understanding of database development is crucial to fully utilize the potential of FileMaker. The platform is based on the concept of relational databases, which enable complex data structures to be managed efficiently.
- Tables and relationshipsIn FileMaker, you can create multiple tables and relate them to each other. Relationships define how data from different tables are linked together. For example, you could create one table for customers and another for orders, with a relationship between the two tables tracking a specific customer's orders.
- Primary and foreign keysIn relational databases, primary keys are unique identifiers for each data record in a table. Foreign keys are fields that reference primary keys from other tables to establish relationships. Understanding these concepts is critical to designing efficient data structures in FileMaker.
- Layouts and viewsFileMaker offers different layouts to display data in different ways. One layout might be optimized for data entry, while another layout is used to display reports. You can customize layouts to meet the specific needs of your application.
- Scripting and automationScripting is one of the most powerful features of FileMaker. Scripts allow you to automate repetitive tasks, create complex workflows, and control how users interact with the database. Learning basic scripting techniques is an important step in getting the most out of FileMaker.
- Reports and data analysisFileMaker allows you to create reports that analyze and visualize your data. You can design reports to provide exactly the information you need and export this information in various formats such as PDF or Excel.
gFM-Business Open Source FileMaker Basis-ERP
The software for the crash course
Download for free
Tips and best practices
To get the most out of your first experience with FileMaker, you should follow some best practices and tips:
- Planning is the keyBefore you start creating a database, you should take the time to analyze your requirements and develop a concept for your database. Good planning can avoid problems later on and make the development process more efficient.
- ModularityTry to make your database structure as modular as possible. This means that you divide functions and data into manageable, reusable components. This not only makes it easier to maintain your database, but also allows for easier expansion and customization.
- Testing and validationTest your database regularly during development to ensure that everything works as expected. Validate the input data to avoid errors and thoroughly test the functionality of your scripts.
- SecurityThink about the security of your data at an early stage. FileMaker offers extensive security functions that you should use to protect your database from unauthorized access. This includes setting up user accounts with different authorization levels and encrypting sensitive data.
- Continuous learningFileMaker is a powerful platform with many advanced features. Use the extensive online resources, tutorials and forums to continuously expand your knowledge and learn new techniques.
Frequently asked questions about setting up FileMaker
- How do I install FileMaker on my computer?
- To install FileMaker, download the installation file from the official Claris website. After downloading, open the installation program and follow the instructions. Make sure that you meet the system requirements and have your license key to hand.
- Do I need a special license to use FileMaker?
- Yes, you need a valid license to use FileMaker. You can either purchase a single-user license for local use or a multi-user license for team use. There are also options for FileMaker Cloud if you want to host your database online.
- How do I start FileMaker after installation?
- After installation, you can start FileMaker by double-clicking on the program icon. The first time you start the program, you will be asked to enter your license key to activate the program.
- How do I create a new database in FileMaker?
- To create a new database, open FileMaker and select "New database". You can create an empty database or use one of the templates provided. After saving the file, you can immediately start creating tables and fields.
- Can I import existing data into FileMaker?
- Yes, FileMaker supports the import of data from various formats, such as Excel, CSV, XML and ODBC data sources. To do this, open your database and select "File" > "Import records" from the menu. Then select the data format and the file you want to import.
- How do I set up fields and tables in a new FileMaker database?
- Once you have created a new database, you can add new tables and fields via the "File" > "Manage database" menu. Here you can also define the field types, such as text, number, date or container, e.g. to save files or images.
- What is the FileMaker user interface (GUI) and how do I use it?
- The FileMaker user interface is divided into different areas. At the top is the menu bar, which you can use to control all functions. On the left you will see the layout navigation, which you can use to switch between different views. The middle area shows the data records and forms that you are currently editing. You can customize the GUI and create your own layouts.
- How do I create layouts in FileMaker?
- In FileMaker, layouts are the user interfaces that you and other users use to enter and display data. You can create new layouts via the "Layout" > "Layout mode" menu. There you can arrange various fields, text, images and buttons to customize the layout to your needs.
- Can I share FileMaker databases with multiple users?
- Yes, you can share your FileMaker databases with multiple users by using a FileMaker Server or FileMaker Cloud. Alternatively, you can also share your database in peer-to-peer mode if all users are on the same network. Please note that a stable network connection is important for multi-user use.
- How do I secure my FileMaker database?
- FileMaker offers an integrated data backup function. You can create backups manually via "File" > "Backups" or set up an automatic backup strategy with a server. It is recommended that you create backups regularly to avoid data loss.
1.2 First steps with FileMaker
Menu
