Filemaker examples. What is FileMaker Pro

Youtube

Most of the innovations implemented in FileMaker 12 products, to one degree or another, reflect the desire of developers to “mobilize” their platform.

Many of the proposed improvements are aimed at small and medium-sized businesses that would like to better integrate mobile devices into their existing workflows. Enterprises will have simple, reliable tools at their disposal to create and deploy professional-grade databases without writing any code.

Users are provided with enhanced capabilities to use the built-in functions of tablets and smartphones. Among other things, Filemaker 12 Go provides the ability to quickly place video and audio materials recorded on a mobile phone in fields of the “container” type. As a reminder, in previous versions these fields could be used to store snapshots, captions, and GPS data.

Portable device support is also included in the server editions of FileMaker 12 Server and FileMaker 12 Server Advanced, which now support streaming large files, including images, audio, video and PDF documents, to the mobile client.

FileMaker Pro 12 includes new themes and templates, powerful app design tools for iPad, iPhone, and desktop PCs, and file management tools for modern, media-intensive apps. FileMaker Pro 12 Advanced includes additional authoring and project management tools.

FileMaker Go 12 apps for iPad and iPhone are available for free through the App Store. At the moment, these applications are not Russified. The free download of FileMaker Go 12 allows anyone to easily work on iOS with database applications built in FileMaker Pro 12.

The new 64-bit versions of FileMaker Server 12 and FileMaker 12 Server Advanced improve WAN performance, expand support for large databases, and enable fast file and media streaming.

Key localization elements for Central European and Middle Eastern versions:

localized interface in Czech, Russian and Turkish;
templates in Hebrew, Arabic, Polish, Czech, Russian and Turkish;
instant online publishing function in Hebrew, Arabic, Hungarian, Greek, Polish, Czech, Russian and Turkish;
Dictionaries and spell checker for Czech, Slovak, Hungarian and Polish.
Mirror layout feature allows users to switch from a left-to-right layout to a right-to-right layout with one click (for MENA countries).

With FileMaker Pro 12, every user can create databases without much difficulty. 16 new standard tasks speed up the creation of databases for managing contacts, projects, digital content, inventory and other critical business tasks. Typical tasks include pre-made screens optimized for iPad and iPhone. Users can change the appearance of applications using 40 new themes. Themes can be used with common tasks or applied to existing databases. Custom Touch themes designed specifically for iPad and iPhone, featuring fonts, colors, buttons, and other iOS design elements.

Users can build apps entirely from pre-built themes or customize every detail with new design tools like gradients, image cropping, dynamic alignment guides, and custom grids. Special screen stencils make it easier to display information on iPad and iPhone screens.

FileMaker Pro 12 includes a new Quick Charts tool for instantly creating visual charts, as well as five new chart styles: bubble charts, scatter charts, positive and negative charts, stacked bar charts, and stacked bar charts.

Improved container fields in FileMaker Pro 12 support saving many file types such as PDF, video, photos, audio and documents using drag-and-drop functionality. Files can be stored in a database or linked. Managing linked files is easier because FileMaker 12 now automatically organizes files on disk and can encrypt them for added security.

The new 64-bit versions of FileMaker Server 12 and FileMaker Server 12 Advanced are optimized for fast data processing. Improved WAN performance makes remote work easier, especially for iOS device users. A modified web publishing engine improves the speed and stability of integrating custom web pages with FileMaker databases, while consistent backups simplify server administration and improve solution reliability.

Users of corporate licenses with active maintenance will have the opportunity to upgrade to version 12 of FileMaker for free in May.

2014: FileMaker 13

On December 19, 2013, the FileMaker company introduced version 13 of the FileMaker DBMS.

On March 18, 2014, sales of the FileMaker 13 DBMS, localized for Russia and Central European countries, began in Russia and the CIS countries.

Description of changes and innovations

For a small company, it is possible to organize shared access to the database for 5 other users of FileMaker Pro or FileMaker Go using FileMaker Pro. To provide access to more users, FileMaker Server is required. FileMaker Server 13 features increased security, more flexible data sharing capabilities, including support for running solutions in the browser using the new FileMaker WebDirect technology.

Innovations and additions

Among the innovations:

create custom browser-based business solutions using FileMaker WebDirect;
new capabilities for iOS development and an optimal work environment for iPad and iPhone through special features (pull-out panels, secondary screens, support for barcode scanning, scrolling gestures, keyboard types, script triggers and other features designed specifically for iPad and iPhone) ;
creating more functional business solutions using new features (such as field selection, custom styles, managing the visibility of layout objects);
guarantee of data protection thanks to a modern encryption system based on industry standards.

Additions of functions, tools:

FileMaker Pro 13 includes improved container fields in layouts. The Get Container Attribute function automatically returns metadata for elements stored in container fields. Depending on the element stored in the container field, more than 40 attributes can be returned (file name, file size, title, model, artist, album, genre, composer, height, width, latitude, longitude, creation date, modified date, stroke -codes, etc.).

The main innovation in FileMaker Server 13 is the FileMaker WebDirect component. This web-based technology enables customized business tasks to be completed directly from the browser without requiring the user to have web development skills. FileMaker WebDirect allows you to eliminate the need for PHP, HMTL5, CSS and JavaScript programming languages to create a web solution.

A new administration console has appeared. The console has been rewritten in HTML5 to provide quick and easy access from any browser. Performing administrative tasks now requires less time, and updating the database status is faster.

Buyers of FileMaker Pro 12, during the transition period, and FileMaker users with an active subscription to updates will receive the new version free of charge. Other FileMaker Pro owners can purchase upgrade versions at a discount.

Licensing

The new version of the product has changed the licensing of access to the server. To connect to FileMaker Server 13 using a browser or FileMaker Go for iPad and iPhone, you must purchase connection licenses

Compatibility

Windows XP and Mac OS X 10.6 (Snow Leopard) are not supported by FileMaker Pro 13. Users of these OS versions will need to upgrade when upgrading to FileMaker Pro 13.

Size: px

Start showing from the page:

Transcript

1 FileMaker Installation and New Features Guide for FileMaker Pro 12 and FileMaker Pro 12 Advanced

2 FileMaker, Inc., All rights reserved. FileMaker, Inc. Patrick Henry Drive Santa Clara, California FileMaker and Bento are trademarks of FileMaker, Inc., registered in the United States and other countries. The file folder logo and the Bento logo are trademarks of FileMaker, Inc. All other trademarks are the property of their respective owners. FileMaker documentation is protected by copyright. You may not make additional copies of this documentation or distribute it without the written permission of FileMaker. This documentation may only be used with a valid, licensed copy of the FileMaker software. All persons, companies, email addresses and URLs listed in the examples are completely fictitious and any resemblance to existing persons, companies, email addresses and URLs is completely coincidental. A list of creditors is provided in the Acknowledgments documents supplied with this software. Mention of third party products and URLs is for informational purposes only and does not constitute an endorsement or recommendation. FileMaker, Inc. is not responsible for the performance of these products. For more information, visit our website Revision: 1

