| Category |
Modifier |
Details |
|---|
| Calculation |
<CIZ> |
'Calculate If Zero' - numeric calculation is only performed if field value is empty or zero. |
| Calculation |
<MOD> |
Modified date/time
This field will update to the current time whenever it is recalculated.
If 'Auto-recalc' is ticked on the main menu, then this field will be updated whenever any field is edited. |
| Display |
<CUR> |
'CURrency'
- display doublefloat field as a currency. The format is set in the
general options dialog and uses the following global variables :-
ShowCurrencies% (-1 or 0, default = 0)
CurrencyPre$ (10 character max string)
CurrencyPost$ (10 character max string)
CurrencyBrackets% (1 or 2, 2 = use brackets for negative values) |
| Display |
<DMS1> |
Display lat/long fields as decimal degrees.
eg.
35.96160º |
| Display |
<DMS2> |
Display lat/long fields as Degrees, Decimal Minutes (2dp)
eg.
35º57.70'N |
| Display |
<DMS3> |
Display lat/long fields as Degrees, Decimal Minutes (3dp)
eg.
35º57.696'N |
| Display |
<DMS4> |
Display lat/long fields as Degrees, Minutes, Seconds
eg.
35º57'41"N |
| Display |
<DMS5> |
Display lat/long fields as Degrees, Minutes, Decimal Seconds
eg.
35º57'41.8"N |
| Display |
<DT1> |
Displays a DoubleFloat number as the equivalent datetime.
DateTime field values can be used in calculations resulting in a
numerical result. The <DT1> field modifier causes this number to
be displayed as a datetime string. |
| Display |
<DT2> |
Displays a DoubleFloat number as the equivalent date.
DateTime field values can be used in calculations resulting in a
numerical result. The <DT2> field modifier causes this number to
be displayed as a date string. |
| Display |
<DT3> |
Displays a DoubleFloat number as the equivalent time.
DateTime field values can be used in calculations resulting in a
numerical result. The <DT3> field modifier causes the time
component of this number to be displayed as a time string. |
| Display |
<GRY> |
'GReY' - Display the field with a grey background (will not do anything on pre-ER5 machines).
NB: This modifier will not behave as indicated until the table is reopened. |
| Display |
<INF> |
'INFormation' - display the field contents as well as the record number when 'Show Record Info' is ticked on the main menu. |
| Display |
<LC> |
Display the field in lower case. |
| Display |
<LIN> |
'LINe' - The field is a section divider.
A horizontal line will be placed over the fieldname to indicate a
section start. This can be useful if the table contains a large number
of fields.
This modifier is also used as a jump location when the user presses '.'
while browsing. The jump fieldname is shown flashing at the bottom of
the screen and the user can move to a desired jump location using the
cursor keys and the Enter key. |
| Display |
<SPV> |
'SPlit View' - use this field as the default column for the listing in split list view. |
| Display |
<UC> |
Display the field in upper case. |
| Display, Input |
<MF> |
Male/Female text (Bit Fields) |
| Display, Input |
<TF> |
True/False text (Bit Fields) |
| Display, Input |
<YN> |
Yes/No text (Bit Fields) |
| Display, Lookup |
<L2F> |
'Lookup 2 Fields' - makes a custom lookup/help popup display the first two text fields instead of only the first one. |
| Display, Lookup |
<L3F> |
'Lookup 3 Fields' - makes a custom lookup/help popup display the first three text fields. |
| Display, Lookup |
<L4F> |
'Lookup 4 Fields' - makes a custom lookup/help popup display the first four text fields. |
| Display, Lookup |
<MXW> |
'MaX Width' - forces help/lookup popup to maximum width instead of being related to the target field width.
The <MXW> modifier can be useful in conjunction with the <L2F>, <L3F>, and <L4F> modifiers |
| Exports |
<HTM> |
HTML source.
Prevents conversion of newlines and various HTML special characters in
this field when exporting to HTML. By default, special characters are
converted so that HTML output displays text exactly as written.
This is obviously undesirable for HTML source because it would prevent
links etc. from working as planned. The <HTM> modifier prevents
all these conversions and allows 'raw' output of the field contents. |
| Exports |
<NCB#> |
'No Column
Break' - prevents this field from causing an HTML column break (ie.
joins it to the next one). The value of # affects how this field is
separated from the following one :-
‡<b>‡<NCB1>‡</b>‡ insert a line break (<BR>)
‡<b>‡<NCB2>‡</b>‡ insert a space character
‡<b>‡<NCB3>‡</b>‡ no separation |
| Exports |
<NOE> |
'NO Export'
This modifier switches the field off by default for text and HTML
exports. It can still be switched on manually using the 'Options'
button in the export dialog box before performing the export. |
| Exports, Special |
<HNM> |
'Html
NaMe' - If this modifier is present, then the contents of this field
should be used as the basis of the filename for single record HTML
output.
PsiDat will append the '.htm' extension automatically - it should not be included. |
| Exports, Special |
<HTI> |
'Html TItle' - Use this field for the default page title when exporting HTML. |
| Exports, Special |
<ICN> |
'ICoN source' - used with memo fields to insert an image at top left of the memo text when exporting HTML.
Usage: <ICN>#
where # is the field number that contains the image filename.
eg. if field 3 contains the text 'mypic.gif' then a memo field using the modifier:-
<ICN>3
will put an image in the top left corner called 'mypic.gif' |
| Input |
<ST> |
'STart' Causes the cursor to start at the beginning of the text instead of the end.
The main use for this modifier is with units contained in a standard Help popup.
For example, if the helps had values; "mm", "cm", "in", "pixels" etc.,
selecting "cm" would put "cm" in the field and place the cursor in
front of it ready to enter a value. |
| Input, Lookup |
<AP1> |
Append help text instead of replace (with comma separator).
Normal behaviour of help/lookup text is to replace the contents when an
item is selected from the popup. However, sometimes there is a need to
build a string from several selections. The <AP1>, <AP2>,
<AP3>, <AP4> & <AP5> modifiers allow this with
various options on the separator string. |
| Input, Lookup |
<AP2> |
Append help text instead of replace (with comma+space separator).
See <AP1> for fuller description. |
| Input, Lookup |
<AP3> |
Append help text instead of replace (with space separator)
See <AP1> for fuller description. |
| Input, Lookup |
<AP4> |
Append help text instead of replace (with '/' separator)
See <AP1> for fuller description. |
| Input, Lookup |
<AP5> |
Append help text instead of replace (with ' / ' separator)
See <AP1> for fuller description. |
| Input, Lookup |
<NDR> |
'No DRilldown' - prevents the user from pressing the tab key in a lookup to edit the lookup table. |
| Input, Lookup |
<NOA> |
'NO Addition' - Do not add new text to help entries.
The default behaviour with help popups is to offer the user the option
to add any unrecognised input to the helps files. This modifier
switches off this ability. |
| New Record Autofills |
<+1> |
Increment number
The value shown in this field +1 will be inserted in any new record created. |
| New Record Autofills |
<CD> |
'Copy Down'
The current value of this field will be used as an autofill value when creating a new record. |
| New Record Autofills |
<DEF> |
'DEFault value'
This modifier is unusual in that it must be the last one used in the list of modifiers.
Eeverything following <DEF> is used as a default value when creating a new record.
Examples:
To indicate a bit field should default to true :-
<DEF>1
To put the words "Not specified" in a text field:-
<DEF>Not Specified
To default to the value 100 in a numerical field:-
<DEF>100
|
| New Record Autofills |
<NOW> |
Use the current datetime or GPS fix when creating a new record.
This is frequently used to datestamp new records.
It will also force a RealMaps/GPS position read on numeric fields that are set to be lat/long coordinates. |
| Printing |
<NOP> |
'NO Print' - do not print this field when using the simple print facility. |
| Special |
<SQL> |
Autofilter
When a user presses shift-F, the contents of any of the fields that use
the <SQL> modifier are used to create and activate an SQL filter
based on those values. |
| Special |
<SUB> |
Makes the
field a key to a sub-table. The name of the sub-table must follow the
<SUB> modifier. If other modifiers follow, then put a space
character after the sub-table name.
It is possible to have more than one <SUB> modifier to relate to a number of subtables, eg.
<SUB>Mytable1 <SUB>Mytable2 |
| Special, Input |
<LCK> |
'LoCK' -
prevent the field from being edited. Useful for the key fields of
sub-tables to prevent record flyaway (and possible untrappable errors). |
| Summary Operators |
<AVG> |
Summary operator - Average
The average of the values of all the records in the view will be calculated and shown in reports and tabular HTML exports. |
| Summary Operators |
<CNT> |
Summary operator - Count
The number of records in the view will be counted and shown in reports and tabular HTML exports.
The exact behaviour can be modified by the 'Count Zero Values' option in the general preferences. |
| Summary Operators |
<MAX> |
Summary operator - Maximum
The maximum value for this field will be recorded and shown in reports and tabular HTML exports. |
| Summary Operators |
<MIN> |
Summary operator - Minimum
The minimum value for this field will be recorded and shown in reports and tabular HTML exports. |
| Summary Operators |
<SUM> |
Summary operator - Sum
The sum of the values of all the records in the view will be calculated and shown in reports and tabular HTML exports. |
