Product
Support
Everything Else
Helix Tips & Techniques
Introduction

This section of the Helix Knowledgebase contains information on how to accomplish specific tasks in Helix.

Be sure to check our online Helix database techdb for more techniques. The searchable log contains questions and answers culled from calls and emails answered by Helix technical support.

We also have a YouTube Channel that contains video demonstrations of some of the features found in Helix. Sometimes a picture is worth more than a thousand words!

Looking for a comprehensive manual for the latest version of Helix? See the Helix Manual page.

Release Notes
8.0 Release Notes

What’s new in version 8.0.1 (Features and Bug Fixes)

What’s new in version 8.0 (Features and Bug Fixes)

Helix 8.0 Technotes (New Features in Detail)

7.0 Release Notes

What’s new in version 7.0.4 (Features and Bug Fixes)

What’s new in version 7.0.3 (Features and Bug Fixes)

What’s new in version 7.0.2 (Features and Bug Fixes)

What’s new in version 7.0.1 (Bug Fixes)

What’s new in version 7.0 (Features and Bug Fixes)

Helix 7.0 Technotes (New Features in Detail)

Older Release Notes

What’s new in version 6.2.4 (Features and Bug Fixes)

What’s new in version 6.2.3 (Features and Bug Fixes)

What’s new in version 6.2.2 (Features and Bug Fixes)

What’s new in version 6.2.1 (Features and Bug Fixes)

What’s new in version 6.2 (Features and Bug Fixes)

What’s new in version 6.1.x (All changes since 6.0.1)

Helix 6.0.1 Release Notes (All changes since 5.3.2)

Helix 5.3.2 Release Notes (All changes since 4.5.5)

The Helix Reference (Comprehensive Reference Manual for Helix 4.5.5)

Additional Resources

What’s new in version 5.3 (Changes since 5.2.1)

What’s new in version 5.2/5.2.1 (Changes since 5.1.1)

What’s new in version 5.1/5.1.1 (Changes since 5.0.2)

What’s new in version 5.0.2 (Changes since 5.0.1)

macOS Notes
Version Compatibility Notes

Helix and macOS 10.15 (Catalina) Compatibility

Helix and macOS 10.14 (Mojave) Compatibility

Helix and macOS 10.13 (High Sierra) Compatibility

Helix and macOS 10.12 (Sierra) Compatibility

Helix and macOS 10.11 (El Capitan) Compatibility

Helix and macOS 10.10 (Yosemite) Compatibility

Helix and macOS 10.9 (Mavericks) Compatibility

Helix and macOS 10.8 (Mountain Lion) Compatibility

Helix and macOS 10.7 (Lion) Compatibility

Compatibility notes for older versions (and older products) are found on our system requirements page.

Application

Helix System Requirements

Enabling Helix Products

Helix Demo Mode

Integrated Structure Checking

Editing Preferences in Helix

Intel Native System Version Note

View

The Save Changes dialog

Abacus

AEL: Abacus Expression Language

Sequence

R6153: Button Naming Precedence

Query

The macOS Quick Query

The macOS Form Query

The macOS Power Query

AppleScript

AppleScript Design Suite Dictionary

AppleScript Error Codes

Miscellaneous

The new ‘Apply Structure’ Dialog

The revised ‘Delete Records’ Dialog

macOS Transition Notes
Application

Property List for Helix Icons

R6939: AutoConnect & AutoOpen Preference Interaction

Keyword Indexing in Helix 6.1 and Later

TS6405: Page Setup, Page Scaling, and More

View

Changes to View Types

List Selection Spec Changes

Default & Invalid Field Shading

Understanding Font Resizing in macOS

Designing Views for macOS

BZ929: Picture Display Size in Classic vs macOS

R6112: Printing Unentered Records (With Post On Print Caveats)

Abacus

Post All and the Max Tile (Posting Summary Data)

Sequence

Sequence Behavior Changes in Various Versions of Helix