3 Contents Chapter 1 Before You Begin 5 About FileMaker Documentation 5 Customer Support and Knowledge Base 6 Technical Assistance 6 Update Notification 6 New Version Notification 7 About the License Key 7 Feature Requirements on Windows 9 Feature Requirements on Mac OS 10 Features not supported on Windows 10 Features not supported on Mac OS 10 Converting a trial version of FileMaker Pro to a full version 11 Upgrading FileMaker Pro from a previous version 11 Opening files from previous versions 12 Updating a custom dictionary 12 Installing with a volume license 12 Chapter 2 Installing FileMaker Pro on Windows 13 Installation Notes 13 Installing FileMaker Pro 14 Registering FileMaker Pro 15 Installing FileMaker Pro from the Command Line 15 About Installing Bonjour 15 Where to Place Files on Your Hard Drive 16 Uninstalling, Editing, and Restoring FileMaker Pro 16 Changing FileMaker Pro Cache Size 17 What to do next 18 Chapter 3 Installing FileMaker Pro on Mac OS 19 Installation Notes 19 Installing FileMaker Pro 20 Registering FileMaker Pro 20 Viewing the Installation Log File 21 Uninstalling FileMaker Pro Setting the FileMaker Pro Cache Size 21 What to Do Next 22

4 4 Chapter 4 What's New 23 New Structure and Layout Controls 23 Improved Performance and Usability 24 Enhanced Reporting and Analysis Features 25 Integration with Other Applications and Data Sources 26 Script Steps, Script Triggers, and Functions 26 Script Steps 26 Script Triggers 27 Functions 28 Features changed and removed 29 Features changed in FileMaker Pro 29 Features removed from FileMaker Pro 30 FileMaker Pro 12 Advanced 31

5 Chapter 1 Before You Begin Welcome to FileMaker! FileMaker Pro makes information management easy and efficient. About FileMaker Documentation This Installation and New Features Guide will tell you how to install FileMaker Pro 12 or FileMaker Pro 12 Advanced on your Windows or Mac computer and introduce you to what's new in the software. Note. This guide uses the name "FileMaker Pro" to refer to both FileMaker Pro and FileMaker Pro Advanced unless it describes features unique to File Maker Pro Advanced. The FileMaker Pro User Guide contains the information you need to get started with productivity right away. If you're new to FileMaker Pro, check out the FileMaker Pro Tutorial to learn the basic features of the application. For details and complete step-by-step procedures, see FileMaker Pro Help. The Design Guide for FileMaker Pro Advanced describes the advanced features available in FileMaker Pro Advanced, including customizing menus, copying and importing tables, database design reports, and monitoring fields, variables, and expressions using the Data Viewer. Note. If a feature or procedure is limited to a specific platform, instructions and illustrations that also apply to that platform are displayed. For features and procedures that are similar on both platforms, illustrations are provided for either Windows or Mac OS. To view and download documentation for FileMaker, visit To provide feedback on this tutorial, visit

6 6 Before You Begin Customer Support and Knowledge Base Select the menu command Help > Resource Center to access the following components: ready-made solutions; videos and tutorials; user history; forums and other support tools. To access the FileMaker knowledge base, visit To view system requirements, visit Note. The FileMaker knowledge base and software forums are not available in all languages. Technical Assistance FileMaker technical support representatives can assist you with installation, startup, or reinstallation (excluding data recovery) if your hardware configuration meets the software's minimum system requirements. Visit Update Notification FileMaker Pro 12 automatically checks for software updates every seven days. If your computer is connected to the Internet, you can go to the updates web page and download the software update. You can update later by selecting Help > Downloads and Updates. Note. This feature does not install software. You must be connected to the Internet to access the updater and download it.

7 7 To turn off update notification, do one of the following: In the Update Notification dialog box, select the Don't check for updates automatically check box. On Windows, select Edit > Preferences. On Mac OS, select FileMaker Pro menu > Preferences. On the General tab, clear the Notify me when an update is available check box. To turn update notification back on, select this check box. If you disable update notification, the Update Notification dialog box will not appear. New Version Notification FileMaker Pro 12 automatically checks for new software versions every 30 days and notifies you when a new version becomes available. To turn off new version notification, do one of the following: In the New Version Notification dialog box, select the Do not notify me about new versions again check box. On Windows, select Edit > Preferences. On Mac OS, select FileMaker Pro menu > Preferences. On the General tab, clear the Notify me when a new version is available check box. To turn the new version notification back on, select this option. If you disable New Version Notification, the New Version Notification dialog box will not appear. About the License Key FileMaker software is distributed with a unique 35-character alphanumeric license key. Don't lose this key. It is recommended that you keep the license key in a safe place in case you ever need to reinstall the software. License keys are located on the back of the DVD sleeve. If you install software using an electronic download, follow the instructions in your order confirmation email. A valid license key is required to install the software.

8 8 Before You Begin The license key ensures compliance with the FileMaker Pro or FileMaker Pro Advanced software license, which permits one (1) copy of the software to be used on one computer at a time, along with a second copy for use on a home or laptop computer, subject to license restrictions. for software. For more information, see the FileMaker Pro or FileMaker Pro Advanced software license located in the appropriate installation folder. If there is another copy of the application running on the network that is installed with the same license key, FileMaker Pro displays the following error message: "This copy of FileMaker Pro is currently being used by the maximum number of licensed users." To install FileMaker Pro on multiple computers, you will need a unique license key for each installation or a multi-computer volume license. You must license one copy of FileMaker Pro on each computer.

9 9 Feature Requirements on Windows Some features of FileMaker Pro for Windows require the installation of additional software. Feature Send Email Script Step Using Mail Application Phone Dialing ODBC and JDBC Features Inserting QuickTime Video Files and Image Files Software Requirement Microsoft Outlook Express, Windows Mail, Windows Live Mail, or Office Mail This requirement does not apply to SMTP mail. Telephone dialer or other Telephony Application Interface (TAPI) compatible software The FileMaker ODBC and JDBC drivers are located in the xdbc folder of the installation disk image, as well as in the FileMaker knowledge base on the Learn more about using ODBC and JDBC features page see the FileMaker ODBC and JDBC Guide and the FileMaker Pro Help. For more information about using third-party ODBC and JDBC drivers, see QuickTime 7.5 Software (available at

10 10 Before You Begin Feature Requirements for Mac OS Some features of FileMaker Pro for Mac OS require the installation of additional software. Feature Send Message Script Step Using Mail Application ODBC and JDBC Features Software Requirement Apple Mail, Microsoft Entourage, or Microsoft Outlook 2011 This requirement does not apply to sending mail via SMTP. Actual Technologies ODBC Manager (available at is free software and is not supported by FileMaker. The FileMaker ODBC and JDBC drivers are located in the xdbc folder of the installation disk image, as well as in the FileMaker Knowledge Base at For more information about using ODBC and JDBC features, see: See the FileMaker ODBC and JDBC Guide and the FileMaker Pro Help. For more information about using third-party ODBC and JDBC drivers, see Importing files from Bento Bento 2 or a newer supported version (available at Features not supported in Windows On Windows, FileMaker Pro does not support Execute AppleScript and Speech script steps, nor does it support importing files from Bento. Features not supported on Mac OS On Mac OS, FileMaker Pro does not support Phone Dial script steps and “Sending a DDE command to execute.”

11 11 Export to Excel: Exporting to .xls format requires Rosetta, which is not available on OS X Lion. Converting a trial version of FileMaker Pro to a full version If you have a trial version of FileMaker Pro 12 installed, you can convert the software to a full version without first uninstalling the trial version. You can also upgrade your retail copy of FileMaker Pro version 9, 10, or 11 to the full version of FileMaker Pro 12 by entering your upgrade license key during the trial conversion process. Upgrading FileMaker Pro from a Previous Version If you are upgrading FileMaker Pro from a previous version, it is recommended that you upgrade to the new version before uninstalling the previous version. To upgrade FileMaker Pro from a previous version, follow these steps: 1. Install the update using the 35-character license key located on the back of the DVD sleeve, or the key emailed to you along with the download link. 2. Move your plugins, dictionary data, and your settings to the new version of FileMaker Pro. For information about how to move installations, see the FileMaker Knowledge Base at 3. If you plan to use only the latest version, uninstall the previous one. If you choose to uninstall a previous version before upgrading to the newest version, make sure you have a license key for the previous version. When you install FileMaker Pro with an upgrade license key, the installer searches your hard drive for the previous version. If a previous version is not found, you are prompted to enter the license key for the previous version of the product.

12 12 Before You Begin Opening Files from Previous Versions of FileMaker Pro 12 opens files created in FileMaker Pro versions 7.x, 8.x, 9.x, 10.x, or 11.x. But to use files with FileMaker Pro, you must convert them to the FileMaker Pro 12 file format. For more information about converting files, see FileMaker Pro Help. Updating a custom dictionary If you added words to a custom dictionary in a previous version of FileMaker Pro, you can use it in FileMaker Pro 12. For more information about converting a custom dictionary, see FileMaker Pro Help. Volume License Installation If you are installing multiple copies of FileMaker Pro under a volume license, or if you want to install without human intervention, you can automate the process. To skip the standard installation dialog boxes, use the Assisted Install.txt file on the disk image. For more information, see the FileMaker Pro Network Installation Guide. For volume licensing information, visit

13 Chapter 2 Installing FileMaker Pro on Windows Before proceeding with the installation process, save any open files and close all applications. For the latest information and release notes about FileMaker Pro, visit Installation Notes Before you begin installing FileMaker Pro, please read the following notes. To install FileMaker Pro, you must have administrator access and log in with an administrator username and password. If your computer is running antivirus software, disable it before installing FileMaker Pro. Once the installation is complete, you can turn it back on. By default, FileMaker Pro will be installed in the following folder: C:/Program Files/FileMaker/FileMaker Pro 12. You can change the installation drive and folder during installation. By default, FileMaker Pro Advanced will be installed in the following folder: C:/Program Files/FileMaker/FileMaker Pro 12 Advanced. You can change the installation drive and folder during installation. During the installation process, you can choose to install all components (Complete) or only selected program components (Custom). For example, you can disable the installation of some components to save disk space. At the beginning of the installation, the user selects the language of the FileMaker Pro installer. The default selection matches the operating system language. A full installation installs only the version for the selected language. To install versions for other languages, use Custom installation mode to select language packs for other languages from the list of supported languages.

14 14 Installing FileMaker Pro on Windows Before installing an update or downgrading, FileMaker will scan all hard drives and drives connected to your computer for the previous version. If your computer has many disks, this may take several minutes. Installing FileMaker Pro Installing FileMaker Pro must be done using the installer. FileMaker Pro cannot be installed by simply copying files to your hard drive. If you want to create an installation log that contains a list of registry entries and installed file paths, FileMakerPro must be installed from the command line. See “Install FileMaker Pro from the Command Line” on page 15. To install FileMaker Pro to your hard drive, do the following. 1. Do one of the following: If you received the software electronically, after downloading the file, double-click the installation icon (EXE file); If you are installing FileMaker Pro from a DVD, insert it into your DVD drive, open the FileMaker DVD window, and click the install icon. Install Application Click to view DVD contents Exit 2. Install FileMaker Pro by following the onscreen instructions. For more information about installation, see "Installation Notes" on page Once installation is complete, click Finish. The Product Registration dialog box appears.

15 15 Registering FileMaker Pro Take the time to register your copy of the product. Registering FileMaker makes it possible to get help recovering your license key if it is lost. Plus, you'll receive earlier notifications about updates, new software versions, and special offers. Enter product information, registration information, and additional information when prompted. If you are using a trial version of FileMaker Pro, you must register it before you can start using it. You can also do this using the Help > Register FileMaker Pro menu item. Installing FileMaker Pro from the Command Line To install FileMaker Pro from the command line and create an installation log, follow these steps. 1. Insert a DVD into the drive. 2. Open a command prompt window. 3. Enter the following command line: E:\Files\setup.exe /v /Lr C:\FMP12InstallLog.txt where E: DVD drive. If your DVD drive is assigned a different drive letter, enter that letter instead of E. 4. Follow the onscreen instructions. The FMP12InstallLog.txt file will be created in the root directory of the hard drive. It can be viewed in WordPad or any other text editor. About installing Bonjour Bonjour provides automatic discovery of computers, devices, and services on IP networks. It must be installed on your system to detect remote hosts. If the Bonjour service is not installed or running, FileMaker Pro will not be able to discover remote networks. In particular, it will not be possible to browse internal databases in the Open Remote File dialog box and obtain a list of remote files for use as an external data source. Without Bonjour, you will have to manually enter IP addresses for remote databases.

16 16 Installing FileMaker Pro on the Windows operating system During the installation of FileMaker Pro, the installation program works according to the following algorithm: if the Bonjour service is not detected, the installation program warns about this and offers to install it; If the Bonjour service is detected, but FileMaker does not support the installed version, the installer issues a warning about this and prompts you to manually remove the old version of Bonjour, and then manually install the version of Bonjour that is supported by FileMaker; If the Bonjour service is detected and a version supported by FileMaker is installed, the installer does not warn or install Bonjour. To manually install the Bonjour service, do the following. 1. Open the FileMaker Pro installation folder. 2. Open the Bonjour folder. 3. Open the folder for 32-bit or 64-bit, depending on your version of Windows. 4. Double-click the BonjourSetup icon. 5. Follow the onscreen instructions to install Bonjour. Where files are located on your hard drive The FileMaker Pro installer copies files to multiple folders on your hard drive, depending on the operating system version and the installation options you select. If you install from the command line and specify a log file to be created, the log file will indicate the location of each of the installed files. Uninstall, change, or repair FileMaker Pro You can uninstall, repair missing or damaged components, or change the set of installed FileMaker Pro components using the Add or Remove Programs (Windows XP) or Programs and Features (Windows Vista or Windows 7) control panel ). For more information, see Windows Help. When modifying or restoring FileMaker Pro, you may be prompted to enter a license key.

17 17 Changing the FileMaker Pro Cache Size FileMaker Pro provides internal caching of data from the database. Depending on the amount of memory on your computer, you may need to adjust the cache size to achieve optimal performance. It is worth increasing the cache size if you plan to: work with large database files; simultaneously work with several database files; place database files on your computer; insert large images into the database file. It is worth reducing the cache size if you plan to run several applications simultaneously in a small amount of random access memory (RAM). Note. Reducing or increasing the FileMaker Pro cache size reduces or increases the amount of memory required to run FileMaker Pro accordingly. For more information about memory management, see the documentation that came with your computer. To change the cache size used by FileMaker Pro, you must do the following: 1. In FileMaker Pro, select Edit > Preferences. The Preferences dialog box appears. 2. Open the Memory tab. 3. Enter a value in the Trying to set cache size box, and then click OK. The next time you start FileMaker Pro, the new cache size will be used.

18 18 Installing FileMaker Pro on Windows Operating System What to Do Next After installing FileMaker Pro, you can start using the application right away. Below are sections of the documentation that we recommend starting with. If you are new to databases, you can learn the basics of working with them in Chapters 2, Using Databases, and Chapter 3, Creating Databases, in the FileMaker Pro User's Guide. If you are new to File Maker Pro, take the classes in the FileMaker Pro Tutorial; The PDF file of the tutorial and examples are located in the “Tutorial” folder, which is nested in the “Russian Extras” folder. If you're already familiar with using FileMaker Pro, read Chapter 4, "What's New," in this guide to learn about the new features in FileMaker Pro 12. If you're using FileMaker Pro Advanced, see the FileMaker Pro Developer's Guide and FileMaker Pro Help.

19 Chapter 3 Installing FileMaker Pro on Mac OS Before proceeding with the installation process, save any open files and close all applications. For the latest information and release notes about FileMaker Pro, visit Installation Notes Before you begin installing FileMaker Pro, please read the following notes. To install FileMaker Pro, you must have administrator rights and log in with an administrator username and password. If your computer is running antivirus software, disable it before installing FileMaker Pro. Once the installation is complete, you can turn it back on. You can choose to install all program files (standard installation) or install a partial program (custom installation). For example, you can disable the installation of some components to save disk space. Standard mode installs the version of FileMaker Pro that matches the language version of the operating system. To install additional language versions, select the appropriate language packs in Custom installation mode. Before installing an update or downgrading, FileMaker will scan all hard drives and drives connected to your computer for the previous version. If your computer has many disks, this may take several minutes. You can also install FileMaker Pro using the command line or remotely using Apple Remote Desktop. For more information, see the FileMaker Pro Network Installation Guide.

20 20 Installing FileMaker Pro on Mac OS Installing FileMaker Pro Installing FileMaker Pro must be done using the installer. FileMaker Pro cannot be installed by simply copying files to your hard drive. Installing FileMaker Pro on your hard drive 1. Do one of the following. If you received the software electronically, after downloading it, double-click the disk image icon (.dmg file). If you are installing FileMaker from a DVD, insert the DVD into your DVD drive and open the FileMaker DVD window. 2. Find and double-click the FileMaker Pro installation icon. FileMaker Pro Installation Icon 3. Install FileMaker Pro by following the on-screen instructions. For more information about installation, see "Installation Notes" on page Once installation is complete, the Product Registration dialog box appears. Registering FileMaker Pro Take the time to register your copy of the product. Registering FileMaker software allows you to get help recovering your license key if you lose it. Plus, you'll receive earlier notifications about updates, new software versions, and special offers. Enter product information, registration information, and additional information when prompted. If you are using a trial version of FileMaker Pro, you must register it before you can start using it. You can also do this using the Help > Register FileMaker Pro menu item.

21 21 Viewing the installation log file To view and save the installation log file, select the Window > Installer Log menu in the program window. You can view error messages along with progress messages, just error messages, or all available installation messages. Uninstalling FileMaker Pro 12 To uninstall FileMaker Pro 12, follow these steps. 1. Drag the FileMaker Pro 12 or FileMaker Pro 12 Advanced folder from the Applications folder to the Trash along with all its contents. 2. Drag the FileMaker Pro or FileMaker Pro Advanced preferences file to the Trash. The settings are in the following file. For FileMaker Pro: /library/preferences/com.filemaker.client.pro.plist For FileMaker Pro Advanced: /library/preferences/com.filemaker.client.advanced.plist Setting the FileMaker Pro Cache Size Because Mac OS dynamically allocates memory for applications as needed, it is impossible not to allocate a certain amount of memory to FileMaker Pro. However, you can adjust the FileMaker Pro cache size. It is worth increasing the cache size if you plan to: work with large database files; simultaneously work with several database files; place database files on your computer; insert large images into the database file. It is worth reducing the cache size if you plan to run several applications simultaneously in a small amount of random access memory (RAM). You can change the cache size used by FileMaker Pro as follows.

22 22 Installing FileMaker Pro on Mac OS 1. In FileMaker Pro, select FileMaker Pro > Preferences and select the Storage tab. 2. Enter a value in the Attempt to set cache size field and click OK. The next time you start FileMaker Pro, the new cache size will be used. What to do next Once you install FileMaker Pro, you can start using the application right away. Below are sections of the documentation that we recommend starting with. For database basics, see Chapters 2, Using Databases, and Chapter 3, Creating Databases, in the FileMaker Pro User's Guide. If you've never used File Maker Pro before, take the lessons in the FileMaker Pro Tutorial. The PDF file of the tutorial and examples are located in the “Tutorial” folder, which is nested in the “Russian Extras” folder. If you're already familiar with using FileMaker Pro, read Chapter 4, "What's New," in this guide to learn about the new features in FileMaker Pro 12. If you're using FileMaker Pro Advanced, see the FileMaker Pro Advanced Developer's Guide and FileMaker Pro Help .

23 Chapter 4 What's New This chapter provides an overview of the new features and improvements made in FileMaker Pro 12. For more information about these features, see FileMaker Pro Help unless otherwise noted. New FileMaker Pro Themes Structure and Layout Controls: FileMaker Pro's architecture has been redesigned to support layout themes that are richer in functionality and more attractive. You can easily change the theme using the Layouts menu in Layout mode. Layout Object Formatting: FileMaker Pro has expanded the object formatter with features such as gradient fills, pattern fills including scaling and clipping, transparency, object properties, and rounded corners. To format an object, use themes instead of the default object styles without selected objects. You can remove styles from selected objects and control theme changes using multi-level undo. New layout assistance tools—dynamic alignment guides, guides that drag outside of rulers, and grid controls in Layout mode—will provide users with visual guidance for designing new layouts and modifying existing ones. Multi-level undo and redo allow you to experiment and improve your layout structure with ease. Screen Stencils: In Layout mode, you can click to display guides to design layouts that are optimal for iPad, iPhone, and general desktop solutions or set custom sizes.

What's in this Microsoft guide The look and feel of Microsoft OneNote 2010 is significantly different from OneNote 2007, and this guide is intended to help you get started with the new version of the program.

Getting Started with QuarkXPress 10.0.1 TABLE OF CONTENTS Table of Contents Related Documents...3 System Requirements...4 System Requirements: Mac OS X...4 System Requirements: Windows...4 Installation: Mac OS...5 Addition

Boot Camp Installation and Setup Guide Contents 3 Introduction 4 What you need 5 Installation 5 Step 1. Check for updates 5 Step 2. Prepare your Mac for Windows installation 5 Step 3.

User Manual Contents Introduction... 1 IMPORTANT NOTES... 1 Legal Notices... 2 Installation and Configuration... 3 System Requirements... 3 Installation... 3 Activation... 6 Automatic Updates...

Working with standard document templates Cognitive Technologies User Guide Moscow, 2015 2 ABSTRACT This document provides information about the use of the E1 Euphrates software package

Capture Pro Software Getting Started A-61640 Quick Start Guide to Alaris Capture Pro and Capture Pro Limited Edition Software Installing the Software: Software

Reference Integration Library Materials and Assortments and Systems AutoCAD User's Guide The information contained in this document is subject to change without notice. None

Step-by-step guide to upgrading to Windows 8.1 Installing and updating Windows 8.1 Updating the BIOS, applications, drivers, and running Windows Update Selecting an installation type Installing Windows 8.1

Electronic document management system A r h i v a r u s Installation manual Moscow, 2008 2 ABSTRACT This document provides a description of the delivery package of the software product “EUFRAT-Document Flow”

Acronis Backup & Recovery 10 Advanced Editions Quick Start This document describes how to install and run any of the following editions of Acronis Backup & Recovery 10: Acronis Backup & Recovery

Contents of this Microsoft Guide The Microsoft application has a very different appearance than Excel 2003, and this guide is intended to help you get started with the new version of the program. Read this

SOFTWARE INSTALLATION GUIDE USER GUIDE Page CONTENTS 1 ABOUT THE SOFTWARE 2 BEFORE INSTALLING 2 INSTALLING THE SOFTWARE 3 CONNECTING TO A COMPUTER

Quick Start Guide to Powersuite 2013 An all-in-one PC setup and optimization application with a full set of features and extensive customization options. Download and Install Powersuite Download

Acronis Backup & Recovery 11 Quick Start Guide Applies to the following editions: Advanced Server Virtual Edition Advanced Server SBS Edition Advanced Workstation Server for Linux Server for

EnergyCS Electrics Version 3 Installation and Activation Guide CSoft Development, 2012 ElectriCS ECP. Installation and activation guide page 2 Contents General information... 3 Commercial and evaluation

Quick Getting Started Guide The interface of Microsoft PowerPoint 2013 has changed from previous versions, and we've created this guide to help you get up to speed. Finding what you need

LASERJET ENTERPRISE COLOR FLOW MFP M575 Quick Start Guide Printing a Stored Job Follow these steps to print a job stored in the machine's memory. 1. From the control panel home screen

Description of the ViPNet Business Mail Program The ViPNet Business Mail program (or simply “Business Mail”) is designed for organizing electronic document flow in the secure ViPNet network. With the help of "Business

Support modules for CryptoPro CSP 2018 Aktiv Company General information. The Aktiv company has developed ready-made solutions that provide integration of Rutoken and various versions of CIPF CryptoPro CSP. Installation

English MF Driver Installation Guide User Software CD....... 1 About Drivers and Software...... ....................................

Electronic document management system A r h i v a r i s Installation manual Moscow, 2009 2 ABSTRACT This document provides a description of the delivery package of the software product “EUFRAT-Document Flow”.

Boot Camp Installation and Setup Guide Contents 3 Introduction 4 Installation 4 Step 1: Check for updates 4 Step 2: Prepare your Mac for Windows 4 Step 3: Install Windows

Complete performance management Compatible with Windows XP and Windows Vista 2013 Boost your productivity and take care of your PC's health with one powerful, flexible app.

To upgrade a computer running Windows XP to Windows 7, you will need to perform a full installation, which does not save any programs, files, or settings. For this reason

Microsoft Windows 7 / Vista / XP / 2000 / Home Server / NT4 (Service Pack 6) Quick Start Guide ESET NOD32 Antivirus provides state-of-the-art protection

Quick Getting Started Guide The interface of Microsoft OneNote 2013 has changed from previous versions, and we've created this guide to help you get up to speed. Switching

T.V. Glotova Guidelines for performing practical and independent work section Basics of working with the office suite OpenOffice.org 3.2 Part 6 History of OpenOffice.org. Platforms and system requirements

Readme file for Veritas System Recovery 16 Management Solution About the readme file System requirements for Veritas System Recovery 16 software delivery policies System requirements for Veritas

AutoLiquidator Version 1.1 Installation and registration of the program 2005-2006 Russian Information Technologies 1. Introduction This document is a guide to installation and configuration of the software product

About Microsoft Office Word 2007 files Microsoft Office 2007 introduces a new file format based on the XML language. By default, documents created in Word 2007 are saved with a new file name extension,

2017 Electronics For Imaging, Inc. The information in this document is subject to the Legal Notice for this product. November 25, 2017 Contents 3 Contents Fiery Review

Qlik Sense Desktop Qlik Sense 1.1 QlikTech International AB 1993-2015. All rights reserved. QlikTech International AB 1993-2015. All rights reserved. Qlik, QlikTech, Qlik Sense, QlikView, Sense and logo

2014 Electronics For Imaging. The information in this document is subject to the Legal Notice for this product. June 23, 2014 Contents 3 Contents...5 Access to the program...5

LASERJET ENTERPRISE MFP Quick Start Guide M725dn M725f M725z M725z+ Printing a Stored Job Follow these steps to print a job stored in the machine's memory. 1. On the home screen

Boot Camp Installation and Setup Guide Contents 3 Introduction 3 What you need 4 Installation 4 Step 1. Check for updates 4 Step 2. Prepare your Mac for Windows installation 4 Step 3.

IBM SPSS Statistics for Mac OS Installation Instructions (Single User License) The instructions below are for installing IBM SPSS Statistics version 19 using a single user

P-touch Transfer Manager Instructions Be sure to read this online user's guide before using the printer. It is recommended to keep it on hand

Universal Driver Guide Brother Universal Printer Driver (BR-Script3) Brother Black and White Universal Printer Driver (PCL) Version

SMART Sync 2011 Quick Start Guide Incredible Made Simple Product Registration Once you register your SMART product, we'll keep you posted on new features and software updates.

English MF Driver Installation Guide User Software CD........ 1 About Drivers and Software................... ...................................

User Manual Contents Introduction... 1 IMPORTANT NOTES... 1 Legal Notices... 3 Installation and Configuration... 5 System Requirements... 5 Installation... 5 Activation... 7 Automatic Updates...

Small Office Security 2 Installing Kaspersky Small Office Security 2 on a personal computer Contents Contents... 1 Installing Kaspersky Small Office Security 2 on a personal computer... 2 Quick

Starting the P touch Editor Before using the printer, be sure to read this online user's guide. It is recommended to keep it on hand for later use.

Upgrading from Windows Vista to Windows 7 Depending on your hardware and the current edition of Windows Vista, during the Windows 7 installation process you may be able to use the Upgrade option to upgrade

Support modules for CryptoPro CSP 2014 Company "Active" Rutoken for CryptoPro CSP. The Aktiv company has developed ready-made solutions that provide integration of Rutoken and various versions of CIPF CryptoPro CSP. Installation

Installation Instructions for IBM SPSS Modeler Server 16 for Windows Contents Installation Instructions....... 1 System Requirements........ 1 Installation...... .. 1 Destination............... 1 IP address

APPROVED PBKM.33314-01 34 01-LU PC "Energosphere". Installer Operator's Manual PBKM.33314-01 34 01 Sheet 37 2008 Contents 1. INTRODUCTION... 3 2. TECHNICAL REQUIREMENTS AND USER TRAINING LEVEL...

Microsoft Office Excel 2007 Files Microsoft Office 2007 introduces a new file format based on the XML language. By default, documents created in Excel 2007 are saved with a new file name extension,

OJSC "InfoTeKS" Appendix to the ViPNet documentation version 3.1 FRKE. 00044-04 90 05 MOSCOW 2010 2 1991 2010 JSC "Infotex", Moscow, Russia. This document is included with the software

Using Conference Manager for Microsoft Outlook May 2012 Contents Chapter 1. Using Conference Manager for Microsoft Outlook... 5 Introduction to Conference Manager

This article opens a series of articles by Igor Shichko about the FileMaker system

General information about the DBMS "FileMaker»

The FileMaker database management system was developed by a company of the same name “FileMaker”, which in turn is a subsidiary of the well-known Apple company. At the time of publication of this article (August 2015), the 14th version of this DBMS was released.

Let's consider the main features of the FileMaker DBMS, taking into account existing ideas about databases in general.

First of all, it should be noted that this DBMS is multi-system, i.e. can be installed both on computers with Windows installed (IBM PC) and on PCs with Mac OS X installed (Apple computers).

The first feature of this system are valid database field types. There are very few of them, unlike other systems:

— Number– for number format data

— Text– for text format data

— Date– for fields containing date

— Time– for fields containing time

— Timestamp- a very convenient type of field that contains a time stamp (date and time)

— Container– a container type field that can store a fairly wide range of data (files of various types, images, videos, etc.).

Thus, the user does not have to think long about the structure of the database in terms of determining field types. If it is necessary to take into account numeric data, then, regardless of its format (integer, decimal, etc.), a field of type Number is used. Text data is also taken into account regardless of the length of the text. This field type (Text) supports message size up to 2 GB.

You should also pay attention to the remaining two types of fields:

— Calculation– calculated field, allows you to create a calculated database structure based on existing fields.

— Summary– summing field, calculates the sum of accounting data by columns (fields) of the database.

These two above field types (Calculation and Summary) are very convenient to use when creating various types of reports.

In addition, the FileMaker system allows you to use each field as a composite of several values, the so-called repeating field, which is of no small importance when developing reports and displaying their results.

The second feature What I would like to focus on is the development of forms for displaying credentials.

The system developers have simplified the interface design algorithm as much as possible to present data in a user-friendly form. Placing a field on the form takes literally two button clicks (Select operation + Select field). In addition, all formatting options for the information displayed on the screen (location, fonts, fills, etc.) are available in the same view.

The database developer interface in terms of designing the data layout includes four types of information presentation:

— Browse– viewing information on the PC screen

— Find– enable information search mode

— Layout– enable form design mode

—Preview– preview of the form, i.e. how the document will appear when printed, depending on the page and printer settings.

Accordingly, switching between modes is done by pressing one button, and it is also available via software, which we will briefly discuss below.

The third feature FileMaker database management system that I would like to focus on is the output data formats.

It was already noted above that FileMaker is a program that is not critical to the installed operating system. Therefore, the format of the output data provides for its use on any of these systems. Those. One user can enter data using the Windows operating system, and the same data can be exported and processed on a computer running Mac OS X.

Data output provides several formats. The most used and familiar to users are the *.pdf (Adobe Acrobat Reader) and *.xls (Excel) formats. Data stored in container-type fields can be exported to the corresponding file (image, video, file).

The layout of the PDF document is developed directly in the database structure, and accordingly, its preview is available.

And finally fourth feature of the FileMaker DBMS.

It is logical to include the wide possibilities and reasonable simplicity of developing program code for the database. Almost any procedure for sampling, exporting data, generating reports, provided for in the system menu, is available for automation.

The basis of program code development is writing scripts (scenarios, a certain sequence of actions performed). The script is based on the use of a wide range of predefined functions and calculated fields. Scripts can be created by a developer who is more or less familiar with the basics of algorithmization and school-level English.

In addition, FileMaker provides the opportunity for the developer to design some of his own functions, as well as use external libraries (plugins).

All features of the FileMaker database management system are not limited to those mentioned in this article. In the future, as we talk about the components of the DBMS and the methodology for working with them, we will dwell in more detail on these and many other features of this software that distinguish it from others, perhaps more widely used in Russia.

Creating a base, first steps, features of setting up access and developing a structure.

2.1. Creating a new database.

Creating a new database is possible in two main ways.

— To create a new database, select the menu item File – New Database…(in FileMaker 14 the menu item is named File – New Solution…) A form opens, indicating the name of the database to be created and its location. Select the drive, enter the name of the database to be created and click on the button "Save". A table with the name Table.

— The second way to create a database is based on the templates supplied with the software package. Select an item File– New From Starter Solution… In the window that opens, select the type of database template, and a new database file is created based on it. Depending on the version, the number of templates may vary (from 15 to 30).

This completes the first step of the FileMaker database creation procedure.

Creating a database structure.

To create and describe the database structure of the system, a menu item is provided File – Manage – Database… When you select this item, a window with three tabs opens. Let's briefly look at their description.

A) TabTables(Tables). This tab contains information about the tables contained in this database. The developer can perform the following actions:

- create a new table. To do this, enter the name of the table in the Table Name field and click the Create button. Another way to create a database table is by importing tables from external files. To do this, use the menu File – Import Records – File... FileMaker allows you to import from files of other FileMaker databases, Excel files, files with delimiters (such as *.csv or *.tab).

— change the table name. Select the table, enter a new name in the Table Name field, and click the Change button

— delete table. Having selected the table, click on the Delete button

- copy table. Select the table and click the Copy button. This will copy the table structure to the PC clipboard. If you then click on the Paste button, a table named Table 2 will be inserted (if the original one was Table).

- import table. To do this, click on the Import button. In the window that opens, select the external database file and the table in this file.

B) TabFields(Fields). This tab displays the structure of the fields of the selected table of the current database. I won’t dwell on the capabilities of this tab. They are similar to the capabilities of the Tables tab. These are the create, modify, copy, paste and delete functions. Only the function has been added Duplicate(Duplicate). This function combines the copy and paste functions into one.

