How can I set field value to Null using Web Console ?

Hi, I am using the web console (F12) to update fields such as external id on subsidiary record. I cannot find how to set the value of this field back to Null. Any idea please ?

Here is the command to update :

require([‘N/record’, ‘N/currentRecord’]);

var record = require(‘N/record’);

var currentRecord = require(‘N/currentRecord’);

var myCurrentRecord = currentRecord.get();

var subsidiaryRecord = record.load({
type: record.Type.SUBSIDIARY,
id: myCurrentRecord.id
});

subsidiaryRecord.setValue({
fieldId: ‘externalid’,
value: ‘BBB
});

subsidiaryRecord.save();

Rookie Asked on November 24, 2021 in Administration.
Add Comment
1 Answer(s)

Hi,

I’m afraid you can’t unset External IDs, you just have to set them to something else.

Thanks,

Chris

Intermediate Answered on November 24, 2021.

Thank you Chris. After more research I was close to this conclusion too. I will stop searching.

on November 25, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor