Skip to Navigation

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How do I erase the contents of a field?

There are two techniques. The first technique is to convert the field from what ever type (i.e. numeric, text, date) it is to a formula field of the same type (i.e. formula-numeric, formula-text, formula-date). Then convert it back to the type it was. This erases the contents of the field. Please see this help topic to learn how to change the type of a field.

The other method involves creating a custom report with all records and two columns. The two columns should be the table's key field and the field that you want to erase. When you've displayed this report click on "Other" and then select "I want to export this view to a spreadsheet". Within the spreadsheet erase the contents of the column you want to erase without erasing the column label at the top of the column. Then select both columns, including the field names at the top of the columns and copy them to the clipboard.

Please see this help topic to learn how to copy and paste from another program.

The columns should automatically map back to the columns that they came from. After you complete the import the column's contents will be erased.


Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.