B) TabRelationships. This tab displays the structure of the entire database in graphical format. At the bottom of this tab there is a menu for managing the database structure. Let's look at the main functions available from this interface. They are divided into three categories:

— Add table– adding a table to the database structure

— Establishing a new connection– allows you to organize a new connection between fields of different data tables

— Duplicate table– allows you to create a copy of the selected data table. It should be noted that not a physical copy of the table with data is created, but a logical one. In this case, the system requests a new table name in the structure. Those. physically there can be one table (Table), but logically there can be several (Table1, Table2, etc.). This structure is very convenient when creating various reports and calculating results for any parameter. As the system developers themselves note, building a report means building certain connections between images of data tables.

— Edit table– allows you to change the logical name of the table and the data source for it.

— Delete table– performs a logical (not physical) deletion of a table from the graphical interface.

— horizontal alignment– includes center, left and right alignment functions

— vertical alignment– includes center, bottom and top alignment functions

— distribution– includes horizontal and vertical distribution functions

— change of size– bringing all selected objects to one of six parameters (the smallest in width, in height, in width and height, the largest in width, in height, in width and height).

I note that the functions of this subgroup are used for two or more selected objects and are aimed at creating a readable appearance of a graphical image of the database structure.

— table color– allows you to change the color of the selected table(s) to visually highlight groups of tables in the graphical interface.

