Edit List
When you edit list structure, you can revise everything about the list. For example, you can change column details; remove, add, and rearrange columns; and rename or add another description for the list.
Edit List: Adding a Column
To add columns to a list:
- Under Columns, click Create to open the Create Column dialog.
- Click Help in the Create Column dialog for assistance.
Edit List: Revising Column Details
You can revise every detail of a list column. That is, you can rename the column, change the column data type, require a value, or remove a value requirement. Keep in mind, however, if you change a column data type, any values currently entered in the list column are either converted to the new data type or removed irrevocably.
For example, if you move from a Plain Text
data type to a Number
data type, values that can be converted to a number are retained; other values are removed. Before any values are removed by the change, you are asked for confirmation. In contrast, if you move from a Number
data type to a Plain Text
data type, all values are retained.
Note:
Validation occurs only on data entry. If a user changes column details after data has been entered into the column, the existing data is not affected (that is, validated) even if it does not meet the new column detail conditions on the columns.
If you want to validate new list data, you can export the list data to an Excel spreadsheet and then import it. On import, all rows are validated. The rows that fail validation are noted. You can fix invalid rows in the spreadsheet and import again.
To revise list column details:
- Under Columns, select the list column you want to revise and click Edit .
- Edit column details as needed, then OK to save your changes and close the dialog.
- Click Close to exit edit list mode.