GET SMARTER: (650) 579-0210
Follow

How do I delete a value completely from a field (setting it to null)?

Delete a value completely from a field (setting it to null)

Here's the solution to update a field to a blank (null) value.

  • Set the value of the field that you want to make null to :empty: and then run your update.

Note:

  • Leaving the cell empty does not update a field value to blank.
  • This works only for body level fields.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    Lori Maier

    I'm trying to clear the contents of a field in Netsuite
    Using your help: How Do I Delete A Value Completely From A Field (Setting It To Null)?
    Delete a value completely from a field (setting it to null)
    Here's the solution to update a field to a blank (null) value.
    Set the value of the field that you want to make null to :empty: and then run your update.
    I used the :empty: this did not remove the values in the fields.

Powered by Zendesk