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

Update field value after change other fields value

(0) Share

Report

Posted on by Maxim Rylev

Hi. In one of setup tables I created my new custom field. This field depends on value of five other fields - all these field must be 'true' if value of my custom field also can be 'true'.

So when user set 'false' value of one of these five fields - my custom field should change value to 'false'.

What is the most optimal way to achieve this?

Trigger OnModify() inside table? OnAfterModify Event Subcsriber in separate CodeUnit? Or maybe any other idea?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

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

Like (2)

Report
Hi, If I understand correctly, it's simple to do with OnValidate Trigger.

For example,

table 50112 MyTable2 { DataClassification = CustomerContent; fields { field(1; MyField; Integer) { DataClassification = CustomerContent; } field(2; A; Boolean) { DataClassification = CustomerContent; trigger OnValidate() begin if A = false then CustomField := false; end; } field(3; B; Boolean) { DataClassification = CustomerContent; trigger OnValidate() begin if B = false then CustomField := false; end; } field(4; C; Boolean) { DataClassification = CustomerContent; trigger OnValidate() begin if C = false then CustomField := false; end; } field(5; D; Boolean) { DataClassification = CustomerContent; trigger OnValidate() begin if D = false then CustomField := false; end; } field(6; E; Boolean) { DataClassification = CustomerContent; trigger OnValidate() begin if E = false then CustomField := false; end; } field(7; CustomField; Boolean) { DataClassification = CustomerContent; trigger OnValidate() begin if CustomField = true then begin A := true; B := true; C := true; D := true; E := true; end; end; } } }

PS: You can replace "If Boolean = true then" and "If Boolean = false then" with "If Boolean then" and "If not Boolean then".

Hope this helps.
Thanks.

ZHU

Was this reply helpful? Yes No
Maxim Rylev 75 on at

Like (0)

Report

Than you for your reply.

But what if the fields are standard fields? And I cant use On Validate triggers?

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,001 Super User 2025 Season 2 on at

Like (1)

Report

You have to subscribe to OnAfterValidate trigger of the field in a codeunit.

Was this reply helpful? Yes No
Maxim Rylev 75 on at

Like (0)

Report

But in situation when I need check five fields - more optimal is create 5 subscribers to OnAfterValisate triggers or maybe one subscriber to OnAfterModify?

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,001 Super User 2025 Season 2 on at

Like (1)

Report

If you want that code to be executed after modifying all fields then OnAfterModify trigger.

Otherwise, you can create a function and call the function in each field OnAfterValidate trigger.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

In addition to the codeunit mentioned by Mohana, you can also use tableextension directly.

For example,

If you want to change immediately, I recommend adding each field.
Or you consider enabling the following functions.

Business Central 2022 wave 2 (BC21) new features: Auto-save as you work -> Trigger timing of OnModify (Table) Trigger/OnModifyRecord (Page) Trigger has changed

https://yzhums.com/30730/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No