News and Announcements icon

Dynamics 365 CommunityForums Business Central forum AL: How to add custom ...

Business Central forum

AL: How to add custom validation to a field?

(0) Share

Report

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:

All responses Img

All responses (3)

Answers Img

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;

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans