[srussell]

I have a custom record type with a script that creates an externalid when a new record is entered. The externalid is a concatenation of several record fields, which should always be unique. When it is a duplicate the script throws an error, but the record gets created anyway. Is there a way for the script to catch that error and stop before the record gets created? I can probably do it with a search, but I’m wondering if there’s a simpler way.
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC]

What script trigger are you using? Before Submit, or After Submit?

[srussell]

After. For some reason I couldn’t get the scripted externalid to save on a before submit trigger.

[Olivier Gagnon NC]

Ok that’s why. After Submit, as the name implies, triggers after the record has been committed to the database. So any script errors do not prevent save – save already occurred.

If you cannot resolve the issue with External ID (there may indeed be a NS limitation there, I cannot recall off the top of my head), you would need to include a delete feature of your after submit script to destroy the record, rather than just throwing an error.

[srussell]

Makes sense. Thanks.

[Author]

Posts