4 74 PROGRAM DOCUMENTATION RoloMan Version 1.0 - Introduction: 'RoloMan' was written by, the sole property of and copyright (C) 1996 Scott R. Carstens, all rights reserved. Portions of this program are copyright (C) 1992 Oxxi Inc. This program is an autodialing rolodex integrated with various database functions containing label and envelope printing capabilities. 'RoloMan' may be freely distributed, however, please send $20.00 for program registration and usage to: Scott Carstens 3842 S. 74th St. Milwaukee, WI 53220 Include your name, address, phone # and/or email address with payment. Another program available is 'Studio Manager' which is a comprehensive invoicing, customer tracking business management program which will run a Photography Studio, and could be used to run various small business applications. Scott Carstens can be reached at the afformentioned address or by telephone at (414)-328-9086 or by electronic mail at carstens@execpc.com. Editing Records: The 'Edit Record' button will place the cursor in the first field for editing a record. The cursor may be moved around the form with mouse clicks or by pressing enter or by using the arrow keys. After entering in last field the program will prompt you to see if you wish to save the record. When saving in this manner you will again be prompted to see if you wish to continue data entry. New Record: The 'New Record' button should be clicked on to open up a blank record for data entry into a new record. Delete Record: Simply click on 'Delete Record' button and program will prompt you to make sure you wish to delete that record. Save Record: There are two ways of saving a record. One is to click on the 'Save Record' button and the other is to enter through the last field. When entering through the last field, after record is saved, you will be prompted whether you wish to continue data entry. If you click on yes or press enter a new empty record will appear with a cursor in the first field for rapid continous data entry. Print Labels: On the programs main form, you will first be presented with a requester which asks you to type in a value of 1, 2 or 3 to let the program know how many columns of labels you would like output to the printer. Then you will be prompted to type in 'A' to print all records as labels or 'M' to print only marked labels. Labels are printed in a 1x10, 2x10 or 3x10 page layout. Phone Dialing: 'RoloMan' will autodial any one of four phone numbers by clicking the appropriate button. Envelopes: When you click on 'Envelopes' button an envelope form will appear.  The 'Edit Form' button will allow you to edit the return address, simply enter cursor through to save return address on form. The labels button on this form will print 90 return address labels, 30 per page (3x10). The 'Print Envelope' button will print the current record on an envelope with the return address you edited, for self-addressed envelopes simply create a record of yourself on the rolodex form. The 'Set Printer' button allows you to choose a printer or change the printer driver's parameters or choose a 'Prefs' printer driver. To go back to the main rolodex form simply click on the 'Back Home' button. VCR Panel (browsing, search, filter): The VCR Browsing Control design is a registered trademark of  'Precision Software Limited'. The VCR type panel at the bottom of the forms will aid you in searching through the database. The 'Pause' button will stop when fast forwarding or rewinding through database. The 'Stop' button will stop as opposed to pause. There is a button to go to either end of the database, fast forward or rewind or go back and forth one record at a time. You may also use key equivalents to do the same. spacebar = pause crtl + c = stop left arrow = previous record right arrow = next record shift + down = fast forward shift + up = rewind shift + left = first record shift + right = last record ? = key lookup = = filter Key Lookup button (?): To retrieve specific individual records, use the 'Key Lookup' (?)  button. For example, click on the 'Key Lookup' (?) button, type in the letter S into the request then click on yes or press enter. This will bring you to the first name that starts with the letter S. If you spell the last name completely in the requestor it will bring you to that record. Filter button (=): This is a very powerful feature. The filter allows you to enter a set of values and restricts the display to only those records that match the values. After clicking on the 'Filter' button (=) the program will bring up a filter requestor. A filter is created by combination of clicking on field names and operators and typing in values. This will produce the filter command line in the text box. Clicking on the 'Filter' button again will terminate the filter. Fields Box: You can scroll the field names up and down using the scroll bar and arrows and the right of the fields box. The field is specified by clicking on its name, it then appears in the text box. Operators: These are to the right of the field box and are divided into relational, logical, and mathematical operators. Clicking on these will place them in the text box. Value Box: This box is for typing in values ie. names, numbers and dates which will become part of the filter. When matching numeric data that has to be held in a text field such as a phone number you must put the value in quotes. You must press enter after typing in the value box for the filter requestor to work. Text Box: This is a long box across the bottom of the requestor. When you make selections with the mouse or type values into the box, a filter command line is constructed. You immediately find the result of your command line by clicking ok or pressing enter. Up to 255 characters are allowed. It is not necessary to click fields and operators into the text box, you may type them in directly by hand if you prefer. Operators: The operators are used to relate field names to other fields and or values. For example, to display only those records with a zip code of 53220 you would click on the field 'zip' (in the filter requestor) which would place that field in the text box, then click on the operator 'LIKE', then type 53220 in the value box and press enter.  Either click on 'OK' in the filter requestor or press enter.  'RoloMan' will display only those records with a zip code of 53220.  To end the filter, simply click on the 'Filter' button and all records in the database will again be displayed. Text String and Pattern Matching: When searching for names or text string, use LIKE instead of equals sign (=). The equals sign requires exact matches and it is case sensitive whereas LIKE is case insensitive. LIKE Syntax: LIKE "*" Searches for empty field with '*' on its own LIKE "?" Searches for fields that are not empty LIKE "set" Field with content 'set' The asterisk represents a text string of any length: LIKE "set" 'set' string at start of field LIKE "*set" 'set' string at end of field LIKE "*set*" 'set' string anywhere in field The question mark represents a single character: LIKE "???" Fixed length, any content LIKE "?set?" Fixed length, fixed content LIKE "?set*" Fixed leading length/content, any length A range inside square brackets may be used in place of a question mark character: LIKE "[b-h]" Single character range 'b' through 'h' LIKE "[bcf-x]*" Character 'b ', 'c', or 'f' through 'x' The caret or up arrow at the start of a bracketed sequence signifies exclusion: LIKE "[^d-p]" Excludes characters 'd' through 'p' You can combine different elements of the pattern matching syntax: LIKE "c??[i-n]?z*" This matches 'c' in the first position, any character in the second and third positions, the range from 'i' to 'n' in the fourth position, any character in the fifth position, 'z' in the sixth position, and any number of characters following the 'z'. LIKE is the operator you should use when searching for text strings in fields. Examples: lastname LIKE "m*" - 'RoloMan' displays only records with last name  beginning with 'm' homephone LIKE "671*" - Displays all records with home phone beginning with '671' firstname LIKE "??p*" - Displays all records where the fourth  character of the first name is the letter 'p' Ideas: You may identify like records by entering text in the 'Notes' field that would allow you to bring up only those like records with the 'Filter' button whenever you desired, for example, describing a client as 'client' in the 'Notes' field, then applying a filter to display only clients. When creating a record that is a company name, enter it in the 'Last Name' field so that it's properly indexed then enter the contact person's full name in the 'Notes' or 'First Name' field. Relational Operators: = Equal to <> Not equal to > Greater than < Less than >= Greater than or equal to <= Less than or equal to Logical Operators: AND zip LIKE "53220" AND lastname LIKE "c*" OR zip LIKE "53220" OR lastname LIKE "c*" NOT zip LIKE NOT (zip LIKE "53220") Last example would display all records whose zip code was not 53220. Parentheses (): Expressions in parentheses are given a higher priority in the order of computation for a filter. Mathematical Operators: + addition - subtraction * multiplication / division 'Clear' Button: The 'Clear' button in the requestor simply clears everything out of the text box in the filter requestor so that you may insert a new command line filter. Deactivating Filter: Simply click on the 'Filter' (=) button to deactivate the program's filter and all records will again be displayed. 'Set Printer' Button: This button gives you some flexibility for label printing. The LASERJET_III option can be used for HP DeskJet 550 printers with 10, 20 or 30 - 2 5/8 labels per page (centered). For 11 ,22 or 33 labels per page style paper, use the Generic option. For using Prefs printer and options use 'PREFS' option. Other settings may be altered if necessary in the 'Page Setup' window or by altering your Amiga PREFS options.