Using [BLANK] Functionality

When you are changing an existing record, if you leave a field blank by default, the current value will not be changed as the Oracle API’s do not treat null values as updates.

However, in some circumstances you actually want to force the field to be changed to Blank (no value). In this situation you need to put the value [BLANK] in the cell. You can key this directly into the spreadsheet.

On upload the value will be changed to have no value.

Note - You should not use this functionality on any mandatory field values.