Edit and delete columns

After a column has been created it can be edited or deleted. Go to the
Admin
>
Active iSheets
then select
More actions
and
Manage columns
for the iSheet you need to edit.

Search for a column

If the iSheet has many columns, use the
Search Column names and description
field to quickly locate a column with the name or description.
This page displays a list of all of the columns for that iSheet. From here you can click on the
More actions
icon for the column you wish to delete and then select
Delete
.
You are asked to confirm the deletion. Select
Delete
to complete the action.
The
Edit Column
page is identical to the
Add Column
page used initially for creating and configuring the column. Nearly all column configuration settings can be changed, except for the
Type of column
.
note
You can change a
Single line text
column to a
Multiple line text
column, as there is no possibility of data loss or transformation. However, you cannot change a
Multiple line text
column to a
Single line text
column due to the character limit restriction and the possibility of data truncation.
If there is a need to change the type of column after items have been added to an iSheet, first create an entirely new column with the correct column type. Then move the data from the old column into the new column. Depending on the type of data and number of rows, this can be done by manually re-entering the data, or by using the import process to copy the data into the
Import template
and for import into the iSheet in bulk. Only, then after the data has been copied and brought back into the iSheet should the old column be deleted.
More information on importing data can be found here.
note
A lookup column source iSheet, once selected and saved, cannot be subsequently changed.

Related Content