Field Database Free (FDB-free)

FDB is a general purpose relational database application for mobile devices. The design goal of the application is to make a database convenient for collecting data in the field. The main distinguishing feature is ability to attach sound recording or photo to any data field regardless of its type. This allows to reduce data collection activity to a few short actions.

The actual data entry can be performed later, when the user can spend more time entering data into data fields in a searchable form based on media captured in the field. The data can be entered into individual records, or simultaneously into some of the fields of all selected records.

The application displays database records in customizable table and form views that share persistent settings for filtering and sorting. The display settings can be selected quickly by the name allowing easy changing of data view perspective. Aggregated computations such as total or average values of fields in selected records can be shown in report views.

The database structure can be altered at any time by adding or removing fields and relations. In addition to static field types the application provides derived fields computed from data values in static fields. Derived fields can be used for filtering, sorting and reporting just like static fields.

With the full version of application the tables, forms and reports can be printed via Google Cloud Print service, which allows also to save printouts as PDF files.

The full version of the application allows importing and exporting data in various file formats. Native FDB file format can contain data from multiple databases and includes complete definition of fields, relations, derived fields and data views. This format is used for creating backup copies of databases, and for transferring data between different devices. When exporting separate database the application automatically includes also related databases, with an option to include complete copy or only records that are linked by relation. On creating FDB file it is possible to restrict actions allowed on target device after import, and to encrypt exported data with password (note, that the application does not use strong encryption).

Records shown in table and form views can be exported as CSV files for integration with other desktop database or spreadsheet applications. Only data from the fields included in active view are exported. Data in media fields are included in separate files accompanying the text data in CSV file. The application includes meta information in a CSV file which enables full cycle export/synchronized re-import. This allows modifying database records using external tools such as desktop database or spreadsheet programs.

Table and form views can be exported as HTML files, that can be opened using any web browser.

The on-line documentation included with the application can be accessed from any screen through the Help menu command. The application will automatically display the section of documentation relevant to the currently active screen.

This is a free version of the application that has some limitations compared to full version:

- Import, export and print functions are not included.

- Total maximum number of records in all databases combined is limited to 1000.

The free version is a fully fledged application with functionality sufficient for many uses. The free version does not contain any advertising or nagging. The free version allows to import initial set of databases from a single native FDB file with unlimited number of records.

FDB是用于移动设备的通用关系数据库应用程序。该应用程序的设计目标是使数据库便于在现场收集数据。主要区别特征是能够将录音或照片附加到任何数据字段，而不论其类型如何。这样可以将数据收集活动减少到一些简短的操作。

当用户可以花费更多时间根据字段中捕获的媒体以可搜索的形式将数据输入数据字段时，可以稍后执行实际数据输入。可以将数据输入单个记录，或同时输入所有选定记录的某些字段。

该应用程序在可自定义的表和表单视图中显示数据库记录，这些视图共享用于过滤和排序的持久设置。可以通过名称快速选择显示设置，从而可以轻松更改数据视图的透视图。可以在报告视图中显示汇总计算，例如选定记录中字段的总计或平均值。

通过添加或删除字段和关系，可以随时更改数据库结构。除了静态字段类型外，该应用程序还提供根据静态字段中的数据值计算得出的派生字段。与静态字段一样，派生字段可用于过滤，排序和报告。

使用完整版应用程序时，可以通过Google Cloud Print服务打印表格，表格和报告，该服务还可以将打印输出另存为PDF文件。

该应用程序的完整版本允许以各种文件格式导入和导出数据。本地FDB文件格式可以包含来自多个数据库的数据，并包括字段，关系，派生字段和数据视图的完整定义。此格式用于创建数据库的备份副本，以及在不同设备之间传输数据。导出单独的数据库时，应用程序会自动包括相关数据库，并可以选择包含完整副本或仅包含按关系链接的记录。创建FDB文件时，可以限制导入后在目标设备上允许的操作，并可以使用密码对导出的数据进行加密（请注意，该应用程序未使用强加密）。

可以将表格和表单视图中显示的记录导出为CSV文件，以便与其他桌面数据库或电子表格应用程序集成。仅导出活动视图中包含的字段中的数据。媒体字段中的数据包含在单独的文件中，该文件随附CSV文件中的文本数据。该应用程序将元信息包含在CSV文件中，从而可以进行全周期导出/同步重新导入。这允许使用外部工具（例如桌面数据库或电子表格程序）修改数据库记录。

表格和表单视图可以导出为HTML文件，可以使用任何Web浏览器打开。

可以通过“帮助”菜单命令从任何屏幕访问该应用程序随附的在线文档。该应用程序将自动显示与当前活动屏幕相关的文档部分。

这是应用程序的免费版本，与完整版本相比存在一些限制：

-不包括导入，导出和打印功能。

-所有数据库的总记录总数上限为1000。

免费版本是功能全面的成熟应用程序，足以满足多种用途。免费版本不包含任何广告或na语。免费版本允许从单个本机FDB文件导入无限数量的记录的初始数据库集。