Creating Record Formats

Creating record formats in a drawing file is an important step to creating meaningful database rows in worksheets (see Entering Data in Database Rows).

To create a new record format:

1. In the Resource Browser, select New Resource > Record Format from the Resources menu.

The Create Record Format dialog box opens.

2. Enter the Name of the Record Format.

3. Click New.

The Edit Field dialog box opens.

Click to show/hide the parameters.

Parameter	Description
Name	Enter a name for the field, up to 63 characters
Type	Select the type of field
Integer	Select to use whole numbers ranging from -32,768 to 32,767. Using Integer requires less memory than Number.
Boolean	Select to use a data value of either True or False
Text	Select to enter a string of characters (default option), such as a word or a sentence
Number	Select to use numbers outside the range of Integer, fractions or decimals, or to specify a number format. Click Format to define the number format in the Number Format dialog box; click OK to return to the Edit Field dialog box.
General	The default format
Decimal	Uses decimal numbers; enter a value for the number of decimal places, and if desired, select to use commas as separators
Scientific	Uses scientific numbers; enter a value for the number of decimal places
Fractional	Uses fractional numbers; enter the rounding value for fractions
Percentage	Uses percentages; enter a value for the number of decimal places
Dimension	Uses dimension numbers
Dimension Area	Uses dimension area format and displays the specified area units after the number
Dimension Volume	Uses dimension volume format and displays the specified volume units after the number
Angle	Determines the accuracy of angles and measurement system applied; measurement system is degrees, minutes, and seconds or decimal numbers up to eight decimal places
Date	Uses dates; select the desired date format from the list
Default	Enter the data value in the Default text box, if desired

4. Set the parameters and click OK to return to the Create Record Format dialog box.

5. For each additional field to add, repeat steps 4 through 6.

6. Click OK to return to the drawing area.

When an object is selected, the Data tab of the Object Info palette displays all records contained in the current drawing.

~~~~~~~~~~~~~~~~~~~~~~~~~

Attaching Record Formats to Symbols and Objects

Editing Record Formats

Splitting and Merging Record Formats

Linking Text to Record Formats

Modifying Objects by Record Value

Formatting Worksheet Cells

Database Connectivity

vectorworks.net