How to get a table record inside an OnValidate() trigger?

(0) Share

Report

Posted on by jdrco

479

Right now in a Sales Header table extension I have an OnValidate() trigger on one of the fields.
I initialized a Var inside this trigger of type "Record". I've applied a SetRange to get a single row, but trying to access a field on the record via Record.fieldname, results in an empty value.
I've tried using Record.get before the setrange but still no luck

How do I properly get a record in an OnValidate trigger?

All responses (2)

Answers (1)

Suggested answer

Nitin Verma 21,405 Moderator on at

Like (0)

Report

RE: How to get a table record inside an OnValidate() trigger?

Hi jdrco ,

Might be you had missed the findfirst after setrange and you are getting empty values, please use Zhu example.

Thanks.
Verified answer

YUN ZHU 78,978 Super User 2025 Season 1 on at

Like (0)

Report

RE: How to get a table record inside an OnValidate() trigger?

Hi, It looks like you are missing the Find function.

A simple Example:

Hope this helps.

Thanks.

ZHU