Small and medium business | Business Central, N...

how to prevent a value of a field from getting modified?

(0) Share

Report

Posted on by AXBOY

625

Hi ALL,

Im quite new to D 365 BC. I have a requirement to prevent users from modifying the value of a field from standard table on a specific condition.

PLs HElp!

Thanks in Advance!

All responses (11)

Answers (0)

Sort by

Suggested answer

Asif365 1,431 on at

Like (0)

Report
Copy link

Link copied!

Please have a look at this post, this could help you

stoneridgesoftware.com/.../
AXBOY 625 on at

Like (0)

Report
Copy link

Link copied!

Hi Asif,

Can't we handle this situation through c/al code?

I don't have to disable the entire records of a table or grant permissions to specific users.

I have a field called Dimension Type in the standard table .

And when the Dimension Type : A, then i want the Dimension Value filed of that same record non editable or not get modified.

Pls help!
Suggested answer

Stefano Demiliani 37,172 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You can hanle the OnValidate trigger of this field and in this trigger place the code that manages your condition. Like:

If not (Your condition) then

error('You cannot modify this field');
AXBOY 625 on at

Like (0)

Report
Copy link

Link copied!

hi Setfano,

Actually its a standard table where i have to do this customization,

So i cant find the OnValidate() trigger on the table extension obejct of that standard table.

Pls help!
Suggested answer

Mohana Yadav 61,252 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

you have to subscribe to OnAfterValidate trigger in a codeunit.
AXBOY 625 on at

Like (0)

Report
Copy link

Link copied!

Okay and should i call this code unit in the table extension?
Suggested answer

Mohana Yadav 61,252 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

no, event subscribers will be called automatically once the standard table onvalidate trigger is fired.
AXBOY 625 on at

Like (0)

Report
Copy link

Link copied!

Okay so there is no need to create a table extension for that standard table.

I just have to create a code unit subscriing onAfterValidate event for that special field of the standard table.

And this custom code unit created will automatically be called whenever i change/modify the value for that field in the standard table.

Right Mohana?
Suggested answer

Stefano Demiliani 37,172 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Absolutely yes.

If it's a standard table, just write an event subscriber procedure to the OnAfterValidate trigger of the field you need.
AXBOY 625 on at

Like (0)

Report
Copy link

Link copied!

Hi ,

I tried using the event subscriber procedure to the OnAfterValidate trigger of the specified field.

But my Condition is if the :

if Rec. CodeType = Project and RecCodeValue <> ' '

and xRec.CodeValue <> Rec.CodeValue

then Error(Cant Chnage the Code Value)

Now in Code Unit using event subscriber procedure to the OnAfterValidate trigger, how can i achieve this above condition?