|  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 

Advantage Help > Options > Custom Fields

Custom Fields: Define Application Constants for Use in Calculations

This section explains how to define named constant values-such as a tax rate-in the Custom Fields options tab. It also shows how to reference these values in calculated fields, query-edit fields, and SQL query fields using the syntax @:NY1, @:NY2. A practical example is included, demonstrating how to incorporate a TAX_RATE custom field into an invoice subtotal formula.

You can use Company Info and Custom Fields in Calculated, Query-Edit, and SQL Query of Numeric, Integer, Text fields. The format is:
@:Y1, @:Y2, etc. for Custom fields.
If you want to use any Custom fields as numeric values in expressions, use @:NY1, @:NY2, etc. (N means Numeric).

Example

Enter tax value into the Custom 1 Field (7.5). Use Info to enter explanation about the value. In the Designer define TAX_RATE = @NY1

TAX_RATE = 7.5 %, TAX = SUBTOTAL * TAX_RATE

Organizer Advantage, Simple Database Solutions for Windows PCs

Organizer Advantage, Business Database Solutions for Windows PCs

Organizer Advantage Free Service

Organizer Advantage Support

Database Blog:
Advantages of Database Software over Spreadsheet Applications
Firebird SQL Tutor
Custom Wine Inventory Database

Free Database Templates