— graphics mode button / text mode button– two buttons designed to work with graphic and text elements. FileMaker provides the ability to include table descriptions in the GUI. To create an inscription, there is a button to switch to text mode.

— Increase/Decrease/Normal buttons– three buttons for controlling the interface display scale.

— scale display window (in percent)

— button to display pagination

— print settings button

Thus, using the three tabs described above, the structure of database tables is created and configured, fields are created and described.

Setting up database access

The FileMaker database management system provides a fairly wide range of customization options for limiting access to data.

To configure data access restrictions, use the menu File – Manage – Security. This opens a window with four tabs. Let us briefly describe their purpose.

Tab Accounts– designed to add and edit the list of database users. This panel contains the New, Edit, Duplicate, Delete buttons. They are respectively intended for creating a new user, editing the access parameters of a selected user, duplicating a user (with all access parameters), and deleting a user.

Tab Privilege Sets– designed to add and edit types of privileges. By default, three types of privileges are configured in the database:

— Full Access- full access

— Data Entry Only– reading, writing, deleting all records without the ability to develop a data structure

— Read— Only Access– read-only access to data.

Creating a new type of privilege.

The database administrator can also add his own privilege type. To do this, click on the New button. A window will open Edit Plivilege Set.

In field Privilege Set Name specify the name of the privilege type to be created. In a group of fields with a common name Data Access and Design access to database records (Records field), views (Layouts field), lists of values (Value Lists field), scripts (Scripts field) is configured. In each of these fields, you can fine-tune user access. For example, setting up access to individual fields of a database table, individual views, etc. This allows you to limit user access to data without disrupting system operation.

