GOLDBOX FUNCTIONS LIST: 
 
Listed below are many of the functions available to you when designing data filters and field replace expressions for Import, Update, Export, Global Replace and Data Entry for GoldBox Views: 
 
ActualLast 
  • Ignore short titles (such as CEO, LPN), get Last Name 
    • AC_Link 
  • Direct link to Additional Contact, from its Email record 
    • Add1Month 
  • Advance a Date {x} true MONTHs 
    • AddlConFld 
  • Via Calendar / History, return any Additional Contact field 
    • AddYears 
  • For Date value: Add to, or Subtract from, number of YEARS 
    • AfterFirst 
  • Everything after the first word 
    • AgeByMonth 
  • Number of months between 2 dates 
    • AgeByYear 
  • Number of years between 2 dates 
    • AllTrim 
  • Trim leading and trailing spaces 
    • AlphaPhone 
  • Convert phone number LETTERS to NUMBER counterparts 
    • ANSI 
  • Maintain integrity of International characters 
    • ASC 
  • Returns the ASCII numeric code for a character 
    • At 
  • Position # of word or character from LEFT 
    • BeforeLast 
  • Everything up to last word 
    • C2L 
  • Convert a CHARACTER value to a LOGICAL value 
    • CalCode 
  • Appropriate word or phrase, based on Calendar RECTYPE 
    • CalEndTime 
  • End Time based on Duration 
    • Canada 
  • TRUE if State field is Canadian province 
    • CDoW 
  • Character day of the week 
    • Ceiling 
  • Next highest integer for a decimal value 
    • CharSet 
  • Current character set in BDE 
    • Chr 
  • Character assigned to an ASCII numeric code 
    • CMonth 
  • Character month 
    • CountWords 
  • Number of words in a field 
    • CtoD 
  • TRUE date from a Character field or literal value 
    • CVal 
  • Same as Val(), but first removes commas, spaces, etc. from entry 
    • CVUaverage 
  • GoldBox Views: Display AVERAGE of Numeric Field Expression 
    • CVUgotoMax 
  • GoldBox Views: Display the View record with HIGHEST value 
    • CVUgotoMin 
  • GoldBox Views: Display the View record with LOWEST value 
    • CVUtotal 
  • GoldBox Views: Display TOTAL of a Numeric Field Expression 
    • Date 
  • Current system date 
    • Day 
  • Numeric day of the month 
    • Deleted 
  • TRUE if dBase record is flagged as *deleted* 
    • DiskSpace 
  • Display available free disk space 
    • DNCscan 
  • TRUE if Phone # is found in Do-Not-Call Search Blocks 
    • DoW 
  • Numeric day of the week 
    • DtoC 
  • Convert True Date to character value 
    • DtoS 
  • Convert True Date to character yyyymmdd 
    • DTSdecrypt 
  • Convert GoldMine-encrypted Date-Time-Stamp to readable value 
    • DupedWord 
  • Remove all duped words in a field 
    • DurConvert 
  • Convert minutes to hours / minutes / seconds 
    • Empty 
  • TRUE if field value is blank or empty 
    • EndOfMonth 
  • Last day of month as Date 
    • EndWords 
  • First and last words of a field 
    • EntryPattern 
  • TRUE if Character field entry matches pattern, FALSE if not 
    • FieldContains 
  • TRUE if 1 of multiple values is found in field 
    • File 
  • TRUE if specific disk file exists 
    • FileMod 
  • When file was last modified 
    • FileWild 
  • TRUE if file found based on wildcard 
    • FirstCharacter 
  • Delete 1st character if it is not a keyboard value 
    • FirstLast 
  • Petonic, Dave  becomes  Dave Petonic 
    • FirstOfMon 
  • First day of month as Date 
    • FirstOfQtr 
  • First day of month as Date, of the current Quarter 
    • FirstWord 
  • First word of a field 
    • Flagged 
  • TRUE if record is flagged (GX Browser usage ONLY) 
    • Floor 
  • Next lowest integer for a decimal value 
    • FmtPhoneToUSA 
  • Format any phone or fax field to USA (###)###-#### 
    • FV 
  • Future Value of an Investment 
    • GenBanner 
  • Convert generic Note banner to GoldMine banner 
    • Generate 
  • Create a unique sequential # with an optional prefix 
    • GetAcct 
  • Creation Date from GoldMine Account # 
    • GETaFrag 
  • Specific numbered FRAGMENT (phrase, sentence) in field 
    • GETaWord 
  • Specific numbered WORD of a field 
    • GetCity 
  • City via Postal Code 
    • GetCounty 
  • County via Postal Code 
    • GetCustom 
  • Translates field value to another value 
    • GetDST 
  • TRUE if using Daylight Savings Time 
    • GetG4recid 
  • Generate a 15-character GoldMine Record ID 
    • GetGMT 
  • Number of hours different from GMT 
    • GeTimeDiff 
  • # of hours between 2 USA time zones 
    • GeTimeZone 
  • 1 of 7 USA time zones 
    • GetSlsTerr 
  • Sales Territory via Postal Code 
    • GetState 
  • State via Postal Code 
    • GetTable 
  • User-def field value via Zip Code 
    • GetZip 
  • Zip based on City plus State 
    • GMsendEmail 
  • Send Merged Email via GoldMine from GX View Screen button 
    • GrabCity 
  • City   when a single field formatted as Reno, NV 88888 
    • GrabState 
  • State   when a single field formatted as Reno, NV 88888 
    • GrabZip 
  • Zip   when a single field formatted as Reno, NV 88888 
    • GVUelapsed 
  • In a GoldBox View, Elapsed Time in milliseconds 
    • GxAmtInWords 
  • Convert a NUMERIC to WORDS, as in Word Amt on a bank check 
    • GXColor 
  • Colors any of the GoldBox View Labels or Fields 
    • GxCreated 
  • Creation Date of any GoldMine record, based on Record ID 
    • GXCtoD 
  • Same as CtoD(), but for multi-word value (SQL Date/Time) 
    • GXF 
  • Similar to IIF - for Field Defaulting at GoldBox View 
    • GXdde.Peek 
  • DDE field / macro value from GoldMine via GoldBox View 
    • GxInitials 
  • Initials of a multi-word field 
    • GXinput 
  • Reference function for Wild Card 
    • GxMILtoHMS 
  • Number of milliseconds as HH:MM:SS character format 
    • GXpasteClip 
  • Current value on Windows Clipboard 
    • GXProper 
  • Similar to Proper(), but handles capitalization after symbols 
    • GXstripHTML 
  • Removes HTML formatting from a memo field, ideal for Export 
    • GXstuff 
  • Stuff value after up to 3 positions in field or Char Expn 
    • GXSyncAction 
  • TLog Sync Action as a Word 
    • GXSyncDate 
  • Tlog Syncstamp value as a DATE 
    • GXSyncField 
  • Tlog Sync Field Name or the Sync Code 
    • GXSyncTable 
  • Tlog Sync Table ID as a Table Name 
    • GXtextParse 
  • MEMO field replace from disk Text file with Merge Fields 
    • GXTranslate 
  • Translate one field value into another 
    • GX_Long_Expression 
  • Allows usage of very long Filter or Field Expression 
    • HistoryCode 
  • Appropriate word or phrase, based on History RECTYPE 
    • HourMaker 
  • Hours to 2 decimals from hh:mm - optional round to qtr-hr 
    • HtoI 
  • Converts HEXIDECIMAL value to INTEGER value 
    • IIF 
  • Inline  IF THEN ELSE  statement 
    • InAllGroups 
  • List of all Group membership for any Main Contact 
    • InGMLookup 
  • TRUE if field is found in the GoldMine Lookup List 
    • InGroup 
  • TRUE if Contact is a member of a specific Group 
    • InMrgPrimer 
  • TRUE if Main Contact found in the Merge-Purge Primer Table 
    • InPrimerMX 
  • TRUE if dBase record found in Merge-Purge Primer Table 
    • InResultSet 
  • TRUE if Main Contact found in a Result Set 
    • InScrubbed 
  • TRUE if Main Contact has DNC-Scrubbed Phone/Fax 
    • Int 
  • Numeric's whole number value, without decimals 
    • InThisChart 
  • TRUE if Main Contact in an Organization Chart Section 
    • IsAlpha 
  • TRUE if 1st character A to Z, a to z 
    • IsBlank 
  • TRUE if field is blank 
    • IsEmailAddr 
  • TRUE if the CONTSUPP Detail record is an Email Address 
    • IsGMuser 
  • TRUE if value is a GoldMine User Name 
    • Islower 
  • TRUE if 1st character a to z ONLY 
    • IsUPPER 
  • TRUE if 1st character A to Z ONLY 
    • ItoH 
  • Converts INTEGER value to HEXIDECIMAL value (as in DNCscan() 
    • L2C 
  • Convert a LOGICAL value to a CHARACTER value 
    • LastFirst 
  • Dave Petonic  becomes  Petonic, Dave 
    • LastTouched 
  • Last Touch for Main Contact (plus Tabs) as TRUE dBase Date 
    • LastWord 
  • Last word of a field 
    • LatestSync 
  • DATE when any GoldMine record was last modified 
    • Left 
  • Fragment from the LEFT, up to the Position # 
    • Len 
  • Length of Character or Memo (Notes) Type field 
    • LiftLines 
  • Line(s) value from Memo / Email Message, based on LABEL 
    • LinkedName 
  • Linked Document Path and File Name 
    • LkupsOTFquery 
  • SQL Query-based On-the-Fly Lookup Lists 
    • LookupDesc 
  • Sync-aware Field Translations stored in GoldMine Lookups 
    • LookupINI 
  • Search/Replace based on your Lookup.INI 
    • Lower 
  • Lower case a field 
    • Ltrim 
  • Trim leading spaces from a field 
    • Make24Hour 
  • Convert am/pm time to 24-hr time 
    • MakeShort 
  • Convert long path into short path name 
    • Max 
  • Largest of 2 numeric values 
    • Min 
  • Smallest of 2 numeric values 
    • MLine 
  • Specific line in memo (Notes) 
    • Mod 
  • Remainder of a Division math operation 
    • Month 
  • Month as numeric 
    • MsgBox 
  • GoldBox Views: Display a Windows Message Box as Trigger 
    • MultiTab 
  • Evaluate Tab records related to Main Contact 
    • NameSplit 
  • Name w/ inserted spaces    DavePetonic TO Dave Petonic 
    • NoCaseTran 
  • Same as StrTran() but is NOT case sensitive 
    • OKinput 
  • Determines CANCEL via User Input for Wild Card (in Q-file) 
    • Open_File 
  • GoldBox Views: Open a file on your system, as Trigger Command 
    • OS 
  • Current DOS Operating System 
    • PadL 
  • Pad field with spaces or characters from LEFT 
    • PadR 
  • Pad field with spaces or characters from RIGHT 
    • Payment 
  • Period amount required to repay a debt 
    • PhoneStrip 
  • Strip non-numeric characters from field 
    • PrimEmail 
  • TRUE if E-mail Address is Primary 
    • ProDate 
  • Detail Date as a True Date 
    • Proper 
  • Proper Case a field 
    • PullEmail('ADDL') 
  • Additional Contact's Email Address 
    • PullEmail('MAIN') 
  • Main Contact's Email Address (Primary as 1st choice) 
    • PullOCname 
  • Pull coded Contact Name from GoldMine's History REF Field 
    • PullView 
  • From a GoldBox View, 'pull' current value from OTHER View 
    • PullWeb 
  • Main Contact Web site 
    • PushField 
  • Field value of most current record in a GoldBox View 
    • QBEfrag 
  • CATCH-ALL search for Character, Numeric, Date and Memo (Text) 
    • QBEList 
  • Queried field (such as STATE) found in comma-separated List 
    • Rat 
  • Position # of word or character, from RIGHT 
    • RealDate 
  • DATE Formats (21 different return values) 
    • RealTime 
  • Convert 24-hr time to am/pm time 
    • RecNo 
  • dBase table's record number 
    • RecordCount 
  • Number of records in any dBase4 table 
    • ReferToMain 
  • Stand on Referral 'bridge', Open Contacts at both ends 
    • Replicate 
  • Replicate character or word {x} times 
    • Right 
  • Fragment from RIGHT up to Position # 
    • Round 
  • Round a numeric value to {x} places 
    • RoundRobin 
  • Sequential entries from list, for random, equal assignment 
    • Run 
  • GoldBox Views: Open any EXE with parameters, as Trigger 
    • SlotClear 
  • Conditionally VANISH any Label/Field, any GoldBox View 
    • SlotRead 
  • Conditionally READ-ONLY any Label/Field, any GoldBox View 
    • SmoothComp 
  • Smooth Company to generic value for Record Match 
    • SmoothName 
  • Smooth 1st Name to generic value for Record Match 
    • SnipWord 
  • Remove a specific numbered word 
    • SoundEx 
  • See 'sounds like' words as same 
    • SqRt 
  • Square root of a numeric value 
    • Space 
  • Insert {x} number of spaces 
    • Str 
  • Convert true Numeric into character value 
    • StripFrom 
  • Strip field of any passed-in characters 
    • StripKeep 
  • Preserve only keyboard-entered characters 
    • StripMrMs 
  • Strip Dr., Mr., Mrs. or Ms. from a Name field 
    • StripSuffix 
  • Strip short title from a Contact name 
    • StrTran 
  • Remove or translate characters in word, field or memo 
    • Substr 
  • Fragment of field via Position #, Length 
    • TextSwap 
  • Swap literal text {table-based} 
    • Time 
  • Current system time 
    • Transform 
  • Format field via pattern {I.e. Display Numeric with commas} 
    • Trim 
  • Trim trailing spaces from a field 
    • Type 
  • Type of passed in field or expression (C, N, D, L or M) 
    • UDTbanner 
  • GoldMine User/Date/Time Notes banner 
    • Upper 
  • UPPER CASE a field 
    • UpperStrip 
  • Strip all from field except A-Z, 0-9 
    • USA 
  • TRUE if State is 1 of 50 states or Washington, D.C. 
    • USterr 
  • TRUE if State is 1 of 8 U.S. Territories 
    • Val 
  • Convert character value to numeric for math manipulation 
    • VirtualFld 
  • Expression-defined field access 
    • VLink2dBase 
  • Links GoldMine or dBase table to any other dBase table 
    • VLinkByQuery 
  • Links dBase table to ODBC Table, w/ defined Query 
    • VUItemOut 
  • Conditionally DISABLE toolbar buttons, any GoldBox View 
    • WordOccur 
  • Occurrences of specific word or character 
    • WordSwap 
  • Swap literal words {table-based} 
    • Write2dBase 
  • Write to fields of the linked dBase table (via VLink2dBase) 
    • Year 
  • Year of Date value 
    •