<<C3 Quick Reference>>
                                                          *dVariable = Variable to be displayed on screen
                                                             **Filename =  label of the file Example: Customer
C3 provides a variety of formula classes to make            ***"Field Name" and "Formula" can not be blank, Enter Any Text
your programming task easier.  Among them are:             ****bDisplayx = Button Display Text
(SCROLL  For More Information)                          
 
                                    Ŀ                              COMPUTED FIELD FORMULA                         BUTTON                
 FEATURE         DESCRIPTION         MORE   ĺĳ
                                          FIELD NAME    CLASS            DESCRIPTION          FORMULA      TEXT       EQUATE                                                                                           Alert 
 ĺĴ
AutoMouse     field lookup with mouse............                                                                ALT 25   PU_Pre:FieldName
ButtonRange   View range of records..............                                                                                          
ButtonEqual   View records based on value of key  DVariable* ButtonEqual  'bDISP1'|'bDISP2' ****    Key Field    DVariableDVariable       
ButtonFilter  On fly filter for browse........... Dvariable  ButtonFilter 'bDISP1'|'bDISP2'         FieldToChk   DVariableDvariable       
ButtonFilterN Equal,not equal or all............. DVariable  ButtonFilterN'Equals'|'Not Equal'|'All'FieldToChk   DvariableDvariable       
ButtonFilterV Exists, NotExists, All............. DVariable  ButtonFilterV'Exists'|'Not Exits'|'All'FieldToChk   DvariableDvariable       
C3FilterAnd   Filter on field(s)in secondary file ***        C3FilterAnd  Filename**                                                       
C3Lookup      Auto Lookup from form..............            C3Lookup                                                                      
C3NOxxx -     Disables Ins,Del,Chg or Message....            C3NOxxx      FileName                                                         
ColorRecord   Highlight records meeting criteria  LVariable  ColorRecord  Formula (amt >10)         Color #                                
CRlbd         Allows math on Invoice detail items            CRlbd                                                                         
Detail        Used only on C3Invoice Template....            Detail       Filename                                                         
Ebnn          Add list box on any type of screen             Ebnn         Filename                                                         
EBnnFilter    Allows filtering on embedded browse            EBnnFilter                                                                    
EbnnList      Computed field in Embedded Browse.. FieldName  EbnnList     FieldName                 Formula                                
EbnnNoLimit   Reads records on embedded browse...            EbnnNoLimit  Filename                                                         
EBnnRelFill   handles recursive embedded browse.. FieldToFillEBnnRelFill  VarToSet                                                         
EBnnSecondary Stuff key value on embedded browse             EBnnSecondary                                  0                              
FileOpen                                                     FileOpen     Filename                                                         
Filter        Opens file not in schematic........            Filter                                 Formula                                
FilterOnly    Filter Secondary file in a report..            FilterOnly                                                                    
GLBPAS        Prompt on global pass of filters...            Glbpas                                                                        
GLBPAS        Prompt on global pass of tags......            GlbTag                                                                        
KeyEqual      View records based on key fields...            KeyEqual                               keyfield                               
KeyRange      View records based on key range.... KeyField   KeyRange     RangeLow,RangeHigh                                               
LIST          Improves lookup performance........ FieldName  List                                   Formula                                
LULIST        Set field values prior to lookup...            LuList       Filename                                                         
LU_SET        Multi-keys & locators on browse.... Dvariable  Lu_Set       luField1=n;lufield=m,etc                                         
Many Keys     & Locators - Pulldown .............            NA                                     NA           'Any Text'MkxKeyName      
Many Keys     Add fields to primary Queue........            Many Keys                                                                     
QueueField    Stuff value into a key node........            QueueField   Your_Field String(20);etc                                        
PrimeKey      Set a parent child related value... Pre:Field  PrimeKey                                                                      
RelFill       Prime related file key for update..            RelFill                                                                       
Rel_UP        Restores pointer on browse.........            Rel_UP                                                                        
SavePosition  Add a Spinner to screen............            SavePosition FileName                                                         
SpinnerScreen Aver,Count,Mini,Maxi,Tag...........            SpinnerScreen                                                                 
Totaling      Aver,Count,Mini,Maxi,Tag                       Totaling                                                                      
  