Note: it is necessary to understand that in the structure of the DBMSFileMakeraccess to data is carried out through views (Layouts). Thus, data from any table can be read (edited) only through the appropriate view.

Next on the access rights editing form there is a group of checkboxes under the name Extended Privileges(Extended Privileges). They are designed to organize access for this group of users to work through a WEB interface, through an ODBC connection, through a network connection, etc.

And finally, on the right side of the form there is a group of checkboxes called Other Privileges(Other privileges). With their help, a developer can configure access for a group of users to print ( Allow printing), data export ( Allow exporting), setting up extended access rights ( Manage Extended Privileges), the mode of checking the entered data, the mode of disconnecting users from the database, the mode of changing the password.

General information about the DBMS " FileMaker »

FileMakerdeveloped by a company of the same name "FileMaker", which in turn is a subsidiary of a well-known companyApple. At the time of publication of this article (August 2015), the 14th version of this DBMS was released.

Let's consider the main features of the DBMSFileMakertaking into account existing ideas about databases in general.

First of all, it should be noted that this DBMS is multi-system, i.e. can be installed on both computers withWindows ( IBM PC), and on a PC with installedMac OS X(computersApple).

The first feature of this system are valid database field types.There are very few of them, unlike other systems:

— Number – for number format data

— Text – for text format data