Template

Changes to the use of custom data formats

Miscellaneous

BZ814: Windows Menu Placement in macOS

Obsolete Technologies (Publish & Subscribe, AppleTalk…)

Using an ImageWriter with macOS

More notes on the FAQ page

Working with Helix
Server Management

Helix Server Access Configuration Guidelines

Helix Client Access Configuration Guidelines

Remote Access Options

TCP/IP Implementation Notes

Changing Esoteric Preferences in Helix Server 6

Monitor Helix Server to Keep It Running

Helix Server Activity Animations

Understanding Client/Server Communications

Database Basics

How to Report Crashes in macOS native Helix

Backing Up

Relational Database Definitions

Helix Networking

FAQ: TCP/IP and Helix Server 6 FAQ page

FAQ: TCP/IP and Helix Server 5.x FAQ page

TS484: Configuring a TCP/IP network for access through a firewall (Helix 5.2.1 or earlier)

TS1048: Helix Client via TCP/IP configuration notes (5.2.1 or earlier)

Memory Management

Helix Classic Only: Understanding and Setting up RAMJet™ and Customized Caches

Tips and Techniques
The Application

Entering a New Registration Key (6.2 and later)

Entering a New Registration Key (6.1 and earlier)

Helix Client Access Configuration Guidelines

The Collection

International Resources (Collection Localization)

The Relation

Global Lookup Problems

Open an Icon from within Get Info dialog

Helix Relation Icons

Selection and Display Modes

User Global Relation

When to create a new Relation

The Field

How Can I Easily Load a Bunch of Documents into Helix?

Create Evaluation Applications

5.2 Fixed Point Field Bug Reference

Number Format Note

Uses for Inert Fields

Using Lookups in Dynamic Popups--a Caveat

The Abacus

Abacus Format

Bar Codes

Data Import

Delete Duplicate Records

Delta Hours Tile

Dividing by Zero in Helix

Field Validation

Generating Page Numbers in Printouts (i.e., "Page 4 of 7 pages")

Mailing Label Abacus

Numbering Items on a Subform

Lookup & Positional Tiles and Undefined Fields

Range Validation

Rounding in Helix

Round with Percentages

Select a Field, Abacus or Relation

Undefined Values and If-Then Else Logic

Undefined Values and And/Or Logic

Understanding Time in Helix

Validate Specific Fields on Replace

Validation to Prevent Carriage Returns

Variance and Standard Deviation

The Index

Fragile Index

Query Optimization Note

Subform Index

The Template

Arrow Buttons

Custom Grids

Dynamic PopUps

How to Open a Subform Template from a Host Template

Removing a Subform Template from a Host Template

Use Background Pictures

Using Lookups in Dynamic Popups--a Caveat

The View

When is an abacus calculation unavailable to a Use/From tile?

Understanding Page Visibility & Numbering

Field Shading in Helix Applications (New: July, 2006)

Restricting the Number of Records on a Subform

"Priming" a Delete Dialog in Design Mode (Classic RADE)

Optimization of Lists Using the Shade Invalid Fields Command

Quick Lists and Quick Entry Forms

Use only one Entry Form in a Relation

The Post

Conditional Posting

Duplicating Records

Forcing the order of Posts

Limit Views for a Specific User

Option and Triplet Posting Sections

Order of Posting Events

Post On Export Notes (New: May 2007)

Store Text in Upper Case

The Query

Quick Query Options

The User

User Global Relation

Resetting User View Sizes & Positions

The Sequence

Sequence Dialog Options

Structure Only Copy of Collection

Helix Diagnostics
Overview

General Questions about the Diagnostic Utilities

Helix Maintenance Manager

All About Helix Maintenance Manager

Helix Diagnostic Utilities

Helix Update Collection

Helix Utility

Helix 6.2 Integrated Structure Check

Problems

Collection Damage: Repair Procedure

Collection Damage: Lost Resource Fork