Add fields

In this exercise, you will add four fields to the Defect record type. Before you can make changes to the schema, you must check out the schema. If the schema is not open, perform the following steps:

1. In the Designer, click File > Open Schema.
2. In the Open Schema window, select Checkout a schema to edit or continue editing previously saved work. Select my_sample_schema from the table of schemas. If the schema is checked out, and you are continuing work from a previous editing session, click Finish. If the schema is not checked out, click Next and then Finish.

To add a user identification field and an action reason field to the Defect record type:

1. Expand the Record Types folder and then expand the Defect folder. Double-click Fields to open the Fields grid. The grid lists all fields in the record and identifies field type, default value, and other information.
2. Click Edit > Add Field.
3. In the DefectFields window, enter User_ID in the Field Name field. By default, the DB Column Name value is the same as the Field Name value. In the Type list, select INT, for integer, because users will enter numbers in the User_ID field. Leave the Visible in Query check box selected.
4. Click the Help Text tab. You can supply text that tells users what to enter in the field. Users can access the help text by right-clicking a field and clicking Help. Enter Enter your user ID, which is a number between 1 and 100.
5. Close the DefectFields window. The User_ID field appears at the bottom of the grid.
6. Click Edit > Add Field.
7. Enter Action_reason in the Field Name field. In the Type list, select SHORT_STRING.
8. Click the Help Text tab. Enter Enter a brief reason for why you are reassigning this defect.
9. Close the DefectFields window. The Action_reason field appears at the bottom of the grid.

In the Add tabs to a form exercise you added a Documentation tab to the Defect record form so that users can determine whether a defect requires a change to the documentation. Now you want to add two fields for that tab, Doc_Impact and Doc_Description. To add these two fields:

1. Click Edit > Add Field.
2. In the DefectFields window, enter Doc_Impact in the Field Name field. Select SHORT_STRING in the Type list.
3. Click the Help Text tab. Enter Select one of the choices from the list to indicate what documentation needs to be updated. In a later exercise, you will create a choice list hook that presents users with a list of values for this field.
4. Close the DefectFields window. The Doc_Impact field appears at the bottom of the grid.
5. Click Edit > Add Field.
6. In the DefectFields window, enter Doc_Description in the Field Name field. Select MULTILINE_STRING in the Type list.
7. Click the Help Text tab. Enter Enter a description of the documentation changes that need to be made to resolve this defect.
8. Close the DefectFields window. The Doc_Description field appears at the bottom of the grid.
9. Click File > Save Work to close the schema and save your changes without checking in the schema.