— Date – for fields containing date

— Time – for fields containing time

— Timestamp - a very convenient type of field that contains a time stamp (date and time)

— Container – a container type field that can store a fairly wide range of data (files of various types, images, videos, etc.).

Thus, the user does not have to think long about the structure of the database in terms of determining field types. If it is necessary to take into account numeric data, then, regardless of their format (integer, decimal, etc.), a field likeNumber. Text data is also taken into account regardless of the length of the text. This field type (Text) Supports message volume up to 2 GB.

You should also pay attention to the remaining two types of fields:

— Calculation – calculated field, allows you to create a calculated database structure based on existing fields.

— Summary – summing field, calculates the sum of accounting data by columns (fields) of the database.

These two above field types (CalculationAndSummary) are very convenient to use when creating various types of reports.

In addition, the systemFileMakerallows you to use each field as a composite of several values, the so-calledrepeating field , which is of no small importance when developing reports and displaying their results.

The second feature What I would like to focus on is the development of forms for displaying credentials.

The database developer interface in terms of designing the data layout includes four types of information presentation:

— Browse – viewing information on the PC screen

— Find – enable information search mode

— Layout – enable form design mode

— Preview – preview of the form, i.e. how the document will appear when printed, depending on the page and printer settings.

Accordingly, switching between modes is done by pressing one button, and it is also available via software, which we will briefly discuss below.

The third feature database management systemsFileMakerThe thing I would like to focus on is the output data formats.

It was already noted above thatFileMaker– a program that is not critical to the installed operating system. Therefore, the format of the output data provides for its use on any of these systems. Those. one user can enter data using the operating systemWindows, and the same data can be exported and processed on a computer withMac OS X.

Data output provides several formats. The most used and familiar to users are *.pdf( Adobe Acrobat Reader) And *.xls( Excel). Data stored in container-type fields can be exported to the corresponding file (image, video, file).

Document LayoutPDFis developed directly in the database structure, respectively, its preview is available.

AND , finally,fourth DBMS featureFileMaker.

Besides,FileMakerprovides the opportunity for the developer to design some of his own functions, as well as use external libraries (plugins).

All features of a database management systemFileMakerare not limited to those specified in this article. In the future, as we talk about the components of the DBMS and the methodology for working with them, we will dwell in more detail on these and many other features of this software that distinguish it from others, perhaps more widely used in Russia.

2. Creating a base, first steps, features of setting up access and developing a structure.

2.1. Creating a new database.

Creating a new database is possible in two main ways.

— To create a new database, select the menu itemFile – New Database… ( V versionsFileMaker 14paragraph menu named File – New Solution…) A form opens, indicating the name of the database to be created and its location. Select the drive, enter the name of the database to be created and click on the button"Save" . A table with the nameTable .

— The second way to create a database is based on the templates supplied with the software package. Select an itemFile – New From Starter Solution … In the window that opens, select the type of database template, and a new database file is created based on it. Depending on the version, the number of templates may vary (from 15 to 30).

This is the first step of the database creation procedure.FileMakercompleted.

2. Creating a database structure.

To create and describe the database structure of the system, a menu item is providedFile – Manage – Database … When you select this item, a window with three tabs opens. Let's briefly look at their description.

A) Tab Tables (Tables). This tab contains information about the tables contained in this database. The developer can perform the following actions:

- create a new table . To do this in the fieldTable Nameenter the table name and click the buttonCreate. Another way to create a database table is by importing tables from external files. For this purpose the menu is usedFile – Import Records – File… FileMakerallows you to import from files of other databasesFileMaker, filesExcel, delimited files (type *.csvor *.tab).

— change the table name . Select the table in the fieldTable Nameenter a new name, click on the buttonChange

— delete table . Having selected the table, click on the buttonDelete

- copy table . Select the table and press the buttonCopy. This will copy the table structure to the PC clipboard. If you then press the buttonPaste, then a table with the name will be insertedTable2 (if the original wasTable).

- import table . To do this you need to click on the buttonImport. In the window that opens, select the external database file and the table in this file.

B) Tab Fields (Fields). This tab displays the structure of the fields of the selected table of the current database. I won’t dwell on the capabilities of this tab. These are similar to the tab optionsTables. These are the create, modify, copy, paste and delete functions. Only the function has been addedDuplicate (Duplicate). This function combines the copy and paste functions into one.

