Product
Support
Everything Else
Helix Relation Icons
Introduction

The table below summarizes the icons in a Helix Relation, their contents and some supplementary comments.

Icon Type Icon Contents Comments
Field

Text

Plain (ASCII) text. The format (font, size, color) of the data is controlled by the format of the template rectangle it is used on.

Styled Text

Allows mixed font, size, colors in the data. Style data is stored with the record. (Styled Text data is exported as plain text.)

Number

Floating point numbers. Stores data with 15 decimal places of precision.

Fixed Point

Integer-type numbers, limited to two decimal places, and a range of ±22.5 trillion.

Date

Date (and Time) data from 1/1/0001 00:00:00 AM through 12/31/9999 12:59:59 PM

Flag

True/False (Boolean) data in multiple forms (including custom forms).

Picture

Data in PICT file format. Can be copy/pasted, but not import/exported.

Document

Stores any file on a Macintosh volume. Storage can be an external reference (like an alias) or internal, where the entire file is copied into the collection. The contents of graphic documents can be displayed via the ‘Picture’ tile.

Fields can be Validated or Inert. When viewed in a relation in list mode, these characteristics are indicated by [V] & [I] designations.

Abacus

Various Data Types

Abaci output data types (same as fields) based on the output type of the tiles used within.

Abaci can reference data in other relations, or multiple records (summaries) within a relation. When viewed in a relation in list mode, these characteristics are indicated by [S] & [L] designations.

Template

Entry

For entering records or viewing them one by one. Has no repeat rectangle

List

For displaying multiple records. Lists are defined with the repeat rectangle.

Subform

A list template, embedded in an entry (or list) template. For displaying multiple records that match a criteria on the outer (host) template.

Views

Quick Entry

Simple entry form. Has no template.

macOS: Created by opening a view that has no view template defined.
Classic: Created by choosing the ‘Quick Entry’, ‘Find First’, or ‘Find Last’ menu item with the View open and no template selected.

Quick List

Simple list form. Has no template.

macOS: Created by opening a view and holding the Option key down while using the Inspector to specify the View Template as “== None ==”.
Classic: Created by choosing the ‘Find All’ menu item with the View open and no template selected.

Template Based

Uses a template (entry or list) to specify the design of the form.

with Query

The records shown on a view can be restricted (queried) by selecting an abacus, form query, or power query. Only records that match the query criteria can be shown on the view.

with Index

The records shown on a view can be displayed in a specific order, by selecting an index. Entry views can only have one index. List views can have multiple indexes, chosen via the ‘Sort Order’ menu command.

Views can be designed with various window types. Supported types are Document [D], Plain [P] & Invisible [I] windows.

Index

Fields and Abaci

Indexes can be Ascending or Descending. Indexes can contain multiple fields and abaci that are used to sub-index the records. When viewed in a relation in list mode, the primary icon's direction is designated by an [A] or [D].

Query
(aka Form Query)

Template

Any standard entry style template (no lists or templates with subforms) can be used as the basis of an Form Query form. Multiple icons are supported in a strict and fashion.

Power Query

Custom lists of fields and abaci

Any combination of existing fields and abaci can be chosed as Searchable Items & Reference Items. Flag (Boolean) abaci and also be designated as Permanent Items. Unlike Form Queries, Power Queries support or restrictions in addition to and restrictions.

Post

Multiple Icons

Posts are used to move data from one record to one or more records, either in the same relation or across relations. Posts are attached to Views and can be set to trigger on Entry, Print, Export, or at an arbitrary time via the ‘Post…’ commands.