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

(0) Share

Report

Posted on by jdrco

481

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?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

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

A simple Example:

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi jdrco ,

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

Thanks.

Was this reply helpful? Yes No