This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi all, does anyone know if it is possible to increment a numeric field using `record.submitFields` without querying the record first?

I would like to use a formula or something like:
```record.submitFields({
  type: DROPSHIP_INVENTORY_TYPE,
  id,
  values: {
    custrecord_qc: '${custrecord_qc} + 1',
  },
  options: {
    enableSourcing: false,
    ignoreMandatoryFields: true,
  },
});```

I'm trying to make it atomic, is there anyway to wrap the get and submit in a transaction?

just do a lookup prior to the submit. Its fast and doesn't take hardly any governance. The other way would be to set a flag or something on the record since submitFields fires the UE you should be able to capture the flag and increment in another script if you must.

netsuite will throw an error if something else modifies the record between when you load and save it

Use <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_n2877583.html|Optimistic Locking> if you are working with a custom record