B) Tab Relationships . This tab displays the structure of the entire database in graphical format. At the bottom of this tab there is a menu for managing the database structure. Let's look at the main functions available from this interface. They are divided into three categories:

First category – Tables / Relationships :

— Add table – adding a table to the database structure

— Establishing a new connection – allows you to organize a new connection between fields of different data tables

— Duplicate table – allows you to create a copy of the selected data table. It should be noted that not a physical copy of the table with data is created, but a logical one. In this case, the system requests a new table name in the structure. Those. physically there can be one table (Table), and logically there can be several of them (Table1, Table2, etc.). This structure is very convenient when creating various reports and calculating results for any parameter. As the system developers themselves note, building a report means building certain connections between images of data tables.

— Edit table – allows you to change the logical name of the table and the data source for it.

— Delete table – performs a logical (not physical) deletion of a table from the graphical interface.

— horizontal alignment – includes center, left and right alignment functions

— vertical alignment – includes center, bottom and top alignment functions

— distribution – includes horizontal and vertical distribution functions

— change of size – bringing all selected objects to one of six parameters (the smallest in width, in height, in width and height, the largest in width, in height, in width and height).

I note that the functions of this subgroup are used for two or more selected objects and are aimed at creating a readable appearance of a graphical image of the database structure.

— table color – allows you to change the color of the selected table(s) to visually highlight groups of tables in the graphical interface.

— graphics mode button / text mode button – two buttons designed to work with graphic and text elements.FileMakerprovides the ability to include table descriptions in the graphical interface. To create an inscription, there is a button to switch to text mode.

— Increase/Decrease/Normal buttons – three buttons for controlling the interface display scale.

— scale display window (in percent)

— button to display pagination

— print settings button

We will leave the buttons of the fourth category without comment.

Thus, using the three tabs described above, the structure of database tables is created and configured, fields are created and described.

3. Setting up access to the database

Database Management SystemFileMakerprovides a fairly wide range of customization options for limiting access to data.

To configure data access restrictions, use the menuFile – Manage – Security . This opens a window with four tabs. Let us briefly describe their purpose.

TabAccounts – designed to add and edit the list of database users. This panel contains buttonsNew, Edit, Duplicate, Delete. They are respectively intended for creating a new user, editing the access parameters of a selected user, duplicating a user (with all access parameters), and deleting a user.

TabPrivilege Sets – designed to add and edit types of privileges. By default, three types of privileges are configured in the database:

— Full Access – full access

— Data Entry Only – reading, writing, deleting all records without the ability to develop a data structure

— Read — Only Access – read-only access to data.

Creating a new type of privilege.

The database administrator can also add his own privilege type. To do this you need to click on the buttonNew. A window will openEdit Plivilege Set .

In fieldPrivilege Set Name specify the name of the privilege type to be created. In a group of fields with a common nameData Access and Design access to database records is configured (fieldRecords), types (fieldLayouts), lists of values (fieldValue Lists), scripts (fieldScripts). In each of these fields, you can fine-tune user access. For example, setting up access to individual fields of a database table, individual views, etc. This allows you to limit user access to data without disrupting system operation.

Note: it is necessary to understand that in the structure of the DBMS FileMaker data is accessed through layouts ( Layouts ). Thus, data from any table can be read (edited) only through the corresponding layout.

Next on the access rights editing form there is a group of checkboxes under the nameExtended Privileges (Extended Privileges). They are designed to organize access for this group of users to work throughWEB-interface, viaODBC-connection, via a network connection, etc.

And finally, on the right side of the form there is a group of checkboxes calledOther Privileges (Other privileges). With their help, a developer can configure access for a group of users to print (Allow printing ), data export (Allow exporting ), setting up extended access rights (Manage Extended Privileges ), the mode of checking the entered data, the mode of disconnecting users from the database, the mode of changing the password.

From our reviews of prototyping software, you may have already seen that building your own apps is not that difficult. Moreover, in order to achieve such a goal, it is not at all necessary to dig into programming languages. The large-scale platform never tires of reminding us of this FileMaker, which has been improving for 14 generations in a row. On its foundation, users implement their ideas for iOS, OS X and Windows, without particularly plunging into the hardware. The most important thing is that the end result is amazing!

FileMaker is patronized by Apple itself, so the quality of the project speaks for itself. The 15th part is coming, but for now we will study the 14th in detail, examining the differences between FileMaker Pro and FileMaker Advanced, the features of Go, WebDirect and Server.

Perhaps the biggest difference between FileMaker Pro and Advanced is in Script Workspace. Script Workspace allows you to automate tasks in the shortest possible time. It supports line-by-line editing and a kind of predictive input when you type characters, and suitable options pop up at the same time. You can even use acronyms like GTRR (Go to Related Record) to increase speed. It also has built-in search, supports empty lines, numbering, indentation, syntax highlighting and other programmer tools.

Calculation Dialog box is responsible for the layout of functions and calculation of algorithms in the finished application. By the way, functions are now automatically completed, and searches are faster.

FileMaker 14 has a huge design toolkit with which any interface can be adjusted without any problems. Now a Button Bar has been added to it, providing the creation of groups of buttons that behave as a separate object. Groups are flexibly configured, change orientation, and follow navigation focuses.

Along with the Button Bar, 140 professionally designed icons were added. The declared number of graphic elements is not enough - feel free to upload your own.

Very usefully, divisions by area appeared, separately affecting the top and bottom of the navigation functions. This separation makes it much easier to navigate the application using at least the same Button Bar.

It is now possible to insert a “placeholder” tag so that tooltips or instructions for a specific field pop up on the screen.

For those who previously had a hard time handling flowers, now it will be easier, because the color solutions have been improved. Color codes now automatically display the corresponding coordinates. I'm glad that these features work both with two standard FileMaker themes and with your own.

Design work on bugs affected a more subtle display of objects on the screen. For example, you can choose whether to show an “x” or a “selected” mark when checkboxes are activated.

The latest global update was received by the entire platform - Launch Center, which collects all the developments in one place. In addition, each of them can be assigned a suitable icon. Supports 30 standard shortcuts and adding your own.

FileMaker Go is a specialized client for iOS that has not been added to the project since version 11. In some places it received the same updates as above, that is, Launch Center, file icons. In addition to them, “tap targers” have increased in size, due to which working with solutions based on FileMaker Go has become easier. The application itself has finally been optimized for large iPhone screens and 64-bit architecture.

Separately, it is worth paying attention to the fact that FileMaker Go 14 can only connect to databases hosted on FileMaker Server 13 and 14, that is, the 12th and older part flies by. A global upgrade should be carried out.

We still have WebDirect and Server. The first is a web-based client that processes database queries. It manages to support a huge number of connections (up to 100) and scripts. A redesigned control panel has appeared with a more modern look, and FMP URLs have returned.

The second is the server. A server is a server. Here you can see full-scale prevention in the field of performance and bug fixes. It’s hard to look for obvious visual changes :)

If our review of the updates did not inspire confidence in FileMaker 14, we advise you to run through the selection of templates, take the ones you like as a basis and try to bring some idea to life. You can download the trial version using the button below.

Filemaker examples. What is FileMaker Pro

2014: FileMaker 13

Transcript

Popular articles

Latest articles

Sections

Pages

Special projects

Contacts