AL: How to add custom validation to a field?

(0) Share

Report

Posted on by SSDev1

150

Is there a way to make field validation use custom logic? For example, instead of something simple like requiring any numeric value, it might check the value in another table, check for a specific value, etc.

Categories:

Other

All responses (3)

Answers (0)

I Gusti Made Ari 3,594 on at

Like (0)

Report

RE: AL: How to add custom validation to a field?

For that , it can only use an expression for the ShowMandatory property, the property cannot validate a C/AL function. So in this case you cannot put logic to check value from other table.

detail :

docs.microsoft.com/.../showmandatory-property

alternatively is use the method i mentioned and pop up Error Message Box .
SSDev1 150 on at

Like (0)

Report

RE: AL: How to add custom validation to a field?

I mean more on a custom page field I have, For example:

Is it possible to use logic here, test the inputted value, and return true/false? Returning false would display the red X with the reason why it's not valid.
I Gusti Made Ari 3,594 on at

Like (0)

Report

RE: AL: How to add custom validation to a field?

You can use event subscriber by subscribing to the field you want to validate.

sample below will do validation on Location Code field at Sales Line table

[EventSubscriber(ObjectType::Table,37, 'OnAfterValidateEvent', 'Location Code', false, false)]

local procedure OnValidateLocationCode(var Rec : Record "Sales Line";var xRec : Record "Sales Line";CurrFieldNo : Integer)

begin

//Put your custom Logic Here

end;