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

Is it possible to prevent a record from submitting and then display a custom error in a beforeSubmit user event script?

Trying to get an error for missing sublist fields (conditional which is why its in the script). I have a client script set up that works great, but client scripts wont work for csv uploads or integrations. Any ideas?

for CSV, throwing an error in a UE beforeSubmit entrypoint with result in the CSV line failing.
Not sure for your integrations

How do I throw an error in the UE beforeSubmit?

use the `N/error` module to create your error and `throw` it.
See the 2nd example on the <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4243798608#subsect_156779032837|N/error module help center page>

So I did that, here's my current code, this error only shows up in the script log though. I would like for it to display when the user tries to save the record. It feels like I am missing something very small and it's driving me crazy

So for your client script (in the saveRecord entrypoint) you'll want to `alert('missing required sublist fields')` (or similar)
_*<https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4410693749|and return false>*_

actually, just throwing the error in the CS <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4387798404#bridgehead_4484779426|should have worked>

The client script is working just fine, I am using the validateLine entry point with an alert and return false.

Any idea how to do that in a userEventScript though?

'that' meaning throw an error and prevent the record save. I thought I could prompt one of NS error pages with the message and a go back button. But I haven't been able to make that happen

read <https://stackoverflow.com/questions/38632350/how-to-show-the-custom-error-message-without-stack-trace-using-suitescript-2-0-i?rq=1|this SO answer> and <https://stackoverflow.com/questions/41294326/user-friendly-error-message-from-user-event-script-suitescript-2-0|this one>.
you used to be able to <https://stackoverflow.com/a/38662383|override the toString function>, or <https://stackoverflow.com/a/38662383|use css to hide the native error JSON object>. But it seems like both of those have been patched/have broken.

Simply using this in the UE beforeSubmit
```throw 'Missing Required Sublist Fields&lt;br&gt; alert string here';```
resulted in the user seeing this, which I think is satisfactory

it also resulted in the CSV import line failing, see below error
NOTE, if the user imports the CSV with suitescripts and workflows turned off, they will circumvent the validation. Consider other means of making sure CSV imports are valid

Interesting, I'll have to play around with it some more today. For some reason whenever I throw an error in that way it only appears in the script log and still allows the record to be saved. I almost wonder if there's a setting I don't know about. Thanks so much for investigating this and giving such good info!