TruSoft Consulting

CONTSUPP - Alerts

RecType in Table: A
GoldMine Location: Edit Menu | Record Properties, Alerts Tab

Each assigned alert generates a detail record in the ContSupp table. The Alert information is stored in the Notes field.

Definitions/Descriptions:
GoldMine Field: Field name when viewed in GoldMine. If blank, not visible in GoldMine.
User/System: Defines whether the User or the System sets and maintains this value.
Used For: The type of data stored in this field. If a value in single quotes (' '), this is the actual value stored in this field.

Fields In Use in GoldMine
Field Name	GoldMine Field	Type	Field Used For
ACCOUNTNO		System	AccountNo of Linked Company
RECTYPE		System	A
CONTACT
TITLE
CONTSUPREF
DEAR
PHONE
EXT
FAX
LINKACCT
NOTES		User/System	See Below
ADDRESS1
ADDRESS2
ADDRESS3
CITY
STATE
ZIP
COUNTRY
MERGECODES
STATUS
LINKEDDOC
LASTUSER
LASTEDATE
LASTTIME
RECID		System	Record ID

Alert Code, the Username who assigned the alert and whether to log alerts in history. This field shows all alerts assigned to this record.

The format is as follows:

~ALERTCODE~USERNAME{Tab Character}{Log in History Code}{Line Feed Character} followed by the next alert, if any.

The third parameter is a blank space or ‘0’ if “Log Alert in History” is not selected. If “Log Alert” is selected, this parameter is ‘1’. So a typical Alert record might look like this:

~SH~JOE 0 ~TA~DAVE 1

Note, this identifies two alerts, one for SH and the other for TA. The second alert has been marked to log alerts made in history.