Overview

How to delete or 'clear' the contents of a field for all or selected records.

Delete Value

In some cases you may prefer to delete or clear the data from a field before updating it.

For example, if you have Writers in the Producer field and wish to change to use the new extended Writers field for Writers and grab Producers in the Producers field, you could first delete the content of the Producers field by choosing the operation "Delete Value" for all records - so you start with those fields being empty.

Then you can:

1. Use a 'Silent update' (auto match only) to update only records that match and will not have any Writers left in the Producers field because you deleted them
2. Then update all the records where Producers is empty with manual matching enabled.

Steps

1. Select Operation = Delete Value
2. Select DB Field = Producer
3. Select "Update all records"
4. Test and Apply the changes

Related

• Update Movies Tab