Once you have created a list, you’re not stuck with the list of columns you start out with. You can change the properties of the existing columns or create completely new ones. Columns are always created or modified using the Columns Tab of the List Properties dialog. (You can get to the List Properties dialog when you are creating a new list by pushing the Properties button on the Create New List dialog. To open the List Properties dialog for an existing list, select the list and either choose Properties from the Edit menu or just double-click the list name).
You can create a new column by pushing the Add button. You’ll see the Add Column dialog, where you can enter a column name and choose a column type. If you want, you can set the columns properties at that time by pushing the Properties button. Or you can just push OK to get a column with default properties.
You can edit an existing column’s properties by selecting the column and pushing the Modify button, or just by double-clicking the column name. The dialog you see will depend on the type of column.
All columns have a name property, so the Column Properties window will always include a Name field. String and Linked columns have no other properties, so for these column types there will be no other information to edit. In addition, the predefined Checkbox, Flag, Priority and Amount columns do not allow editing any properties other than Name. Property information for other column types is described below.
You won't be able to edit columns that are Autodate or calculated columns. You'll only be able to edit Linked columns in item view, as in list view clicking on them activates them.
Category Columns
Check Automatically Add New Category Values if you want all new category values entered into any item in the list to be added to the list of category values for that column. If you want to build and maintain the list of Category Values yourself, you can uncheck this option to prevent new values from being added. To edit Category Values, use the Category Values dialog by picking Category Values from the Tools menu.
Number Columns
Choose the type
of calculation for this column from the list. By default the calculation
is None, which allows you to enter data into this column.
Any other choice will cause this column to display the result of the calculation
and entering data into the column will not be allowed. The other choices
allow addition, subtraction, multiplication or division.
If you chose a calculation for this column, choose the columns that are represented by A and B in the calculation. Both A and B provide a list of eligible Number and Date columns that you may choose from. You may choose Date columns only if the calculation is subtraction, and the Date columns must have the same Form. The columns chosen for A and B must either be both Numbers or both Dates. Columns that are already the result of a calculation may not be chosen.
Date Columns
Choose a Form for the column from the list. If you choose Date Only, only a date will be displayed without a time. If you choose Date and Time, a date and time will be displayed. If you choose Time Only, only a time of day will be displayed without a date. All forms may be used with date calculations, but only Date Only and Date and Time forms may be used for alarms.
Choose a Behavior for the column from the list. The default behavior is Manual, which will allow you to enter information into the field. The Auto Date/Time behavior automatically updates the column with the current Date/Time whenever the item is changed. The behavior Calculate A + B will calculate the value of the column by adding a number column to a date column. The behavior Calculate A – B will calculate the value of the column by subtracting a number column from a date column.
If you chose a calculation for this column, choose the columns that are represented by A and B in the calculation. The choices for A are the eligible Date columns and the choices for B are the eligible Number columns. Only Date columns with the same Form as this column may be chosen for A. Columns that are already the result of a calculation may not be chosen.
When choosing a calculation for the column, the way the Number column is interpreted depends on the Form of the Date column. If the Date column is Date Only or Date and Time, the Number column that is added or subtracted is interpreted as a number of days. If the Date column is Time Only, the Number column is interpreted as a number of minutes. Fractional days and minutes may be used. For example, 0.01 days is about 15 minutes.
Yes/No Columns
Select an icon style from the Icon Style list to determine what icon will be displayed for this column.
Check Invisible When Off if you don’t want any icon to be displayed at all when the value of this column for an item is Off. The normal icon will be displayed when the value is On.
Three State Columns
Select an icon style from the Icon Style list to determine what icon will be displayed for this column.