Info

Janet Morgan

Hoe's Down Festival

Mon 2/16/1...

□ Name iubject deceived

Figure 8.11 - The Volunteer Registration folder. To create a combination column

1. On the Advanced toolbar, click the Field Chooser icon.

3. In the Name text box, type the column name.

4. In the Type drop-down list box, click Combination.

5. Click Edit.

6. Click Field to add the fields you want to combine, and then click OK twice.

7. From the Field Chooser, drag the field you want as the new column heading to the Column Heading row. Use the red double-arrow marker to position the new column heading in the Column Heading row.

Message forms save user-defined fields in the Inbox. Other forms save user-defined fields in the current folder.

In some cases, you might want to change the label of the combination column so that it's different from the field name. In addition, you might choose to change the formula specified for the combination column. To do this, you use the Format Columns dialog box, as shown in Figure 8-12.

Figure8.12 - The format properties for the Name column in the Volunteer Registration folder. To change a combination column label or formula

1. Select the folder, right-click the column heading, and then click Format Columns on the shortcut menu.

2. In the Available Fields list box, select the combination field whose properties you want to set, and do one or both of the following:

• To change the formula, click the button next to the Formula text box.

To change the column label, change the text in the Label text box.

Create a combination column that shows only the value of the first non-empty field In some cases, you might want to create a column that shows only the value of the first non-empty field in the item. For example, say you want to create a combination column if you have multiple item types in the folder and the items have fields with similar values but different field names. Assume you have documents and standard post items in a folder and you want to create an Author column. Rather than creating a From column for post items and an Author column for document items, you can create an Author/From field, and then click the Showing Only The First Non-Empty Field, Ignoring Subsequent Ones option.

To create a combination column showing only the value of the first non-empty field

1. On the Advanced toolbar, click the Field Chooser icon.

3. In the Name text box, type a name.

4. In the Type drop-down list box, click Combination.

5. Click Edit.

6. Click Showing Only The First Non-Empty Field, Ignoring Subsequent Ones.

7. Click Field to add the fields you want to combine, and then click OK twice.

8. From the Field Chooser, drag the field you want as the new column heading to the Column Heading row. Use the double-arrow marker to position the new column heading in the Column Heading row.

Create Formula Columns

For some views, you might want to show different field values in the folder. For example, in the sample Training Management folder, as shown in Figure 8-13, the Course ID/Time and Course Name/Instructor columns are formula columns. In the Course ID/Time column, the value of the Course ID field is shown in the column if the item is a Catalog Entry item. If the item is a Course Offering item, the value of the StartTime field is shown in the column.

To create a formula column

1. On the Advanced toolbar, click the Field Chooser icon.

3. In the Name text box, type a name.

4. In the Type drop-down list box, click Formula.

5. Click Edit.

6. In the Formula box, specify the formula you want for the column, and then click OK twice.

7. From the Field Chooser, drag the field you want as the new column heading to the Column Heading row. Use the red double-arrow marker to position the new column heading in the Column Heading row.

You can change the label of the formula column so that it reflects the field values shown in the column. In addition, you might want to change the formula specified for the column.

Figure8.13 - The formula for the Course ID/Time column shows a different field value for each message class.

To change a formula column label or formula

1. Right-click the column heading, and then click Format Columns on the shortcut menu.

2. In the Available Fields list box, select the field whose properties you want to set, and do one or both of the following:

• To change the formula, click the button next to the Formula text box.

• To change the column label, change the text in the Label text box.

Group Items

Groups provide a convenient way to organize items that have the same field values in a folder. For example, in the By Ad Type view in the Classified Ads folder, items are grouped by ad type and then by category. As shown in Figure 8-14, items that have a For Safe value in the AdType field are grouped together. In addition, items that have an Electronics-Computer Hardware & Software value in the Category field are grouped together.

Alto Saw with stand and music - Classified Ad

File Edit View Insert Format Tools Actions Help

Classified Aj j Policy / Information |

iype a question for help

Was this article helpful?

0 0

Post a comment